Database - JDBC, Java Server Pages, and MySQL - Discussion

Four JDBC driver types:
__________________

1. JDBC-ODBC bridge -> It employs ODBC driver to connect to the database.

2. Native API Driver -> It uses the client-side libraries for the database.

3. Network Protocol Driver (Middleware Driver) -> makes use of middle tier between the calling program and the database.

4. Database-Protocol Driver ( Pure Java Driver) -> converts JDBC calls directly into a vendor-specific database protocol.

->Source(wiki).

JDBC-ODBC :

1) Required client side Installation.
2) Plate Dependent.
3) Performance Overhead.

Native API :

1) Required client side Installation.
2) Plate Dependent.
3) Performance Overhead.

Network Protocol:

1) Support more than on DB.
2) Less Performance.
3) 100% Pure JAVA Driver.
4) Plate independent.

Native Protocol:

1) DB dependent.
2) high Performance.
3) 100% Pure JAVA Driver.
4) Plate independent.

Totally 4 Drivers.

Type 1 Driver : JDBC - ODBC Driver : convert jdbc sql calls into odbc calls

Type 2: Native API drvier : SQL calls given directly to database

Type 3: Net protocal driver : Connection is provided by Server

Type 4: Thin driver . Third party vendors provided drivers are used here.

Sun define four types drivers: They are
1)Jdbc-Odbc bridge driver
2)Native API party java driver
3)Net protocol pure java driver
4)Native protocol pure java driver

Sun micro system provide four drives
1)JDBC-ODBC Bridge Driver
2)Native API/partly java driver
3)Net-Protocol/All Java driver
4)Native-Protocol/All Java driver

Sun proposed only-jdbcodbcbridge driver.

Jdbc native driver-dbvendor.

Jdbcnet protocol driver-middleware servers.

Jdbc native protocol-db vendor.

JDBC-ODBC bridge driver.

Native-API driver (partially java driver).

Network Protocol driver (fully java driver).

Thin driver (fully java driver).

I think the four drivers described by SUN are

1. Mysql-jdbc Driver.

2. Jdbc-odbc driver.

3. Pointbase-jdbc driver.

4. Oracle-jdbc driver.

Totally 4 drives in java those are

1.jdbc-odbc driver

2.native api driver

3.net protocal driver

4.native protocal driver

Jdbc-odbc bridge driver.

Native API partly java driver.

Network protoclo java driver.

JDBC net pure java driver.