This section contains information that is specific to the database type Sybase IQ.
...
Note!
The Sybase IQ database type requires jConnect v16.0 and later.
Supported Functions
The Sybase IQ database can be used with:
...
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 MediationZone.
You must proceed as follows:
...
The APL function closePooledConnections enables you to close a pooled connection with the Sybase IQ server. This feature helps you eliminate invalid connections.
...
Note!
This function only closes inactive connections, regardless of how long the connections have been idle.
| Code Block | ||
|---|---|---|
| ||
int closePooledConnections
(string dbProfile) |
...
| Info | |||||
|---|---|---|---|---|---|
Example - Setting the timeout for a socket tied to a Sybase IQ connection
| |||||
Note!
When using the timeout property you must ensure that you set a limit that exceeds your longest running query, otherwise you might terminate a connection while it is executing a query.