Release Notes — DataDirect Connect for JDBC, Release 4.0, Service Pack 2

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

New Features in All Drivers

New or Updated Drivers

DataDirect Application Failover

To ensure continuous, uninterrupted access to data, DataDirect Connect for JDBC provides three levels of failover protection:

  • Connection failover
  • Extended connection failover
  • Select failover

Click here for an overview of DataDirect Application Failover. Also, for more detailed information on how to use failover see the DataDirect Connect for JDBC User's Guide and Reference.

JDBC 4.0 Support

All DataDirect Connect for JDBC drivers fully comply with the JDBC 4.0 specification, supporting features that greatly increase developer productivity and make for better functioning, more robust applications. The JDBC 4.0 API specification is a significant advance in the standard, containing many important new enhancements such as:

  • Robust support for the SQL 2003 XML data type
  • More control over connection and statement pooling for high-end application performance and scalability
  • Many features that make it easier for developers to write JDBC applications, including far more efficient debugging of SQLExceptions

Learn more about our JDBC 4.0 support.

Oracle

Performance Features
  • Table and Tablespace Compression - Saves space on the database server and provides optimal application performance
  • Server side result set caching – Does not require code changes
Service Pack 1
  • New performance tuning connection options: initialColumnBufferSize, SDUSize, and stringParamsMustMatchCharColumns
Service Pack 2
  • DataDirect Bulk Load

Security Features
  • Transparent Data Encryption / Tablespace Encryption

Compliance / Certification

New Database Versions
  • Oracle 11g

DB2

Performance Features
  • IBM Workload Manager (WLM) – Enhancements allow you to specify performance goals and assign business importance to JDBC processing. For example, to ensure that 70% of transactions complete within one second, you can use WLM to configure a rule. WLM keeps track of the work running on the system and configures system resources in order to satisfy this goal. WLM support does not require changes to application code, and has been integrated into the Performance Wizard for easy configuration.
  • Database Compression - Saves space on the database server and provides optimal performance.

Security Features
  • SSL support for DB2 v9.1 for Linux, Windows, and UNIX, DB2 v9 for z/OS, and AS/400 v5r3, v5r4, and v6r1

Compliance / Certification

New Database Versions
  • DB2 v9.5
Service Pack 2
  • DB2 V6R1 on iSeries

New Database Features

  • XMLSchema support - Allows validation of XML data
  • XQuery Update Expressions - Supports the new syntax for updating XML documents via XQuery expressions

SQL Server

Compliance / Certification

New Database Versions

 Service Pack 1
  • SQL Server 2008

New Database Features

 Service Pack 1
  • SQL Server 2008 data types: Date, Time, Datetime2, DatetimeOffset

MySQL

Security Features

 Service Pack 1

Compliance / Certification

Database Versions

 Service Pack 2
  • MySQL Enterprise v5.1
Release History