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

[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 at 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#4241363

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4241363