Multiple databases & foreign key

ego · **Joined:** Mon May 01, 2006 6:14 am **Posts:** 6

Hey,

do you know if it is possible to have 2 entities into 2 differents databases with a one-to-one relation (or one-to-many) ?
If yes, could you please give me a simple configuration file that maps this situation ?

Thanks

sberna · **Joined:** Wed Feb 16, 2005 5:56 am **Posts:** 6

Sorry but hibernate database configuration is done at session level, and as far as i know you cannot map together objects from different sessions since it will raise a configuration error.

The fastest would be configuring a remote link between both datases (dblink in oracle for example) so that you are able to see both tables from the same jdbc connection.

ego · **Joined:** Mon May 01, 2006 6:14 am **Posts:** 6

ok, thanks !