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 JDBC Drivers 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 "JDBC Drivers" Watch "JDBC Drivers" New topic

JDBC Drivers

Vrushali Gore
Ranch Hand

Joined: Oct 17, 2005
Posts: 40
For Type1 & Type 2 drivers we say that we need to install libraries on Client side and even we say that the request processing takes on to the client side. How this happens? How can I explore my concept of my drivers? Why do all the processing takes place on to the client side wherein we say that in case of type 3 & type 4 drivers all the processings takes place on server side. How this happens actually
anagha patankar
Ranch Hand

Joined: Dec 26, 2005
Posts: 53
Type 1 is a JDBC ODBC driver
as a result it needs the ODBC code ( native = binary ) on the client

here client = machine that hosts the database connectivity

Type 2 drivers are part java part native code

so both these drivers have os compatibility issues

Infact type 1 would only run on Microsoft OS

Type 2 drivers would face portability issues

Regarding type 3 driver - havent come across a scenario where I would use one

type 4 is a pure java driver - gives good performance - no portability issues

Thanks ,
[ December 28, 2005: Message edited by: anagha patankar ]
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
Originally posted by anagha patankar:

Infact type 1 would only run on Microsoft OS

In fact, there are also ODBC drivers for the Macintosh.
I agree. Here's the link:
subject: JDBC Drivers
It's not a secret anymore!