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


raj joe
Ranch Hand

Joined: Mar 17, 2005
Posts: 99
Can you please let me know on what bases I choose the JDBC Drivers? I mean advantages and disadvantages of types of drivers, most of the times I get only sort of definitions on types of drivers and not there usage details
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

Whatever is available and mature. Typically you 'always' go for the type-4 'pure java' driver since it doesn't require anything extra installed on the client, you just send the driver JAR. But you may find a Type-4 driver for your database isn't stable or doesn't have all of the functionality implemented.

I've never seen it, but it's possible.
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42959
JDBC drivers are no different from other types of libraries: performance, support, cost and functionality all figure into the decision. It's not really possible to give a general recommendation because your situation will be unique in that regard.
Like David says, a type-4 is best for a number of circumstances, although I can't really comment on that, because I have purposely stayed away from the other types.
I surveyed the market once for SQLServer drivers, and started out with defining which features were crucial, then running some performance tests with the drivers that had the required features, and finally basing a decision on price and performance.
I agree. Here's the link:
subject: Drivers
jQuery in Action, 3rd edition