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 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's not joining the correct fields...I would have expected this query:

Even though I specified the key fields to join'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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Incorrect joins on composite ID
It's not a secret anymore!