Actian Community Blogs

Ingres Connectivity continues to evolve. The following enhancements are planned for Ingres 10.1:

• ODBC Batch Execution – Execution of a single query with arrays of parameters
• JDBC getGeneratedKeys Enhancement
• .NET Data Provider support for Connection string Identifier_Delimiter = Bracket to allow the provider to recognize both double quotes and brackets for delimited identifiers
• .NET Data Provider support for batch updates via the DbDataAdapter.UpdateBatchSize property

For more...

Many of you are just beginning to consider migrating from Ingres 9.2 and earlier releases and may be unaware of the many new features included in the Ingres Connectivity area since 9.2. I will be writing a series of blogs that details the changes in the protocol drivers, JDBC, ODBC, .NET, and OpenAPI since Ingres 9.2. These features are also applicable to Vectorwise unless otherwise noted.

• Network Protocol Drivers/Authentication Enhancements
• JDBC
• ODBC
• .NET
• OpenAPI

Conclusion...

JDBC driver version 3.8.0, introduced in Ingres 9.3, provided the ability to target the Multiple Data Access Servers functionality added in Ingres 9.3. A JDBC client may target a connection to multiple Data Access Servers by providing a list of ports in the JDBC connection URL string:

Note: {} indicate elements that are optional and may be repeated.

In addition, multiple hosts and port lists may be specified,...

Beginning with Ingres 2006, the Ingres JDBC Driver and DataSources classes contained in the Java archive, iijdbc.jar, under the Java package path of "ca.ingres.jdbc" were moved to the package path of "com.ingres.jdbc". The iijdbc.jar archive included with all Ingres 9.x releases also contains the original classes for backward compatibility with the note that the classes would be removed in the next major Ingres release.

The time has come to say goodbye to the...

One of the new features coming with Ingres 10 is the complete support of batched statements in JDBC. The Ingres JDBC Driver has always supported the addBatch and executeBatch methods but under the covers executed each statement in the batch individually. While this worked, it resulted in less than optimal performance. With Ingres 10, a number of changes were made to the Ingres DBMS, Data Access (DAS) Servers and the JDBC Driver to utilize a feature of the Ingres communications layer to send statements...