An Easier, More Effective Way to Implement a Connection Pool
A connection pool improves application performance by keeping open a number of connections to a frequently used back end system and enabling reuse of those connections so that each new service request does not incur the overhead of having to open a new connection. For application developers and system administrators, Progress DataDirect provides a better way to implement and manage connection pool functionality. Connection pooling is built into every one of our ODBC, JDBC, and ADO.NET data drivers, providing applications an easy means of leveraging connection pool functionality while interfacing with any major database system.
Connection Pool Benefits and Open Standards Interoperability
With ODBC, JDBC, and ADO.NET drivers from DataDirect, connection pooling is implemented and managed entirely by the driver. From the perspective of applications using the driver, connection pool logic is entirely abstracted – applications simply request a connection to the target DB, and the driver takes care of the rest. For maximum performance benefit, connection pool configuration options can be set for pool size, connection lifetime, connection retry behavior, and so on. DataDirect drivers support a variety of ways of setting connection properties including a driver set-up GUI as well as attributes that can be attached to an ODBC connection string, ADO.NET connection string, or JDBC connection string.
Better yet, by using DataDirect drivers as an easy way to leverage connection pool functionality, you also get all the benefits of open standards based interoperability. For example, by using DataDirect JDBC drivers, your Java applications can use the same code to access any major database system. Even in the most heterogeneous environments, DataDirect drivers provide your applications a consistent data access interface as well as consistent database connectivity error handling.
Performance and Comprehensive Coverage
DataDirect drivers deliver better SQL performance than any other open standards drivers on the market, resulting from superior design and a wide range of built-in enterprise grade features including statement pooling, load balancing, and bulk loading, as well as connection pool functionality.
Whatever your data architecture, DataDirect has high-performance drivers to meet your needs – whether it's a JDBC SQL Server driver, an ODBC driver for Oracle, or drivers for any other major database type including Informix, Sybase, Sybase IQ, MySQL, PostgreSQL, and more, or even cloud data stores like Salesforce or Database.com.