What is the purpose of the JDBC property 'enableTDVConnectionPool' in TIBCO Data Virtualization?
Article ID: KB0071076
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
The user can set the 'enableTDVConnectionPool' property in the TIBCO Data Virtualization Studio for a particular data source, this article provides a detailed explanation of how this property works.
Issue/Introduction
This article summarizes the use of the JDBC property 'enableTDVConnectionPool' and how it affects the connections in TIBCO Data Virtualization
Environment
Windows/Linux
Resolution
The steps involved in creating a connection each time enableTDVConnectionPool= false are as follows:
- Opening a connection to the database.
- Authenticating the user before establishing the connection.
- Creating a TCP socket for reading/writing data.
- Sending/receiving data over the socket.
- Closing the connection.
- Closing the TCP socket.
The property enableTDVConnectionPool(default value = false) is used to enable multiple reusable connections on standby, which are created ahead of time to save the overhead of creating new connections when they are needed as mentioned above. Once a connection is closed, it is sent back to the pool.
The difference between enableTDVConnectionPool = true and enableTDVConnectionPool=false is whether the connection pool feature is enabled or not. If set to false, the driver does not utilize the connection pooling mechanism, and each connection request will create a new connection instance.
Additional Information
Feedback
Yes
No
Powered by
