Login Register Actian.com  

Actian Community Blogs

Java Topics relating to Java & Ingres JDBC Driver
Old

Connectivity Enhancements Targeted for Ingres 10.1

Posted 2012-04-03 at 09:03 AM by teresa
Updated 2012-04-04 at 09:41 AM by teresa
Tags .net, ingres, jdbc, odbc

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...
Ingres
Posted in Java, ODBC, .NET, Ingres
Views 159 Comments 0 teresa is offline Edit Tags
Old

Connectivity Enhancements in Ingres 9.3.x and 10.x

Posted 2012-04-03 at 08:56 AM by teresa

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.

Conclusion...
Ingres
Posted in Java, ODBC, .NET, Ingres
Views 128 Comments 0 teresa is offline Edit Tags
Old

JDBC Enhancements in Ingres 9.3.x and 10.x

Posted 2012-04-03 at 08:40 AM by teresa

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:

Code:
jdbc:ingres://host:port{,port}/db{;attr=value}
Note: {} indicate elements that are optional and may be repeated.

In addition, multiple hosts and port lists may be specified,...
Ingres
Posted in Java, Ingres
Views 127 Comments 0 teresa is offline Edit Tags
Old

Time to say goodbye to the “ca.ingres.jdbc” package

Posted 2010-04-16 at 10:59 AM by teresa

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...
Ingres
Posted in Java
Views 17190 Comments 1 teresa is offline Edit Tags
Old

Improving Data Load using the new Ingres 10 Batch Execution Feature

Posted 2010-04-14 at 09:14 PM by teresa
Updated 2010-04-14 at 09:24 PM by teresa (removed blank space)

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...
Ingres
Posted in Java
Views 17291 Comments 0 teresa is offline Edit Tags
© 2011 Actian Corporation. All Rights Reserved