FANDOM


Check Unclosed Connection

Uncomment the following settings in two xmls to allow auto connection close:

  1. In {JBoss Directory}\server\default\deploy\jbossweb-tomcat55.sar\server.xml
  2. <Valve className="org.jboss.web.tomcat.tc5.jca.CachedConnectionValve"
    cachedConnectionManagerObjectName="jboss.jca:service=CachedConnectionManager"
    transactionManagerObjectName="jboss:service=TransactionManager" />
  3. In {JBoss Directory}\server\default\deploy\jbossweb-tomcat55.sar\META-INF\jboss-service.xml
  4. <depends>jboss.jca:service=CachedConnectionManager</depends>
    

Check Unclosed Statement and ResultSet

To check for unclosed statement and resultset, add the following statement inside the datasource xml

<track-statements>true</track-statements>

under element <local-tx-datasource>

Check Valid Connection

To check for validity of connection object before retrieval from pool, add the following statement inside datasource xml

For MSSQL

<check-valid-connection-sql>select 1</check-valid-connection-sql>

For Oracle

<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.