File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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!