Multiple databases

lisa_r Sep 15, 2005 5:15 AM

Hi,
We have a system that have 2 databases. One for storing data that the
customer provides and one for storing data about the system.
We use BMP entity beans to query the system database.

Now to my question. Is it possible to let multiple customers run against
the same JBoss server if each customer have their own set of databases?
What will for instance happen with the entity pool and the database
connection pool?

Thanks!:-)

1. Re: Multiple databases

sriramp_here Sep 22, 2005 8:07 AM (in response to lisa_r)

You can use the same jboss server to connect to differnet database server. You can add the two database configurations in the same oracle-ds.xml.
Actions
2. Re: Multiple databases

lisa_r Sep 22, 2005 9:21 AM (in response to lisa_r)

Thanks for your replay!
What about the entity pool can JBoss separate entities from the different
customer databases?
Actions
3. Re: Multiple databases

raja05 Sep 23, 2005 1:19 PM (in response to lisa_r)

You should be able to deploy two instances of the EJB(bound for different customers) and allocate entity pool instances for each of them.
Actions
4. Re: Multiple databases

lisa_r Sep 26, 2005 2:34 AM (in response to lisa_r)

Thanks raja!
If I understand you right you should put one entry for each customer
entity bean in the jboss.xml file with different jndi-names. Is that right?

How do you allocate entity pool instances?
Actions

Go to original post