Example drivers for all the 4 types of JDBC Drivers
nikita mishra
Greenhorn
Joined: Feb 09, 2010
Posts: 12
posted
0
Hi! I know we have 4 types of JDBC drivers such as Type 1: JDBC-ODBC Bridge Driver, Type 2: JDBC-Native API, Type 3: JDBC-Net pure Java, Type 4: 100% pure Java. Can anyone provide example drivers for all the four types of drivers?
I'm not sure how a download link for Postgresql's type 4 driver helps explain JDBC driver types, but you may want to start reading at http://faq.javaranch.com/java/GeneralJdbcQuestions, especially the answer to "Q. What are the differences between the 4 types of drivers?".
Can anyone provide example drivers for all the four types of drivers?
I was assuming that the OP wanted to use an example of the different types of drivers.
nikita if that is not what you were asking for please feel free to reply over this thread.
nikita mishra
Greenhorn
Joined: Feb 09, 2010
Posts: 12
posted
0
I wanted to know all the available drivers for jdbc and the categories(type 1,2,3,4) they fall into. After referring http://developers.sun.com/product/jdbc/drivers it seems oracle does not provide type 1,2 or 3 drivers. Can you moderators or other java veterans please tell me what are the drivers you have used in your projects?
Ulf Dittmer
Marshal
Joined: Mar 22, 2005
Posts: 35223
7
posted
0
Most drivers being used these days are type 4 drivers (by a wide margin, I'd guess). Being the only type that is all-Java, they're the easiest to set up and use. It was different when JDBC came out (in 1997 or so), and not many all-Java drivers existed, but no more.