JBoss Data Source Setup

229,322pages on
this wiki
Add New Page
Discuss this page0 Share

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"
    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


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


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

For Oracle


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.