wood burning stoves
The moose likes Object Relational Mapping and the fly likes Incorrect joins on composite ID Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Incorrect joins on composite ID" Watch "Incorrect joins on composite ID" New topic

Incorrect joins on composite ID

Vinnie Jenks
Ranch Hand

Joined: Apr 26, 2004
Posts: 207
I've got a simple parent/child relationship between two tables/objects but both tables have composite IDs. I'm able to query them but the joins are not correct.

Here are the details...

parent mapping:

child mapping:

The query that is returned:

Notice the join criteria...it's not joining the correct fields...I would have expected this query:

Even though I specified the key fields to join on...it's using the primary key(s) from the parent mapping (or so it appears.)

What am I doing wrong?


Hibernate version: 3.1

Name and version of the database you are using: MSSQL 2000
mysha ahamed

Joined: Aug 03, 2005
Posts: 22
Did u solve this problem...I also want to join on specific keys,instead hibernate joins on only primary keys..
I agree. Here's the link: http://aspose.com/file-tools
subject: Incorrect joins on composite ID
jQuery in Action, 3rd edition