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

    Connection Pooling

    Mark Judd Newbie

      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?



        • 1. Re: Connection Pooling
          David Jencks Master

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

          • 2. Re: Connection Pooling
            Mark Judd Newbie

            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