A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Object Relational Mapping
comparing two table - hibernate criteria
Joined: Mar 08, 2011
Jul 17, 2011 00:26:12
i have two tables A and B, now i need to compare two tables i.e. (select id form A) - (select id from B)
i can do this with sql query like
SELECT * FROM A WHERE NOT EXISTS (SELECT * FROM B WHERE A.Id = B.Id)
but how can i achieve the same with hibernate criteria
any help would be appreciated.
It is sorta covered in the
JavaRanch Style Guide
subject: comparing two table - hibernate criteria
Hibernate Performance for CRITERIA / SELECT Queries..
Criteria on joining fails
Criteria with IN clause that comes from a sub sql
Hibernate:Trying to emunate select * from my_table where ID in ('MOSU0002','MOSU0003') in Hibernate
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013