Hi everyone,

I hope someone is able to help me in the right direction. I am trying to do all the mapping on our database, which unfortunately i am not able to modify. The problem is between two tables using composite keys.

I have the following two tables:

AppNo:


AppNo_prices:


Which is linked using the AppNo & Country as composite primiary keys.

Is this possible to do at all? Does anyone have any examples of this?

I have looked at the following examples:
http://java-aap.blogspot.com/2006/04/hibernate-annotations-composite.html
http://boris.kirzner.info/blog/archives/2008/07/19/hibernate-annotations-the-many-to-many-association-with-composite-key/

I have tried to use the @Embeddable in the same way, but they do not really do what i need.

Hibernate version:
Hibernate 3.2.1
Hibernate Annotations 3.4.0 GA

Thanks for all your help

Hello champ1

As far as I can understand from your sample, you're not dealing with Many-To-Many association, but with One-To-Many one.

Thus, my example is not exactly what you need, but you should make the things in the same spirit:

• Create a class (PK) for composite primary key and mark it with @Embeddable.
• Add a field of type PK to your class(es) and mark it with @EmbeddedId.
• Make sure you create and update the key either directly or using transient properties when this is required.

Hope this helps