[jboss-user] [Installation, Configuration DEPLOYMENT] - Re: Can I use 2 different databases with JBoss?

2008-02-13 Thread 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

[jboss-user] [Installation, Configuration DEPLOYMENT] - Re: Can I use 2 different databases with JBoss?

2008-02-13 Thread PeterJ
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