Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Are there 5 types of JDBC Drivers??

 
Ram Dhan Yadav K
Ranch Hand
Posts: 321
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic