File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Are there 5 types of JDBC Drivers??" Watch "Are there 5 types of JDBC Drivers??" New topic
Author

Are there 5 types of JDBC Drivers??

Ram Dhan Yadav K
Ranch Hand

Joined: Aug 13, 2001
Posts: 321
Hi,
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Are there 5 types of JDBC Drivers??