Hi everyone,

I have two different tables (say Table1 and Table2) in two different databases (says DB1 and DB2).

The databases are linked though a DB Link object which allows me to only connect to DB1 and select table2(without connecting to DB2).

I created a synonym for table2 on DB1 to make it easier to read the selects.

Table1 has a composite PK composed of an ID and a year.
Table2 has a single value PK composed of an ID.
Both IDs are the same and there is no explicit constraint between those tables.

I need to map some attributes of Table1 and some attributes of Table2 in the same Java class.
Is that possible with Hibernate ?
Is that possible using Hibernate tools ?

Thanks for reading up to here and for any answer :)

Hibernate Tools does not support reverse engineering of these constructs.

Hibernate core does though support the notion of <join> to fetch additional data into a bean.

thank you very much for such a quick answer