Hibernate Community • View topic - Hibernate Query: using not in

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Hibernate Query: using not in

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

cairo

Post subject: Hibernate Query: using not in

Posted: Sun Dec 21, 2003 9:55 am

Newbie

Joined: Mon Dec 08, 2003 6:33 am
Posts: 5

How to do a query with

Code:

not in

given list

List stateList;
e.g select count(*) from Person p where p.state not in ?, stateList

Top

michael

Post subject:

Posted: Sun Dec 21, 2003 10:15 am

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

You should be able to do this:
session.createQuery("select count(*) from Person p where p.state not in (:stateList)").setParameter("stateList", stateList).uniqueResult();

Top

cairo

Post subject:

Posted: Mon Dec 22, 2003 2:49 am

Newbie

Joined: Mon Dec 08, 2003 6:33 am
Posts: 5

Thanks, gloeglm.

Top

michael

Post subject:

Posted: Mon Dec 22, 2003 6:07 am

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

This should be .setParameterList() actually

Top

Page 1 of 1

[ 4 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