This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes querying two tables using criteria Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "querying two tables using criteria" Watch "querying two tables using criteria" New topic
Author

querying two tables using criteria

Manon Baratt
Ranch Hand

Joined: Jan 30, 2006
Posts: 58
Hi,

I have two tables that share the same heading_key column. I am using the following statement using criteria to retrieve the headingcode:

my xml files are defined:

customer:

Heading:

The query I get from hibernate is:

Which is what I want minus the second to the last line. What I am doing wrong?

Thanks for your help.

 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: querying two tables using criteria
 
jQuery in Action, 3rd edition