Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Drivers

 
raj joe
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42969
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic