aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 6657
    
    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: 39547
    
  27
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 - updated with new look and Ping home screen widget
Deepak Bala
Bartender

Joined: Feb 24, 2006
Posts: 6657
    
    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: 39547
    
  27
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Example drivers for all the 4 types of JDBC Drivers
 
Similar Threads
No Suitable Drived found
Driver types
simple question!!!
Driver information
Difference between Type II and Type IV driver