JDBC-ODBC Bridge

JDBC-ODBC Bridge for Windows, Linux, and UNIX

The Easysoft JDBC-ODBC Bridge provides JDBC access from any Java platform to remote ODBC data sources on Windows, Linux, and UNIX platforms.

You can connect to Microsoft Access, Microsoft Navision, Microsoft SQL Server, or any other database for which you have an ODBC driver. Client access can be from JSP pages, Java applets, applications, servlets, or application servers.

Unlike the bridge that ships with some versions of Java, the JDBC-ODBC Bridge is a Type 3, client/server solution, allowing Java applications and ODBC drivers to be on separate machines. To a JDBC application, the JDBC-ODBC Bridge client is a JDBC driver that provides access to the expected methods. To an ODBC driver, the JDBC-ODBC Bridge server is an application that makes ODBC-conformant calls.

In addition, JDBC-ODBC Bridge:

  • Is J2SE compliant.
  • Supports core JDBC 2 methods in addition to all JDBC 1.22 methods.
  • Lets you set and retrieve Unicode data with the ResultSet.getString() and PreparedStatement.setString() methods.
  • Supports a wide range of development environments with which to develop your data aware Java application, including Borland JBuilder, Forte, WebLogic, ColdFusion MX, JDesignerPro, and Apache Tomcat.
  • Ships with a simple, integral HTTP server to provide web based remote monitoring and configuration of the JDBC-ODBC Bridge server. The easysoft.sql.jobDriver package can be served by this web server alongside applet code to achieve zero installation solutions.
  • Provides outstanding performance as demonstrated by JBench test results.
  • Supports multiple concurrent statements even when the ODBC driver does not.
  • Handles multiple concurrent database connections.

Diagram

Platforms

The server component of the JDBC-ODBC Bridge is currently available on these platforms:

Version Platform Distribution
v1.7 (JDBC 2) AIX (PPC) (32 - Bit) (4.3-7.2)
v1.7 (JDBC 2) Linux (x86) (32 - Bit) (kernel 2.2-5.0+, glibc 2.1+)
v1.7 (JDBC 2) Linux (x86) (64 - Bit) (kernel 2.6-5.0+, glibc 2.3.5+)
v1.7 (JDBC 2) Solaris (Sparc) (32 - Bit) (2.6-2.11)
v1.7 (JDBC 2) Solaris (x86) (32 - Bit) (2.8-2.11)
v1.7 (JDBC 2) Windows (x86) (32 - Bit, 64 - Bit) (7, 8, 2012 R2, 10, 2016, 2019,11,2022)
v1.4 (JDBC 2) HP-UX (Itanium i64) (32 - Bit) (11i)
v1.3 (JDBC 2) HP-UX (PA-Risc) (32 - Bit) (10.10-11)
v1.3 (JDBC 2) SCO Open Server (x86) (32 - Bit) (5)
v1.3 (JDBC 2) SCO Unixware (x86) (32 - Bit) (7.0)