Hi,

I have a requirement, which I am sure is one of its kind but I hope someone has an answer to that.

I have a case where we have multiple identical tables which needs to be associated with single Java Bean. So when I want to create a new record or update the existing record, my call to save or update should update all the three tables.


Any suggestions

Hi,
As far as I know, you cannot map one class to two tables. You will get DuplicateMappingException.

>>> So when I want to create a new record or update the existing record, my call to save or update should update all the three tables.

You can achieve this using database triggers. ( I don't know if your database supports them )

-----------------------------------------------------------
Rate the reply if you find it helpful

Hi Guys,

Just for the reference for everyone I was able to make this thing run. So here is the solution. It runs only on Hibernate3.x

To map the same JavaBean to two different tables you need to specify an entity-name attribute for class like this

Default mapping

<class name="Customer" table="CUSTOMER">
...
</class

Save by calling session.saveOrUpdate(customer);

Duplicate mapping for different table

<class name="Customer" table="HIST_CUSTOMER" entity-name="CustomerHist">
...
</class

Save by calling session.saveOrUpdate("CustomerHist", customer);

I hope it helps somebody

Regards,
Mahen