Introduction to the four JDBC driver standards defined by sun

Four types of JDBC driver standards defined by Sun:

Type1 Jdbc-odbc Bridge

As part of the JDK1.1, it's part of the SUN.JDBC.ODBC package.

Application-->jdbc-odbc Bridge (Type1 JDBC driver)--->jdbc-odbc library-->odbc driver-->database

For fast prototyping systems, no JDBC-driven database such as Access

Type2 JAVA to Native API

Use the local library provided by the developer to communicate directly with the database.

Application--->jdbc Driver (Type2 JDBC Driver)--->native Database library--->database

Slightly better than Type1 performance.

Type3 Java to Net

Application--->jdbc Driver (Type3 Jdbc Driver)--->java middleware--->jdbc Driver--->database

Has the greatest flexibility, usually provided by those non-database vendors, and is the smallest of the four types.

Type4 JAVA to native dababase

Application--->jdbc driver (type4 JDBC driver)--->database engine--->database

The highest performance, communicates directly with the database engine through its own local protocol, and has the ability to assemble on the Internet.