2 Replies Latest reply on Feb 13, 2008 10:04 AM by Peter Johnson

    Can I use 2 different databases with JBoss?

    dakbari Newbie

      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 Newbie

          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

          • 2. Re: Can I use 2 different databases with JBoss?
            Peter Johnson Master

            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.