How to use Not In Function in Hibernate using Expression

rsdara6 · **Joined:** Tue Jan 30, 2007 4:18 am **Posts:** 1

Hi Hibernate Experts,

Since 6 months I started using Hibernate in my application.
Currently I got a requirement to use "Not In" function in Hibernate.

Example Query:

SELECT * FROM V_NEWS_SUBJECT WHERE ID NOT IN (118,117,114,113,112,111,108,104,103,102,94,93,92,89,88,87)

I have observed that Hibernate has only IN function.

How to convert the above Query in Hibernate using "Expression"?

Can any one of you advise me how to implement this in Hibernate?

Immediate response would be appreciated.

Please do the needful.

Regards,

Rajasekhar Dara.

i92absaj · **Posted:** Tue Jan 30, 2007 4:42 am

rsdara6 wrote:

Hi Hibernate Experts,
Example Query:
SELECT * FROM V_NEWS_SUBJECT WHERE ID NOT IN (118,117,114,113,112,111,108,104,103,102,94,93,92,89,88,87)

Hello
You could use Criteria Queries:
http://www.hibernate.org/hib_docs/v3/re ... g-criteria

The idea is to add a restrictions like the below one:

Code:

Criteria criterio = session.createCriteria(XXX.class);
Vector<Integer> foo =new Vector<Integer>();
foo.add(118);
foo.add(117);
[...]
foo.add(87);

criterio.add(
   Restrictions.not(
      Restrictions.in("V_NEWS_SUBJECT", foo)
   ) 
);

dharmendra.pandey · **Posted:** Wed Jan 31, 2007 9:28 am

Hi i92absaj,

Hibernate 3.1 support to use not in

Ex

from AbcVO as abcVO where abcVO.xyz not in('243243')