Easysoft ODBC-JDBC Gateway 2.0 review

Easysoft ODBC-JDBC Gateway lets ODBC-enabled applications such as Business Objects, Microsoft Access, Microsoft Excel and Microsoft S

License: Other/Proprietary License with Free Trial File size: 10070K Developer: Easysoft Limited

0

Easysoft ODBC-JDBC Gateway lets ODBC-enabled applications such as Business Objects, Microsoft Access, Microsoft Excel and Microsoft SQL Server access Java databases. Supported Java databases include:

Borland JDataStore
FirstSQL
hsqldb
HSQL (Hypersonic SQL)
IBM Cloudscape/Apache Derby
Mckoi
MetaMatrix
OpenBase
PointBase

In addition to the JDBC drivers for these databases, the Easysoft ODBC-JDBC Gateway is also compatible with any compliant JDBC driver. For example:

Microsoft SQL Server 2000 Driver for JDBC
Sybase iAnywhere JDBC Driver

The Easysoft ODBC-JDBC Gateway is available on Linux, Unix and Windows platforms.

The Easysoft ODBC-JDBC Gateway is an ODBC driver that provides ODBC access to JDBC data sources. To an ODBC-enabled application, it is an ODBC 3.5 driver (exposing most of the ODBC 3.0 API) providing access to all the expected API calls and features. To a target JDBC driver, it appears to be a Java application making JDBC conformant calls. The JDBC driver is unaware that ODBC is involved.

The Easysoft ODBC-JDBC Gateway is written entirely in C, it therefore introduces little or no performance overhead other than that associated with the target JDBC driver. It uses the JNI (Java Native Interface) to load JDBC Driver classes and to call JDBC methods in the loaded JDBC drivers.

In addition, the Easysoft ODBC-JDBC Gateway:

Complies with the JDBC 1, 2 and 3 specifications.
Is compatible with the JDK 1.3.x, 1.4.x and 1.5.x (Sun Microsystems and IBM JVMs).
Works with all JDBC Driver types (1–4).
Transparently hides certain known problems in the JVM implementation of the JNI.
Enables Unicode-ready applications such as Microsoft Access to display and modify Unicode data stored in JDBC databases.
Allows XA Transaction Managers to enlist database resources in a distributed transaction by using XA-compliant JDBC drivers.

What's New in This Release:
Unicode data may now be modified.
Scrollable cursors were added, allowing applications to move backward through a result set.
XA support was added, allowing a Transaction Manager to enlist database resources in a distributed transaction.
A distributed transaction is a set of one or more related transactions that must be coordinated in such a way that guarantees all transactions either commit or roll back together.