IBM Data Server Driver for JDBC and SQLJ enhancements

The IBM Data Server Driver for JDBC and SQLJ contains enhancements to connection reestablishment for the Db2 12.1.5 release.

Db2 12.1.5 enhancements

Table 1. IBM Data Server Driver for JDBC and SQLJ enhancements and new capabilities in 12.1.5
Enhancement Description
Reconnect an application to a server that has timed-out without having ACR or WLB configured. When using the JDBC/SQLJ driver to connect an application to a server, the connection is sometimes dropped by the server after an idle period. In Db2 12.1.4 and earlier, this dropped connection is rerouted to a different host or member only if the Automatic Client Reroute (ACR) feature or workload balancing (WLB) feature is enabled..
In Db2 12.1.5, you can set properties that allow automatic reestablishment of a connection when a communication error is hit by the server without enabling ACR or WLB. This functionality is controlled through two new JDBC/SQLJ properties:
  • maxReconnectRetries
  • reconnectRetryInterval

For more information, see Common IBM Data Server Driver for JDBC and SQLJ properties for all supported database products