The most intelligent Java IDE
[Logo] JavaRanch » JavaRanch Saloon
  Search | FAQ | Recent Topics | Hot Topics
Register / Login


Reply Bookmark it! Watch this topic JavaRanch » Forums » Java » JDBC
 
RSS feed
 
New topic
Author

Example drivers for all the 4 types of JDBC Drivers

nikita mishra
Greenhorn

Joined: Feb 09, 2010
Messages: 6

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
Messages: 4847

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

SCJP 6 articles - SCJP 5/6 mock exams - SCJP Mocks - SCJP 5 Mock exam (Word document ) - SCJP 5 Mock exam in Java.Inquisition format
Ulf Dittmer
Sheriff

Joined: Mar 22, 2005
Messages: 26697

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?".

This message was edited 1 time. Last update was at by Ulf Dittmer


Java web chartsImageJ PluginsSpecification URLsJava FAQs
Deepak Bala
Bartender

Joined: Feb 24, 2006
Messages: 4847

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.

SCJP 6 articles - SCJP 5/6 mock exams - SCJP Mocks - SCJP 5 Mock exam (Word document ) - SCJP 5 Mock exam in Java.Inquisition format
nikita mishra
Greenhorn

Joined: Feb 09, 2010
Messages: 6

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
Sheriff

Joined: Mar 22, 2005
Messages: 26697

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.

Java web chartsImageJ PluginsSpecification URLsJava FAQs
 
 
 
Reply Bookmark it! Watch this topic JavaRanch » Forums » Java » JDBC
 
RSS feed
 
New topic
hibernate profiler

.