When the JDBC driver is used with the JDBC Server, the reply timeout specified using one of the JDBC methods is incremented slightly and used as the timeout value for socket requests from the JDBC driver to the JDBC server.
If the connection was made without a data source defined in the registry or configuration file, the original loginTimeout value is passed to the JDBC server and used as the default for CAICCI/ENF.
If the connection is made using a data source defined in the registry or configuration file for the JDBC Server, the value of the Server servername section WaitTimeOut is used as the default for CAICCI/ENF. In this case the loginTimeout is used only for the socket connection from the JDBC driver to the JDBC Server, and should be set at least as high as the WaitTimeOut setting.
The original queryTimeout value is passed to the JDBC server and overrides the default for CAICCI/ENF no matter how it was set.
When an intermediate JDBC Server is used, as might be done to support applets from a web server running on Linux, the reply timeout for socket requests from the intermediate server to the server where the native SQL client runs should be specified on the intermediate server.
On Windows, use the CA IDMS Server ODBC Administrator Proxy tab to set the Reply Timeout for the JDBC Server. On z/OS and Linux, you can define ReplyTimeOut in the Proxy section in the caidms.cfg configuration file. You can define this option in the caidms.properties file on all platforms. The intermediate server reply timeout is used only for the socket connection between the two JDBC servers, and should be longer than the reply timeout set in the Server servername section on the destination JDBC Server.
|
Copyright © 2009 CA.
All rights reserved.
|
|