InUseConnectionCount continously increasing...

[oguz.dag]

Hi,

I am watching one of my connection pool (most used) using JMX-Console for a while... Eveything goes fine except InUseConnectionCount is increasing nearly by 1 per hour...

I know it should be increased and decreased according to the usage of system... I can see that movement... But per hour the lower limit of InUseConnectionCount is increasing by 1... I mean graph goes upper and upper slowly (imagine x-axis time, y-axis InUseConnectionCount)... It should not be normal...

Can Quartz cause this problem? coz I am using Quartz for my batch jobs... Can I see the details of this connections?

Thank you...

[weston.price]

JBoss version?
DB version?
*-ds.xml file?
log files/traces?

[oguz.dag]

JBoss version : JBoss 4.0.3
DB Version : Oracle 10g

Datasource :

<xa-datasource>
<jndi-name>BankingDS</jndi-name>
<track-connection-by-tx/>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<xa-datasource-property name="URL">jdbc:oracle:thin:@[IP]:[SID]</xa-datasource-property>
<!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
<!-- Checks the Oracle error codes and messages for fatal errors -->
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<!-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa -->
<no-tx-separate-pools/>

<!-- this will be run before a managed connection is removed from the pool for use by a client-->
<check-valid-connection-sql>select * from DUAL</check-valid-connection-sql>

<!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use -->
<min-pool-size>16</min-pool-size>

<!-- The maximum connections in a pool/sub-pool -->
<max-pool-size>128</max-pool-size>

<!-- Use the security domain defined in conf/login-config.xml -->
<security-domain>EncryptBankingDS</security-domain>

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

<type-mapping>Oracle9i</type-mapping>

</xa-datasource>




There is no log file for this case, I was just watching the mbean...