Fandom

Scratchpad

JBoss Data Source Setup

215,838pages on
this wiki
Add New Page
Discuss this page0 Share

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.

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>

Also on Fandom

Random wikia