Hi,

I need a little advice. I'm using version 2.1 of Hibernate.

I have 3 tables

ORDER
ORDER_SEQ (pk)
ORDER_ID
ORDER_NAME

ORDER_GRP_RLT
ORDER_SEQ (fk)
ORDER_GRP_SEQ (fk)

ORDER_GRP
ORDER_GRP_SEQ (pk)
TYPE


When I create an Order, I can create the OrderGrp using a <many-to-many> without any problem.

What I am having a problem with, is that I need to associate existing Orders to the Order group I just created.

Example:

Order
001
ID1
Order1

OO2
ID2
Order2

OrderGrpRlt
002
002

001 <---(This is the relationship back to order 1)
001

OrderGrp
001
TypeA

When I'm createing Order 2, I have to make the association to Order1 which is already in the DB.
How do I do this?

Thanks For you Help.
Chris...

Hi, please take a look at the parent-child-relationship chapter of the docs. Just load the existing object and set up the references appropriately.

I have setup the lists correctly.
Class A ---> Class B ---> Class C

Class A and C reference the same table and are related via 2 <many-to-many> relationships.

I'm able to insert the data correctly, but when I try to read the data, I get the following exception:

Caused by: net.sf.hibernate.WrongClassException: Object with id: 7559 was not of the specified subclass: com.level3.imagestore.persistence.wrapper.RelatedServiceOrderWrapper (loaded object was of wrong class)

After looking at:
net.sf.hibernate.engine.Key class, I would question the hashCode and equals implementation.

The point is that I should be able to reference the same table from as many different classes as I want.

Chris Kohle
Level(3) Communications.

You cannot have the same row associated to 2 instances in a single session at the same time.
Thus, you can map several classes on the same table but be aware that 1 row is loaded in only 1 class.