using NOT IN clause in criteria query

Asked Apr 16 '16 at 14:25

Active Apr 16 '16 at 18:33

Viewed 709 times

it may seem like duplicate question but my problem is not solving. i have following tables:-

------------------------------------------------------
  student                        student_fine
   st_id                           fine_id
   st_name                         fine_description
   st_class                        fine_amount
                                   st_id
 -------------------------------------------------------

 query required: "SELECT * FROM STUDENT WHERE STUDENT.ST_ID NOT IN 
                  (SELECT STUDENT_FINE.ST_ID FROM STUDENT)"

 criteria query code i used:
 Criteria criteria = session.createCriteria(Student.class); 
 DetachedCriteria detachedcriteria = DetachedCriteria.forClass(StudentFine.class); 
 detachedcriteria.setProjection(Property.forName("st_id")); 
 criteria.add(Property.forName("st_id").notIn(detachedcriteria)); 
  ...

i am getting a list with no records while sql command line returns 2 records. what am i doing wrong?

edited Apr 16 '16 at 18:33

wildplasser

43,142
8
66
109

asked Apr 16 '16 at 14:25

jaykio77

You got confused by your own caps: `(SELECT STUDENT_FINE.ST_ID FROM STUDENT)` -->> `(SELECT ST_ID FROM STUDENT_FINE) – wildplasser Apr 16 '16 at 16:26
thanks for correction. – jaykio77 Apr 16 '16 at 18:19
Please don't correct the error in the question. [ I rolled it back to the 1st version] – wildplasser Apr 16 '16 at 18:34
If you correct the error in the question, nobody else will be able to figure out what the error was. That's why not to correct it. :) – BobRodes Apr 16 '16 at 19:37

using NOT IN clause in criteria query

0 Answers0