aspose file tools*
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 Spring in Action this week in the Spring 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: 42276
    
  64
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