Setting the Apache DBCP connection validation query timeout v7

Note

This option applies only to the publication server.

The Apache Commons Database Connection Pooling (DBCP) component is the Apache pooling framework used by the publication server for establishing JDBC connections.

The jdbc.pool.validationQueryTimeout option controls the timeout setting when a validation query is executed when allocating a connection from the pool. This is the amount of time in seconds before an exception is returned if the connection validation query doesn't succeed.

The default timeout value is 30 seconds. In situations in which network connections aren't reliable, you can increase the timeout value to allow more time for the connection attempt. Specify a value of 0 if you don't want a timeout value.

jdbc.pool.validationQueryTimeout=n

The default value is 30.