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.