4 Replies Latest reply on Jan 16, 2011 5:54 PM by Rajasundaram Gopalan

    Connection Pool Oracle 10g Jboss 4.2.3 GA problem

    Rajasundaram Gopalan Novice

      Connection Pool when connections are available in the pool still it creates new connections. We checked the database sessions only 5 sessions are active but in the connection pool there are 20 connections.

       


      Environment Jboss 4.2.3 GA
      Oracle 10g
      no-tx-support - oracle-ds.xml

       

      <datasources>
        <no-tx-datasource>
          <jndi-name>DSNAME</jndi-name>
          <connection-url>jdbc:oracle:thin:@HOST:1522:SERVICE_NAME</connection-url>
          <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
          <user-name>USER</user-name>
          <password>PASS</password>
          <min-pool-size>1</min-pool-size> 
          <max-pool-size>30</max-pool-size> 
          <query-timeout>60</query-timeout>
          <track-statements>true</track-statements>
          <idle-timeout-minutes>5</idle-timeout-minutes>
          <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
          <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
          <!-- Checks the Oracle error codes and messages for fatal errors -->
          <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
              <!-- sql to call when connection is created -->
              <new-connection-sql>select * from dual</new-connection-sql>
              <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered -->
              <check-valid-connection-sql>select * from dual</check-valid-connection-sql>
            <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
            <metadata>
               <type-mapping>Oracle9i</type-mapping>
            </metadata>
        </no-tx-datasource>
      </datasources>

       

      Advance thanks for your help