Hi All

I am trying use the Single Entity Mapped to Multiple Tables . I have two tables Order and OrderHistory. Order is given the entity-name ''OrderObj'' and ''OrderHist'' respectively

when the
HibernateUtil.beginTransaction()
getSession().save(''OrderObj'',order) and
getSession().save(''OrderHist'',order)
HibernateUtil.commitTransaction()

are called within the same transaction only
OrderObj is saved and not OrderHist

but if they are saved by starting different transactions both of them are saved .
HibernateUtil.beginTransaction()
getSession().save(''OrderObj'',order)
HibernateUtil.commitTransaction()

HibernateUtil.beginTransaction()
getSession().save(''OrderHist'',order)
HibernateUtil.commitTransaction()

what may be the issue.

Both the tables have the same columns names except one extra column in OrderHist

Please advise

Inside a single Hibernate session each object must be unique, so you can't use the same 'order' instance to represent two different entities. In the first code example, I guess Hibernate simply ignores the second call to save() since the object has already been saved. To get this to work you need to clone the 'order' object.

The reason that the second code example works is probably hidden in the HibernateUtil.beginTransaction(). If this creates a new session or clears the old session then I guess it is valid to re-save the same instance with a different entity-name.