JDBC-ODBC Bridge Driver Features
This section describes Sun's JDBC-ODBC Bridge driver and its features.
JDBC-ODBC Bridge is a free JDBC driver connecting to database base server through ODBC drivers.
JDBC-ODBC Bridge is produced by Sun Microsystems and DataDirect Technologies.
JDBC-ODBC Bridge is included in the JDK (Java SE Development Kit) 1.7.
So you don't need to include any extra JAR files in your class path.
Main features the JDBC ODBC Bridge driver:
- The JDBC-ODBC Bridge driver is not included in Java SE 8 (JDK 1.8) any more.
- The version of JDBC-ODBC Bridge included in Java SE 7 (JDK 1.7) support JDBC 4.1 (JSR 221) specifications.
- JDBC-ODBC Bridge is a Type 1 JDBC driver (JDBC driver that bridges JDBC to ODBC on the same machine).
- JDBC-ODBC Bridge can be loaded as sun.jdbc.odbc.JdbcOdbcDriver directly from JRE (Java Runtime Environment).
- JDBC-ODBC Bridge is free.
There are also commercial JDBC-ODBC drivers available. Easysoft JDBC-ODBC Bridge is one of them.
It is actually a Type 3 JDBC driver and supports JDBC 2.1 specifications.
Please note that the JDBC-ODBC Bridge is no longer included in JDK 1.8.
Here is the official statement from the JDK 1.7 documentation:
"The JDBC-ODBC Bridge should be considered a transitional solution; it will be removed in JDK 8.
In addition, Oracle does not support the JDBC-ODBC Bridge. Oracle recommends that you use JDBC
drivers provided by the vendor of your database instead of the JDBC-ODBC Bridge."
So if you are currently using JDK 1.7 and the JDBC-ODBC Bridge, you want to consider how to
replace it with the specific JDBC driver for your data source. Or just keep the JDBC-ODBC Bridge driver
file when you upgrade to JDK 1.8.
Table of Contents
About This Book
JDBC (Java Database Connectivity) Introduction
JDK (Java SE) Installation
Installing and Running Java DB - Derby
Derby (Java DB) JDBC Driver
Derby (Java DB) JDBC DataSource Objects
Java DB (Derby) - DML Statements
Java DB (Derby) - ResultSet Objects of Queries
Java DB (Derby) - PreparedStatement
MySQL Installation on Windows
MySQL JDBC Driver (MySQL Connector/J)
MySQL - PreparedStatement
MySQL - Reference Implementation of JdbcRowSet
MySQL - JBDC CallableStatement
MySQL CLOB (Character Large Object) - TEXT
MySQL BLOB (Binary Large Object) - BLOB
Oracle Express Edition Installation on Windows
Oracle JDBC Drivers
Oracle - Reference Implementation of JdbcRowSet
Oracle - PreparedStatement
Oracle - JBDC CallableStatement
Oracle CLOB (Character Large Object) - TEXT
Oracle BLOB (Binary Large Object) - BLOB
Microsoft SQL Server Express Edition
Microsoft JDBC Driver for SQL Server
Microsoft JDBC Driver - Query Statements and Result Sets
Microsoft JDBC Driver - DatabaseMetaData Object
Microsoft JDBC Driver - DDL Statements
Microsoft JDBC Driver - DML Statements
SQL Server - PreparedStatement
SQL Server CLOB (Character Large Object) - TEXT
SQL Server BLOB (Binary Large Object) - BLOB
►JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver
►JDBC-ODBC Bridge Driver Features
JDBC-ODBC - Loading sun.jdbc.odbc.JdbcOdbcDriver
JDBC-ODBC - Creating DSN
JDBC-ODBC - Connecting to a DSN
JDBC-ODBC - Problem with Incorrect DSN
JDBC-ODBC Bridge Driver - Flat Text Files
JDBC-ODBC Bridge Driver - MS Access
JDBC-ODBC Bridge Driver - MS SQL Server
Summary of JDBC Drivers and Database Servers
Additional Tutorial Notes to Be Added
Full Version in PDF/EPUB