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