<query name="getNotInClassesTeacher"><![CDATA[from Teacher where id not in ( select c.teachers.id from Classes c where c.id=:classesid )]]></query>
public List getNotInClassesTeacher(String classesid) ...{
Session session=this.getSession(); Query query=session.getNamedQuery("getNotInClassesTeacher"); query.setParameter("classesid", classesid); return query.list();
}