0 Replies Latest reply on Sep 28, 2004 5:06 AM by krypton

    Hibernate Using Multiple Databases

    krypton Novice

      Hi,

      I have an application that has up to 100 databases, each has the same schema/table structure. We are migrating to jboss/hibernate but I am not sure how to map the application to different databases using hibernate/jboss

      1) We could use 1 database and redesign the schema to support the notion of companyId so that all the data lives in one database (remember all the schemas are the same)

      2) Provide a datasource per company, but this now means 100+ datasources.

      Can anyone provide some advice about the best option w.r.t. migration to jboss ?

      Thanks

      Mathew