[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Multiple Databases/datasources - plz helps

[jboss2007]

Hi all,

How to define/configure multiple databases/datasources with jboss-seam hibernate ?

I have at least 3 databases : hsql, mysql and oracle. 
In the datasource xml config file mydatabase-ds.xml, I can define many datasources (many <local-tx-datasource> elements). However, in the hibernate.cfg.xml, I can define at most one session factory(=one datasource)!

NB: I don't need to use the persistence API, I'd like just to use several select queries from several databases.

Any idea or example ?

Thanks, 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4047452#4047452

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4047452