[JBoss-user] ASP Model for J2EE?

[Jeff Campbell]

I'm stumped...   What is the best approach for using J2EE in an Application Service Provider (ASP) scenario?   Info:  I have a J2EE ear file that I deploy on my JBOSS J2EE container.  I would like to have multiple companies use this application, without sharing data.   Here is a list of possibilities...  (some may be completely WRONG)....  what is the best approach?   1. Give each company their own IP address, JBOSS container, and Database.   or   2. Have one IP address, one JBOSS container, multiple Databases and have JBoss some how dynamically switch datasources. (I have no idea how to do this) (This is the method that I would prefer, if it were possible)   or   3. Have one IP address, one JBOSS container, one Database (but have to go through and add a column to each table, and query specifying the company ID) (I would hate to have to do this one).   Any other suggestions would be HELPFUL!   Thanks, Jeff Campbell