[jboss-user] [JCA/JBoss] - Re: Problem for JNDI database connection pooling

"vickyk" wrote : Spend some time to view the "Connection leak" section here | http://www.jboss.org/community/wiki/FAQJBossJCA | Thanks.I have read the docs. What i mentioned above happends when i executing an operation.Before executing i monitor the ds "JBossManagedConnectionPool" MBean attribute description page,everything is ok,the value of "InUseConnectionCount" attribute is 0,means there are no connections that not closed,and the value of "AvailableConnectionCount" is 30,means there are idle connections for use. oracle-ds.xml | <?xml version="1.0" encoding="UTF-8"?> | | <datasources> | <local-tx-datasource> | <jndi-name>oracleDs</jndi-name> | <connection-url>jdbc:oracle:thin:@10.10.1.31:1521:ora9i</connection-url> | <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> | <security-domain>EncryptDBPassword4</security-domain> | <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> | <metadata> | <type-mapping>Oracle9i</type-mapping> | </metadata> | <min-pool-size>10</min-pool-size> | <max-pool-size>30</max-pool-size> | <blocking-timeout-millis>60000</blocking-timeout-millis> | <idle-timeout-minutes>15</idle-timeout-minutes> | <new-connection-sql>SELECT COUNT(*) FROM dual</new-connection-sql> | <check-valid-connection-sql>SELECT COUNT(*) FROM dual</check-valid-connection-sql> | </local-tx-datasource> | </datasources> | the threadDump after executing an operation: | ...... | Thread: ajp-10.10.0.42-8009-7 : priority:5, demon:true, threadId:500, threadState:BLOCKED, lockName:java.util.ArrayList@7052f5 | org.jboss.resource.connectionmanager.IdleRemover.internalRegisterPool(IdleRemover.java:92) | org.jboss.resource.connectionmanager.IdleRemover.registerPool(IdleRemover.java:53) | org.jboss.resource.connectionmanager.InternalManagedConnectionPool.initialize(InternalManagedConnectionPool.java:141) | ...... | So anybody have ideas with this? Your reply will by most appreciated. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4241363#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...