Hibernate Community • View topic - question about criteria

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

question about criteria

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

Ron

Post subject: question about criteria

Posted: Mon Oct 17, 2005 5:14 am

Newbie

Joined: Wed Apr 13, 2005 8:10 am
Posts: 15

Hi,

I have the following model:

Person (pid)
Job ( fk_pid, job )

so its one-to-many.

Using the criteria API, I need to generate a query which check for all persons with a certain List of jobs:

in SQL it would look like

Code:

select pid from Person 
where 3 = count( 
  select * from Job 
  where pid = fk_pid
    and job in ( a , b , c ) 
);

How do I create such a criteria?
Thanx in advance,
Ron

Top

Page 1 of 1

[ 1 post ]

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