You can specify the interval that the JDBC server waits for a request from the JDBC driver. When this interval is exceeded, the JDBC server assumes that an error has occurred, releases the SQL session with CA IDMS, and closes the socket connection with the JDBC driver. If the application attempts to use the connection after this, the JDBC driver returns a SQLException indicating that a communications error has occurred.
On Windows, you can use the CA IDMS Server ODBC Administrator Proxy tab to set the Wait Timeout for the JDBC Server. On z/OS and Linux, you can define WaitTimeOut in the Proxy section in the caidms.cfg configuration file. You can define this option in the caidms.properties file on all platforms. The idle timeout for the JDBC server should be longer than the timeout set for the application server and shorter than the timeouts set for the CASERVER or IDMSJSRV task.
|
Copyright © 2009 CA.
All rights reserved.
|
|