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,