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).

Totally 4 drives in java those are

1.jdbc-odbc driver

2.native api driver

3.net protocal driver

4.native protocal driver

3 drivers in java ie
1.java api driver
2.jdbc odbc driver
3.driver manager.samal.

No @sreedhar is correct.

Jdbc-odbc bridge driver.

Native API partly java driver.

Network protoclo java driver.

JDBC net pure java driver.

jdbc.odbc.JdbcOdbc.Driver

Jdbc-Odbc bridge driver
Native API driver( thik driver)
net protocal driver
Native protocal driver(thin driver)

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.

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.

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