Turning off JDBC Connection Validation

By default, the ActiveMatrix platform validates a JDBC connection before executing a SQL statement over that connection. On large systems this validation can have a significant performance impact, and a performance benefit can be obtained by disabling the platform's JDBC connection validation.

To turn off JDBC connection validation, make the following configuration changes to only those JDBC resource templates that have been configured for XA transaction co-ordination (see JDBC Resources):

Procedure

  1. In ActiveMatrixAdministrator, select Shared Objects > Resource Templates.
  2. Select in turn each of the JDBC resource templates that is identified in the Description column as an XA DataSource.
  3. On the Advanced tab, go to Host Type Properties and click Add.
  4. In the Name column, enter validateConnectionOnAcquire. In the Value column, enter false.
  5. In the same way, add connectionPoolValidateConnection and set it to false. (If true, this property causes connections to be validated regardless of how validateConnectionOnAcquire is set.)
  6. Click Save.