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

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3849702#3849702

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3849702


-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to