This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes simple question!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "simple question!!!" Watch "simple question!!!" New topic

simple question!!!

namita pa
Ranch Hand

Joined: Sep 06, 2001
Posts: 56
hi all
could anybody please tell me the difference between four types of JDBC drivers
Amit Agrawal
Ranch Hand

Joined: Aug 23, 2001
Posts: 282
Copy pasting from JDBC 3.0 Specification:
(See if you can make out any meaning :-) ).
9.1 Types of Drivers
There are many possible implementations of JDBC drivers. These implementations
are categorized as follows:
Type 1 � drivers that implement the JDBC API as a mapping to another data
access API, such as ODBC. Drivers of this type are generally dependent on a
native library, which limits their portability. The JDBC-ODBC Bridge driver is an
example of a Type 1 driver.
Type 2 � drivers that are written partly in the Java programming language and
partly in native code. These drivers use a native client library specific to the data
source to which they connect. Again, because of the native code, their portability
is limited.
Type 3 � drivers that use a pure Java client and communicate with a middleware
server using a database-independent protocol. The middleware server then communicates the client�s requests to the data source.
Type 4 � drivers that are pure Java and implement the network protocol for a specific data source. The client connects directly to the data source.

[This message has been edited by Amit Agrawal* (edited September 20, 2001).]
I agree. Here's the link:
subject: simple question!!!
It's not a secret anymore!