Hibernate version:3.1

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

Is it possible to execute a query (in SQL or HQL) over a set of different database systems?

Example: execute a query over the table Person (stored in SQL Server 2005) and Address stored in My SQL.


If it is not possible I would also appreciate solutions for this type of problem.


TIA,

Bruno

Here is some meager information to keep the thread alive :)

You can do distributed transaction in a J2EE environment
http://java.sun.com/products/jta/

You can point your Hibernate DAOs to the proper datasource.

It's pretty simple to integrate JTA if you use something like spring, other options possible.
http://www.springframework.org/docs/reference/orm.html

So if nothing else you can download results set/object trees from the 2 database servers and you can merge the final data in the code.

Marius