Hello everybody,

I have two tables which have the same structure (field names,field types, and field order as well).
The primary key values in the two tables (primary key field ID - Long data type) are unique. If in the first table has contain record with ID value 1, then the second table 100% don't have any record with ID value 1 and so vice versa. Basically, if the contents of the two tables are merged into one table, it will not violate the primary key contraint.

The question is
Can one hibernate xml file and one hibernate Java Bean class handle/retrieve records from two tables ?



My detailed other information is :

Hibernate version:3.0.5

Mapping documents:no need

Code between sessionFactory.openSession() and session.close():no need

Full stack trace of any exception that occurs:no need

Name and version of the database you are using:Firebird 2.0

The generated SQL (show_sql=true):no need

Debug level Hibernate log excerpt:no need


I would appreciate much if any one give idea about merging the two tables into one Java Bean class without losing the record order.


Thank you very much.


Regards,
Ferry

Hi,
>>> Can one hibernate xml file and one hibernate Java Bean class handle/retrieve records from two tables ?

You will get a DuplicateMappingException if you try to map one class to two tables. Where you map ( in the same .hbm.xml file or many ) makes no difference.

>>>I would appreciate much if any one give idea about merging the two tables into one Java Bean class without losing the record order.

You can create a view on "union" of two tables. Then map entity class to this view. This allows you to get data from both tables seamlessly.

What is it that you call as record order ?

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