10/15/2004 5:05:33 AM
Lionel <> wrote in message
<416f92db$0$563$626a14ce@news.free.fr>

What about simply creating one JDBC DSN that connects you to all the
different databases? If you want to investigate this approach then
take a look at OpenLink Virtuoso at: http://virtuoso.openlinksw.com .
It allows you to make one JDBC connection to several ODBC or JDBC
Data Sources that are bound to a variety of backend databases.
Alternatively, you can have Hibernate simply bind to one data source,
since Virtuoso can produce Well-Formed and/or Valid XML data (that is
accessible via HTTP/WebDAV) from heterogeneous ODBC or JDBC data
sources on the Fly (using; SQLX, SQL-XML, XML-SQL Schema Mapping).
So you can give Hibernate a DSN or a URI to an XML doc, in both cases
the underlying heterogeneous data sources are unified without you
writing code to handle the complexity of this effort.

Regards,

Kingsley Idehen   Weblog: http://www.openlinksw.com/blog/~kidehen
OpenLink Software        Web: http://www.openlinksw.com
Universal Data Access & Universal Integration Middleware Providers.

There should be a way to pass java.sql.Connection to Hibernate when
openning session, and it will use that connection instead.

PS I didn't work with Hibernate 2.0 and 2.1, there may be actually
better way to do that.

Boris