jQuery in Action, 3rd edition
The moose likes Object Relational Mapping and the fly likes Question in Hibernate Criteria Query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Reply locked New topic

Question in Hibernate Criteria Query

Saravanan Vijayappan
Ranch Hand

Joined: Jan 02, 2007
Posts: 47

Could any one please help, I referred so many articles but don't get information. I have question in my below Criteria query:-

When you closely look at the query, the association is, Menugroups--(1 to many)-->Catgroups---(1 to many)---> Dealitems. I have configured lazy fetching and have set up batch-size=10 in config file.

When the above query is fired, hibernate generates the below sqls,

My issue here is, the one of the criteria restriction published=true is not applied in the 2nd SQLs. So I am getting unpublished catgroups in the result. Could any one help please what is wrong in my Criteria query and what needs to be added more ?

Reply is appreciated.

[ July 12, 2008: Message edited by: Saravanan Vijayappan ]

Cheers,<br />Sarav
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

Please refrain from duplicate posting. I am going to close this dup thread. I am sorry someone hasn't answered the other thread, but hopefully someone will soon.


Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
I agree. Here's the link: http://aspose.com/file-tools
subject: Question in Hibernate Criteria Query
It's not a secret anymore!