The Ingres JDBC team has busy working on new features in the Ingres JDBC Driver for Ingres 10 release. Enhancments include:

• Adding Support for the following JDBC 4.0 API features:
  • Automatic loading of java.sql.Driver
  • National Character Set Conversion Support
  • Enhances Support for BLOB and CLOB
  • Wrapper pattern
  • New Scalar Functions
  • SQLException enhancements
  • JDBC API changes to existing JDBC interfaces
  • SQL/XML and XML support
  • Connection Management

For more information on the Ingres support of the JDBC 4.0 API features, see JDBC 4.0 API Features Implemented.

A Community Preview of the Ingres JDBC Driver (iijdbc.jar) can be found at Community Preview Download Area.

• Boolean Data Type Support.

For more information regarding Ingres’s support of the Boolean Data Type, see Boolean Data Type Support.

A Community Preview of the Ingres JDBC Driver (iijdbc.jar) will be available in the future that exposes this support. An Ingres 10 DBMS and Data Access Server (DAS) are a must to exploit this feature.

• Batch Execution Support.

Batch processing (batch execution actually) is currently supported in the Ingres JDBC Driver but under the covers statements are not actually batched but instead are done as Singleton queries which undermine the performance improvement expected when batching queries. The feature was implemented in this manner due to the lack of support in the Ingres DBMS for batch processing. With Ingres 10, the DBMS will be adding capabilities to handle batch processing and the JDBC Driver will be modified to take advantage of the new Batch feature. This enhancement should significantly improve batch processing in the Ingres JDBC Driver.

For more information regarding Ingres’s support of Batch Execution in Ingres 10 and the JDBC Driver, see Batch Statement Execution Performance.

A Community Preview of the Ingres JDBC Driver (iijdbc.jar) will be available in the future that exposes this support. An Ingres 10 DBMS and Data Access Server (DAS) are a must to exploit this feature.

Future blog entries will discuss new updates to the JDBC Driver and Community Previews of the new functionality.