This content has been marked as final.
Show 2 replies
-
1. Re: Problem for JNDI database connection pooling
vickyk Jul 1, 2009 5:41 AM (in response to allen_lei)Spend some time to view the "Connection leak" section here
http://www.jboss.org/community/wiki/FAQJBossJCA -
2. Re: Problem for JNDI database connection pooling
allen_lei Jul 2, 2009 2:58 AM (in response to allen_lei)"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.