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?
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.