5 Replies Latest reply on May 18, 2002 12:05 AM by davidjencks

    Share DataSource across multiple JBoss servers

    max_goff

      Hello,
      The members of the development team that I am part of, have got JBoss installed on each of their machines. We use CMP exclusively. All of us use 'OracleDS' datasource to connect to Oracle. This leads to many Oracle sessions being opened. We have reduced the 'MaxSize' parameter in OracleDS service' xml file. Still, the problem persists.

      What I am looking for is a solution wherein all the JBoss servers use the DataSource configured on a single other JBoss server. Is this possible? What would it take to do this with or without Clustering?
      Thanks....

        • 1. Re: Share DataSource across multiple JBoss servers
          davidjencks

          This is not possible, nor do I see why it should be. Perhaps you need to reduce the maxsize in the pools.

          IMO if you wish to run many servers against one db instance you should make sure the db instance is configured to handle the load.

          Is there some reason you don't give each developer their own copy of the database?

          • 2. Re: Share DataSource across multiple JBoss servers
            max_goff

            OK David... thanks. I get it. Just one thing I need to know now.

            I have configured OracleDS on my machine to have MaxSize=5. With this setting, I am assuming JBoss will open a maximum of 5 sessions from my machine in Oracle(Oracle installed on a different machine). i.e. if I were to look in Oracle Enterprise Manager for the number of sessions opened from my machine, at any time I expect the number not to exceed 5. But I can see that the number is more than 5; sometimes 15 or 17 or something like that. Help me out here...

            • 3. Re: Share DataSource across multiple JBoss servers
              davidjencks

              Which jboss?? I remember someone complaining about something like this with a 2.? version, which I would rather not get into. If it is jboss 3 rc2 or later I would be very interested in the details.

              • 4. Re: Share DataSource across multiple JBoss servers
                max_goff

                We have JBoss3alpha. Should we move to jboss3rc2?

                • 5. Re: Share DataSource across multiple JBoss servers
                  davidjencks

                  You should definitely move to rc2. I think alpha still had the code that may have had that problem. You will have to replace your datasource configuration completely. Samples are in docs/examples/jca. Read them carefully, you have to set up a *-service.xml file and also an entry in login-conf.xml.