Release Notes — DataDirect Connect for JDBC, Release 4.1

DataDirect Connect for JDBC is the fastest and most comprehensive suite of Type 4 JDBC drivers.

Major Features

• DataDirect Bulk Load for DB2, SQL Server, and Sybase
• Freeze/Unfreeze the Statement Pool
• Hibernate Certification

New or Updated Drivers

• DB2
• Informix
• MySQL
• Oracle
• SQL Server
• Sybase

DataDirect Bulk Load

DataDirect Bulk Load improves and expands upon current methods for inserting mass amounts of data into a database as quickly as possible. Previously available for Oracle in the 4.0 SP2 release, support for DataDirect Bulk Load has been expanded to DB2, SQL Server and Sybase.

To learn more about DataDirect Bulk Load, select one of the subjects below.

• Bulk Load Benefits
• How Bulk Load Works
• Bulk Load Performance
• Bulk Load Competitive Comparison

Freeze/Unfreeze the Statement Pool

Many types of Java applications can experience significant performance benefits through the use of statement pooling with DataDirect JDBC drivers. With this release, applications that make use of statement pooling in any DataDirect JDBC driver can now “freeze” the state of the statement pool. Once frozen, important statements in the statement pool will remain in the pool and not be replaced until the connection is closed or the application “unfreezes” the state of the statement pool. By freezing the statement pool, you can ensure that your most important statements are not removed from the pool by less important statements, thereby optimizing the performance of your application.

Hibernate Certification

Object-relational mapping (ORM) technologies such as Hibernate make it easier for developers to build applications that require data access. Many organizations have been successfully using DataDirect JDBC drivers with Hibernate for years but have requested a statement affirming the supportability of DataDirect JDBC drivers with Hibernate. With this release, all DataDirect JDBC drivers have been tested and certified with the Hibernate Certification Test Kit for easy implementation under Hibernate using the default dialect files that come with Hibernate.

DB2

Informix

MySQL

Oracle

SQL Server

Sybase