...
The Sybase JDBC driver that is included in the SDK has to be downloaded to the Platform in order to connect to a Sybase IQ database from .
...
- Go to the SAP Software Solutions web page for information about the SDK and included drivers:
https://www.sap.com/index.html.
- Place the downloaded jar file in the
$MZ_HOME/3pp directory
.
- Restart the Platform and EC/ECSAs.
Close Pooled Connections
The APL function closePooledConnections
enables you to close a pooled connection with the Sybase IQ server. This feature helps you eliminate invalid connections.
...
There are two properties available for handling the timeout of socket connections and socket threads:
sybase.jdbc.socketread.timeout
with default value 180000 (3 minutes in milliseconds)sybase.jdbc.socketconnect.timeout
with default value 30000 (30 seconds in milliseconds)
To specify other timeout values, in milliseconds, set the Execution Context properties in the relevant <pico>.conf
file.
...