-
1. Re: InUseConnectionCount continously increasing...
weston.price Sep 21, 2006 12:47 PM (in response to oguz.dag)JBoss version?
DB version?
*-ds.xml file?
log files/traces? -
2. Re: InUseConnectionCount continously increasing...
oguz.dag Sep 22, 2006 2:33 AM (in response to 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...