JDBC for SQL Server - Herong's Tutorial Examples - v3.14, by Herong Yang
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:
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 and newer. 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 newer JDK.
Table of Contents
JDBC (Java Database Connectivity) Introduction
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
Using Connection Pool with JDBC
►JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver
►JDBC-ODBC Bridge Driver Features
JDBC-ODBC - Loading sun.jdbc.odbc.JdbcOdbcDriver
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