5 Replies Latest reply on May 17, 2006 5:24 PM by Weston M. Price

    JBossManagedConnectionPool PROBLEM

    Roberto Leiva Newbie

      i have:
      Release ID: JBoss [Zion] 4.0.4.GA (build: CVSTag=JBoss_4_0_4_GA date=200605151000)
      Oracle 9i ver 9.2.0.7.0
      and i use this file:
      ******* oracle-ds.xml

      <local-tx-datasource>
      <jndi-name>OracleDS9i</jndi-name>
      <use-java-context>false</use-java-context>
      <connection-url>jdbc:oracle:thin:@192.168.1.7:1521:base</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>user</user-name>
      <*password>pass</*password>
      <min-pool-size>5</min-pool-size>
      <max-pool-size>100</max-pool-size>
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

      <type-mapping>Oracle9i</type-mapping>

      </local-tx-datasource>

      ********

      and the log server is :

      17:25:28,093 WARN [JBossManagedConnectionPool] Destroying connection that could not be successfully matched: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@f23491[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1e140bf handles=0 lastUse=1147900924541 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@1c1a68b context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@9d2f26 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@161bfa3 txSync=null]


      i think that pool managment allways create a new connection and never return existing connection.

      how to solve this problem ??

      regards.
      --
      Roberto Leiva M.
      Santiago - Chile