can you create a join with a composite key in hibernate... I have this oracle table that has a composite key that is two of its fields for the primary key but I want to be able to join it to another table that also has these keys... but I am having trouble creating such a join... the table that has the table that has the composite key has a one to may relationship with the other table....

No problem, Hibernate can do it. Show us the mapping you did... Even if it doesn't work yet...

I'd advice you to first create a javabean class that will have only those two properties and their getter/setter. This class will obviously represent the primary key/foreign key. You'll then use it in the mapping, read the reference doc:

* How to map a composite-id: http://www.hibernate.org/hib_docs/v3/re ... ompositeid
This will give you a mapping like:


* How to use it in a foreign-key mapping. In your case, you say this is a one-to-many relationship, so it means that it's kind of a collection mapping that you need. So you simply need to map a usual collection on the "one" side, and map the foreign-key on the "many" one (quite in a way close to what you'd with SQL: the constraint can only be from the collection elements to the container, not the contrary).

Declare a field of YourId type in the child element and map it this way:


Hope this helps, bye suzie.

how do create the getter and setter for the join

Look at the ref doc. Then ask precise questions.
Bye.