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 ?