Can I use 2 different databases with JBoss?

dakbari Feb 13, 2008 3:13 AM

Can I use 2 different databases with JBoss? Are there some guidelines?

Any hints are welcome :)

1. Re: Can I use 2 different databases with JBoss?

dakbari Feb 13, 2008 3:22 AM (in response to dakbari)

I think of using 2 data source XML files. What I want is, to use 2 Oracle DBs one ProdDB and one ArchiveDB so I can move stuff from ProdDB to ArchiveDB.

So far I had JBoss with one Oracle DB using one oracle-ds.xml file. But now I think I've to use 2 oracle-ds.xml files like oracle-prod-ds.xml and oracle-archive-ds.xml.

But is that really all?

Regards,
darya
Actions
2. Re: Can I use 2 different databases with JBoss?

peterj Feb 13, 2008 10:04 AM (in response to dakbari)

Yes, that is all there is to it. The key is the jndi-name in both of the *-ds.xml file. They must be different, and you application uses the jndi-name of the database that it wants to use.

Oh, and one other thing. Make sure that the total for maximum number of connections does not exceed the number of connections the database allows.
Actions