2 Replies Latest reply on Jan 31, 2002 11:24 AM by Sjus

    Several XADataSourceLoaders for just one database

    Sjus Newbie

      Is it possible to configure two or more XADataSourceLoaders to just one Database.
      As I tried this I've got an
      javax.naming.NameAlreadyBoundException.

      I want to configure two or more pools to just one database. So when one of this connectionpools hasnt any free connections left for an user, the database user could be switched to the next pool to reach the database.

      Many Thanks in Advance!
      Sjus

        • 1. Re: Several XADataSourceLoaders for just one database
          Alexander Lepekhine Newbie

          I'm not sure that it's good idea. It is much easier to encrease existing connection pool limit. I know that Oracle has special method setMaxLimit(int limit) for it's connection cache implementation. Try to search something similar in JBoss.

          • 2. Re: Several XADataSourceLoaders for just one database
            Sjus Newbie

            I tried to increase the pool size with the attributes from the ConnectionpoolMBean (XADatasourceloader). But it really has not any effect when the pool is running.

            So I'm looking for alternatives to increase the size.

            But with two XADatasourceloaders there is the problem:
            Server.run/init: java.sql.SQLException: The database is already in use by another process.

            Has maybe somebody any effort increasing databaseconnectionpool during jboss is running?

            thanx
            Sjus