Easysoft ODBC-JDBC Gateway 2.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.
Enhancements:
- 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.