Register / Login
File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
Object Relational Mapping
comparing two table - hibernate criteria
posted 4 years ago
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.
I agree. Here's the link:
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