Are there 5 types of JDBC Drivers??

[Ram Dhan Yadav K]

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

[rani bedi]

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.