0 Replies Latest reply on May 22, 2007 3:39 AM by james nick

    Multiple Databases/datasources - plz helps

    james nick Newbie

      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,