Previous Topic: JDBC Driver with the JDBC Proxy MethodNext Topic: Other Timeouts for JDBC Proxy


Idle Timeouts for JDBC Proxy

The interval that the JDBC Proxy waits for a request from the JDBC driver can be specified. When this interval is exceeded the JDBC Proxy assumes that an error has occurred, releases the SQL session with CA Datacom Server, and closes the socket connection with the JDBC driver. If the application attempts to use the connection after this, the JDBC driver returns an SQL exception indicating that a communications error has occurred.

The WaitTimeOut option can be specified in the cadatacom.properties file on all platforms. The idle timeout for the JDBC Proxy should be longer than the timeout set for the application server and shorter than the timeouts set for the CASERVER task.