4 Replies Latest reply on Sep 26, 2005 2:34 AM by lisa_r

    Multiple databases

    lisa_r

      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

          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.

          • 2. Re: Multiple databases
            lisa_r

            Thanks for your replay!
            What about the entity pool can JBoss separate entities from the different
            customer databases?

            • 3. Re: Multiple databases
              raja05

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

              • 4. Re: Multiple databases
                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?