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