Managing Open Connection Threads
The driver properties are used to specify connection timeout settings as required by the specific driver. By specifying the properties that are used by your specific data source, you can avoid situations where connections are left open indefinitely. This will prevent TDV threads from locking up on requests that need to establish a database connection.
Because each database has different connection properties, you will need to become familiar with them to determine which property to set and what values are appropriate for your environment.
To manage the connection threads
1. Open the data source editor for the data source that has been identified as having connection threads that stay open too long.
2. Open the Advanced tab.
3. Edit the Connection Properties—JDBC Connection Properties to define connection timeout intervals that are appropriate for your environment.