Hibernate Community • View topic - Join tables from 2 different databases

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Join tables from 2 different databases

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

parus

Post subject: Join tables from 2 different databases

Posted: Thu Feb 14, 2008 5:59 am

Newbie

Joined: Thu Feb 14, 2008 5:34 am
Posts: 8

I wonder if it's possible to join 2 or more tables from 2 different databases.
I have two MS SQL 2005 databases and it's not possible to put them in one database, but some tables from the 2 databases are related.
I can't find this issue in the manual, so I think it's not possible or am I wrong?

Top

DavidHogue

Post subject:

Posted: Thu Feb 14, 2008 1:01 pm

Newbie

Joined: Wed Jan 30, 2008 4:43 pm
Posts: 9
Location: Bend, OR

I haven't tried with NHibernate, but I know with sql you can do this:

select * from database1.dbo.tableA a inner join database2.dbo.tableB b on a.id = b.id

Therefore you might be able to add a mapping with table="database2.dbo.tableB". (or even table="database2..tableB".) If this does work it might only work on SQL Server.

Last edited by DavidHogue on Thu Feb 14, 2008 1:05 pm, edited 1 time in total.

Top

DavidHogue

Post subject:

Posted: Thu Feb 14, 2008 1:04 pm

Newbie

Joined: Wed Jan 30, 2008 4:43 pm
Posts: 9
Location: Bend, OR

Sorry, double posted.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum