• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Drivers

 
madhu vedhagiri
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 320
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic