[jboss-user] [JCA/JBoss] - Connection in Use Keeps going Up Jboss 4.0.4.GA Jboss 4.0.4c

[kazam]

I am running my application on Jboss 4.0.4.GA and Jboss 4.0.4.c and on both of them on the  ManagedConnectionPool MBEAN

 ConnectionCreatedCount    (Keep going up)
 ConnectionDestroyedCount (Keep going up )
 InUseConnectionCount (Only goes up until managed connection error is thrown and application crashes).

Other Information
----------------------
-  Log file: 
    I see no entry for any connection leak or house keeping message.
    I can't see any message related to IDLE REMOVERrunning.

-  I am retrieving the connection using getConnection() only, no  user/passwd. This was working fine on jboss-4.0.2 but not since then. 

- I have two hibernate applications running on this jboss which use same database but are running fine and aren't using JNDI pooling.

Oracle-ds.xml file
-------------------------

  | <?xml version="1.0" encoding="UTF-8"?>
  | <datasources>
  |  <local-tx-datasource>
  |   	<jndi-name>jdbc/oracle</jndi-name>
  |   	<connection-url>jdbc:oracle:thin:@localhost:1521:proddb</connection-url>
  |     	<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  |     	<user-name>user</user-name>
  |     	<password>pass</password>
  |     	<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  |         <min-pool-size>20</min-pool-size>
  | 	<max-pool-size>150</max-pool-size>
  | 	<idle-timeout-minutes>1</idle-timeout-minutes>
  |         <blocking-timeout-millis>7000</blocking-timeout-millis>
  |         <!-- sql to call when connection is created
  |         <new-connection-sql>some arbitrary sql</new-connection-sql>
  |         -->
  |         <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
  |         <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
  |         -->
  |       	<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
  |       	<metadata>
  |         <type-mapping>Oracle9i</type-mapping>
  |       	</metadata>
  |   </local-tx-datasource>
  | 
  | </datasources>
  | 

Please, any ideas are welcome. I am confused as to why the idle remover is not running and why are the inUseConnections not coming down even when no one is connected to the application for hours.

Thanks,Kazam.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3978853#3978853

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