Hibernate Community • View topic - using Restrictions with 'not in' clause in Criteria?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

using Restrictions with 'not in' clause in Criteria?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

arun231

Post subject: using Restrictions with 'not in' clause in Criteria?

Posted: Thu Jul 05, 2007 2:07 pm

Newbie

Joined: Thu Jan 04, 2007 1:36 pm
Posts: 16

How can I use the 'not in' command using the Restrictions or Expression in creating a Criteria instance?
For ex. the SQL may look like this:

Code:

select * from dummy d where d.id not in (select dummy_id from another_table)

Appreciate any suggestions provided.
Thanks.

Top

arun231

Post subject: found the solution

Posted: Thu Jul 05, 2007 6:07 pm

Newbie

Joined: Thu Jan 04, 2007 1:36 pm
Posts: 16

Never mind.. I digged a little deeper and found a solution:

Just created a DetachedCriteria and used that in the actual criteria which need to use the "not in" clause in its query...

Code:

criteria.add(Property.forName("id").notIn(detachedCriteria));

Thanks,
Arun

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum