Database - JDBC, Java Server Pages, and MySQL - Discussion
Discussion Forum : JDBC, Java Server Pages, and MySQL - General Questions (Q.No. 1)
1.
How many JDBC driver types does Sun define?
Discussion:
16 comments Page 1 of 2.
Priya said:
9 years ago
hi nice
Ash said:
1 decade ago
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).
__________________
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).
(1)
Priyanka said:
1 decade ago
I know only 1 driver JDBCODBC. I don't know other drivers.
Pradeep said:
1 decade ago
JDBC-ODBC bridge driver.
Native-API driver (partially java driver).
Network Protocol driver (fully java driver).
Thin driver (fully java driver).
Native-API driver (partially java driver).
Network Protocol driver (fully java driver).
Thin driver (fully java driver).
Raju said:
1 decade ago
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.
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.
N.rohithkumar said:
1 decade ago
Sun proposed only-jdbcodbcbridge driver.
Jdbc native driver-dbvendor.
Jdbcnet protocol driver-middleware servers.
Jdbc native protocol-db vendor.
Jdbc native driver-dbvendor.
Jdbcnet protocol driver-middleware servers.
Jdbc native protocol-db vendor.
Chandrahas said:
1 decade ago
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
1)JDBC-ODBC Bridge Driver
2)Native API/partly java driver
3)Net-Protocol/All Java driver
4)Native-Protocol/All Java driver
Manche Shekhar said:
1 decade ago
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
1)Jdbc-Odbc bridge driver
2)Native API party java driver
3)Net protocol pure java driver
4)Native protocol pure java driver
Ahamed said:
1 decade ago
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.
1. Mysql-jdbc Driver.
2. Jdbc-odbc driver.
3. Pointbase-jdbc driver.
4. Oracle-jdbc driver.
G Satyanarayana said:
1 decade ago
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.
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.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers