Hi All,

I am newbie to hibernate, My question is ..

Using hibernate can we execute a SQL query which is across multiple database? (as far as I know one session/transaction you can get it from only one sessionfactory and sessionfactory is bind to particular database connection but just curious if it can be done in some way using HQL)

For ex: I have Table A in SQLServer , and Table B in Oracle and I would like to join these tables and get the data out of it.

Any help would be appreciated.

Regards,
Ram

The Hibernate Session takes its lead from the hibernate.cfg.xml file, which as you can see, only points to one database.

An application can use multiple Session objects, and perhaps have each of those dedicated to a particular database. That would allow your program to hit multiple databases within a program, although you wouldn't be able to hit multiple databases with a single query through a single Hibernate Session.

There is a Hibernate module called Shards which hasn't quite gone GA yet which is focussed at solving this multiple databases with Hibernate problem.

Hope that helps!

Thanks a lot Cameron , this really helps.

Best Regards,
Ram