aspose file tools*
The moose likes JDBC and the fly likes JDBC Drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Drivers" Watch "JDBC Drivers" New topic
Author

JDBC Drivers

madhu vedhagiri
Greenhorn

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?
Thankyou
bye
nadh
------------------
John Bateman
Ranch Hand

Joined: Mar 09, 2000
Posts: 320
Hi
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.
http://java.sun.com/products/jdbc/faq.html
http://www.cariboulake.com/techinfo/jdbc_driver_types.html
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: JDBC Drivers
 
Similar Threads
Want to know how drivers work
JDBC Drivers Doubt
Batch Update Exception
Legacy Databases
java 5 Vs 6