OpenLink 3.2 Drivers for JDBC™
 |
OpenLink 3.2 for JDBC™ is a new release. Thus, the JDBC client and server components for JDBC™ aren't backward compatible with prior releases.
New JDBC Drivers & Java
Packages
New Features & Enhancements
Installation & Configuration
OpenLink now has a broader range of JDBC Driver types which also transcend JDBC versions.
The drivers are now categorized as follows:
- Generic Drivers for JDBC™ 1.0.2 (compatible
with Java Virtual Machine version 1.0.2)
- Generic Drivers for JDBC™ 1.1.x (compatible
with Java Virtual Machine version 1.1.x)
- Generic Drivers for JDBC™ 2.0 (compatible
with Java Virtual Machine version 2.0)
- Megathin Drivers™ for JDBC™ 1.0.2 (compatible
with Java Virtual Machine version 1.0.2.)
- Megathin Drivers™ for JDBC™ 1.1.x (compatible
with Java Virtual Machine version 1.1.x)
- Megathin Drivers™ for JDBC™ 2.0 (compatible with Java Virtual Machine version 1.2 a.k.a. Java Virtual Machine 2.0)
The table below depicts how each of these drivers is packaged, what JDBC Driver formats are supported, and whether they are certified 100% Pure Java or Not:
| Product Name | Java Package | JDBC Driver Name | JDBC Driver Formats | 100% Pure Java ? |
| Generic Drivers for JDBC™ 1.0.2 | opljdbc.jar | openlink.jdbc.Driver | 1,2,3 | N |
| Generic Drivers for JDBC™ 1.1.x | opljdbc.jar | openlink.jdbc.Driver | 1,2,3 | N |
| Generic Drivers™ for JDBC 2.0 | opljdbc2.jar | openlink.jdbc2.Driver | 1,2,3 | N |
| Megathin Drivers™ for JDBC™ 1.0.2 | megathin.jar | openlink.megathin.Driver | 3 | Y |
| Megathin Drivers™ for JDBC™ 1.1.x | megathin.jar | openlink.megathin.Driver | 3 | Y |
| Megathin Drivers™ for JDBC 2.0 | megathin2.jar | openlink.megathin2.Driver | 3 | Y |
| 1. | Scrollable Cursors A new OpenLink RowSet class enables JDBC applications to take advantage of ODBC-style scrollable cursors functionality, with the ability to: retrieve rowsets, go to any row in the resultset or rowset, add new rows to the database, refresh and update any row with a single method invocation, lock and unlock any row, retrieve the current row number, as well as use ODBC-style bookmarks. This is an OpenLink extension to JDBC. The Drivers for JDBC™ 2.0 implement the Scrollable Cursor Interfaces introduced in JDBC™ 2.0. They also retain support for the OpenLink Scrollable Cursor extension so as to provide access to those Scrollable Cursor features that exist in ODBC but are missing from the JDBC™ 2.0 specification. |
| . | |
| 2. | Array Binding As part of the new RowSet class. It is now possible to bind data arrays to the columns of the OpenLink RowSet object, and retrieve the data directly into the arrays with a single invocation of the RowSet.next() method. Please see the accompanying demonstration application for an example of its usage. This approach enables you to retrieve multiple records with a reduced number of calls to the RowSet.next() method. It basically improves JDBC Application performance. |
| . | |
| 3. | openlink.sql.Statement
This is a new OpenLink interface that extends java.sql.Statement to provide additional methods for configuring the ODBC-Style Scrollable Cursors functionality. You only need this functionality when working with the OpenLink Scrollable Cursor extensions. The Drivers for JDBC 2.0 implement similar features for the JDBC 2.0 Scrollable Cursor specification. |
| . | |
| 4. | Security The OpenLink client and server components for JDBC™ encrypt the data sent across the network between the client and server. This provides for enhanced security, particularly over a WAN. This is transparent to the application, and there are no driver specific properties for the application to set. |
| . | |
| 5. | Version self-checking The OpenLink client component for JDBC™ now cross checks version numbers with the server Agent for JDBC at connect time, this ensures that compatible components always in use. An exception will be thrown when incompatibilities are encountered, this exception will also contain information about the component versions relating to the exception. |
| . | |
| 6. | Easier Client Version
checking There is now an easier way of checking the OpenLink client for JDBC™ version. Make sure that the driver is in the classpath and then at your command prompt enter the command: java openlink.jdbc.Driver (for JDK 1.x Drivers) or java openlink.jdbc2.Driver (for JDK 1.2/2.0 Drivers) or java openlink.megathin.Driver (for 100% Pure Java Drivers for JDK 1.x) or java openlink.megathin2.Driver (for 100% Pure Java Drivers for JDK 1.2/2.0) The driver will respond with appropriate version and release number information. |
| . | |
| 7. | OpenLink Native (UDBC)
Bridge for JDBC™ UDBC is OpenLink's Universal Database Connectivity solution for cross platform data access. The new OpenLink Client UDBC Bridge for JDBC™ enables JDBC binding to Native Database Interfaces without going through an ODBC Driver Manager. |
