2 Replies Latest reply on Jan 7, 2002 11:04 AM by mjprima

    Connection Pooling

    mjprima
    mjprima Jan 4, 2002 3:39 PM

      When declaring datasources to be pooled in jboss.jcml you declare a MinSize and MaxSize. From what I can tell this tells JBoss how many connections to maintain to the given datasource.

      How does the MinSize and MaxSize for the ConnectionManagerFactory that is set in the ConnectionManagerProperties relate to the number of connections declared in the datasource pool?



      • 4105 Views
      • Tags:
        • 1. Re: Connection Pooling
          davidjencks
          davidjencks Jan 5, 2002 12:48 AM (in response to mjprima)

          Quote the relevant xml. I don't know what you are referring to.

            • Actions
          • 2. Re: Connection Pooling
            mjprima
            mjprima Jan 7, 2002 11:04 AM (in response to mjprima)

            Here are the portions of the jboss.jcml file I am reffering to:

            Does the MinSize/MaxSize in the first section relate in any way to the MinSize/MaxSize in the second section?

            SECTION 1


            jdbc/dbPoolDS
            org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
            jdbc:sybase:Tds:$$SERVERCOMPUTERNAME$$:$$SERVERPORTNUMBER$$?ServiceName=dbname
            $$USERNAME$$
            $$PASSWORD$$
            25
            25


            SECTION 2


            MinervaDS
            JCA:service=RARDeployer

            Minerva JDBC LocalTransaction ResourceAdapter


            ConnectionURL=jdbc:HypersonicSQL:hsql://localhost:1476



            MinervaSharedLocalCMFactory

            <!-- See the documentation for the specific connection manager
            implementation you are using for the properties you can set -->

            # Pool type - uncomment to force, otherwise it is the default
            #PoolConfiguration=per-factory

            # Connection pooling properties - see
            # org.jboss.pool.PoolParameters
            MinSize=0
            MaxSize=10
            Blocking=true
            GCEnabled=false
            IdleTimeoutEnabled=false
            InvalidateOnError=false
            TrackLastUsed=false
            GCIntervalMillis=120000
            GCMinIdleMillis=1200000
            IdleTimeoutMillis=1800000
            MaxIdleTimeoutPercent=1.0

              • Actions