"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.arrayl...@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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to