my dog learned polymorphism*
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

querying two tables using criteria

Manon Baratt
Ranch Hand

Joined: Jan 30, 2006
Posts: 58

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:



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.

Consider Paul's rocket mass heater.
subject: querying two tables using criteria
Similar Threads
hibernate update in single transcation
Native SQL in Mapping File For a Property
What does hibernate think is "dirty" here?
hibernate, ant task, hbm2java, code generation and circular dendency?
Hibernate Select - Criteria with a Date