File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Are there 5 types of JDBC Drivers?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Are there 5 types of JDBC Drivers??" Watch "Are there 5 types of JDBC Drivers??" New topic

Are there 5 types of JDBC Drivers??

Ram Dhan Yadav K
Ranch Hand

Joined: Aug 13, 2001
Posts: 321
I have seen a question like this?
Q. An applet will directly accesses Database using
JDBC. No database installation (or) configuration is
to be perform on client workstations which JDBC driver
used in this situation.
a) Type-1 JDBC-ODBC Bridge Driver
b) Type-2 Native API partly Java Driver
c) Type-3 JDBC-Net pure Java Driver
d) Type-4 Native protocol pure Java Driver
e) Type-5 Standard internet driver
I am just wondering whether there is a Type-5 driver? Is there any documentation available about this?
Ram Dhan YK

Ram Dhan Yadav (SCJP, SCWCD, SCJA-I, IBM EC(483))
"We are what we repeatedly do. Excellence, then, is not an act, but a habit."
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
JDBC drivers are divided into four types or levels. Each type defines a JDBC driver implementation with increasingly higher levels of platform independence, performance, and deployment administration. The four types are:
Type 1: JDBC-ODBC Bridge
Type 2: Native-API/partly Java driver
Type 3: Net-protocol/all-Java driver
Type 4: Native-protocol/all-Java driver
The 5th option was there just to confuse you.
Anyways the correct answer would be Type 3, The net-protocol/all-Java driver is server-based, so there is no need for any vendor database library to be present on client machines. Further, there are many opportunities to optimize portability, performance, and scalability. Moreover, the net protocol can be designed to make the client JDBC driver very small and fast to load.

Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
I agree. Here's the link:
subject: Are there 5 types of JDBC Drivers??
It's not a secret anymore!