When the JDBC driver is used with the JDBC Proxy, the 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 Proxy.
If the connection is made using a data source defined in the registry, 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 Proxy, and should be set at least as high as the WaitTimeOut setting.
The original queryTimeout value is passed to the JDBC Proxy and overrides the default for CAICCI/ENF no matter how it was set.
When an intermediate JDBC Proxy is used, as might be done to support applets from a web server running on UNIX, the Timeout for socket requests from the intermediate server to the server where the native SQL client runs should be specified on the intermediate server.
You can define the ReplyTimeout option in the cadatacom.properties file on all platforms. The intermediate server Timeout is used only for the socket connection between the two JDBC Proxys, and should be longer than the Timeout set in the server servername section on the destination JDBC Proxy.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|