JDBC API in Java programming language provides a standard, universal way to connect to databases. It is the responsibility of different DB vendors to provide the implementation of the interfaces in JDBC API and that implementation by DB vendors is provided as JDBC drivers. Table of contents Types of JDBC drivers Type 1 JDBC Driver Type 2 JDBC Driver Type 3 JDBC Driver Type 4 JDBC Driver Types of JDBC drivers Based on these different implementations JDBC drivers are categorized into four types. Type 1 driver: JDBC-ODBC bridge JDBC driver Type 2 driver: Written partly in Java and partly in native code Type 3 driver: Pure Java client and middleware server translating client request to data source. Type 4 driver: Written completely in Java. Type 1 JDBC Driver Type 1 JDBC driver implements the JDBC API as a mapping to another data access API, such as ODBC (Open Database Connectivity). The JDBC-ODBC Bridge driver is an example of type 1 JDBC
Java, Spring, Web development tutorials with examples