The default value for this property is -1, which is an infinite wait time. Setting this timeout to a nonzero value ensures applications can remain responsive if there's network or communication failure with the server, when a query has timed out.

That is, the driver waits the total amount of cancelQueryTimeout plus queryTimeout seconds, before the connection is closed. cancelQueryTimeout is the time, in seconds, the driver waits for an acknowledgment of the queryTimeout cancellation from the server, before forcefully terminating/closing the connection.The default value is -1, which means infinite timeout. Exceeding this timeout doesn't close the connection. If this time is exceeded, the command is canceled. queryTimeout is the time, in seconds, the driver will wait, after sending an execute command to the server, to receive a reply from the server with data.socketTimeout is used for any driver communication with the server. Once the connection has been established, queryTimeout, cancelQueryTimeout, and lockTimeout are used during statement executions. If you're consistently having trouble establishing a connection with the JDBC driver, you may need to increase this timeout to 90, or even 120, seconds. Any nonzero value is the number of seconds the driver should wait before timing out a failed connection. For versions 10.2 and below, the default timeout is 15 seconds. A zero value indicates that the timeout is the default system timeout, which is 30 seconds in versions 11.2 and above. If this amount is exceeded, an error is returned, and no open connection is established. loginTimeout is the amount of time, in seconds, the driver waits to establish a connection to the server.Ensure you choose timeouts that are appropriate for your application's needs.įor the initial connection, loginTimeout is used:

By default, most of the driver's timeouts prioritize waiting for a result to ensure data consistency. Timeout settings in the JDBC driver can be used to prioritize application responsiveness.

Download revolver server