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

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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...