wood burning stoves 2.0*
The moose likes JDBC and the fly likes Example drivers for all the 4 types of JDBC Drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Example drivers for all the 4 types of JDBC Drivers" Watch "Example drivers for all the 4 types of JDBC Drivers" New topic
Author

Example drivers for all the 4 types of JDBC Drivers

nikita mishra
Greenhorn

Joined: Feb 09, 2010
Posts: 12
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?
Deepak Bala
Bartender

Joined: Feb 24, 2006
Posts: 6661
    
    5

-> http://jdbc.postgresql.org/download.html


SCJP 6 articles - SCJP 5/6 mock exams - More SCJP Mocks
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41065
    
  43
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?".


Ping & DNS - my free Android networking tools app
Deepak Bala
Bartender

Joined: Feb 24, 2006
Posts: 6661
    
    5

It does not.

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
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: 41065
    
  43
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.
 
Don't get me started about those stupid light bulbs.
 
subject: Example drivers for all the 4 types of JDBC Drivers
 
Similar Threads
Difference between Type II and Type IV driver
simple question!!!
No Suitable Drived found
Driver information
Driver types