JDBC Drivers in Java

JDBC Drivers are divided into 4 types or levels.

The different types of JDBC Drivers are :

Type 1 - JDBC-ODBC Bridge driver (Bridge)
Driver Class : sun.jdbc.odbc.JdbcOdbcDriver
URL : jdbc:odbc:myDSN

Type 2 - Native-API/partly Java driver (Native/OCI)
Driver Class : oracle.jdbc.driver.OracleDriver
URL : jdbc:oracle:oci:@orans

Type 4 - All Java/Native-protocol driver (Pure Java/Thin)
Driver Class : oracle.jdbc.driver.OracleDriver
URL : jdbc:oracle:thin:@localhost:1521:xe

Type 3 - All Java/Net-protocol driver (Middleware)