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

JDBC Drivers

madhu vedhagiri

Joined: Apr 19, 2000
Posts: 5
Hi Friends,
I know only one driver, that is type one. But i don't about remining drivers. How you can know about drivers and database information.And in what situation, each of the four drivers are used?
John Bateman
Ranch Hand

Joined: Mar 09, 2000
Posts: 320
Here's a good link on explanations on the diffrent drivers. You have to analyse each 'type' for the job it's going to perform.
In a nutshell some of these drivers are more (or lesss) portable across platforms for your application. You may rquire client installation, or server installation, it depends on the driver. (AsEx Type II is server installed with nothing to install on the client, but it's seen as more problematic to maintain). Also, some offer more (or less) accessability to the more advanced features of the JDBC2 package (javax.sql)
My opinion (and it's a bit biased at time) I like Type III drivers, their performance is great and they usually can handle all of the javax.sql stuff.
Type IV would be used if you need 100% java solution with your application.
[This message has been edited by John Bateman (edited April 24, 2000).]

SOURCE CODE should be SURROUNDED by "code" tags.
I agree. Here's the link:
subject: JDBC Drivers
jQuery in Action, 3rd edition