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