Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Example drivers for all the 4 types of JDBC Drivers

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Rancher
Posts: 43016
76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?".
 
Deepak Bala
Bartender
Posts: 6663
5
MyEclipse IDE Firefox Browser Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 43016
76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
We find this kind of rampant individuality very disturbing. But not this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic