Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes Drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Drivers " Watch "Drivers " New topic
Author

Drivers

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
Rancher

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
Marshal

Joined: Mar 22, 2005
Posts: 41180
    
  45
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.


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Drivers
 
Similar Threads
Example drivers for all the 4 types of JDBC Drivers
Drivers
mysql drivers
Driver Architectures
about jdbc drivers