Win a copy of OCP Oracle Certified Professional Java SE 11 Developer Practice Tests this week in the OCP 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
  • Paul Clapham
  • Jeanne Boyarsky
  • Ron McLeod
  • Tim Cooke
Sheriffs:
  • Devaka Cooray
  • paul wheaton
  • Mark Herschberg
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Frits Walraven
  • Jj Roberts
Bartenders:
  • Carey Brown
  • salvin francis
  • Piet Souris

DIFFERENT TYPES OF Jdbc Driver

 
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
Can someone please tell me what are the differences between avaliable types?
How do we identify for a given scenario which is the best suitable driver for use?
I understand that we have type1, type2 , type3 and type4 driver avaliable by Specification.
I needed help understanding scenario where particular driver can be the best fit.
Thanks,
Chetan
 
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Chetan,Mehta:
Hi,
Can someone please tell me what are the differences between avaliable types?
How do we identify for a given scenario which is the best suitable driver for use?
I understand that we have type1, type2 , type3 and type4 driver avaliable by Specification.
I needed help understanding scenario where particular driver can be the best fit.
Thanks,
Chetan



Hi Chetan,
This is actually easy, although it may not seem so. Type 1 is the JDBC-ODBC bridge driver. You only use it for ODBC connections, like ACCESS or Excel. It is not for distributed Apps.
Type 2 is basically non-existant, don't even worry about them (they are part Java, part native code, thus DB specific code has to be installed on each client).
Type 3 drivers communicate in a database independant protocol with a special middleware server, which then communicates directly with your database. This type is nice if you want to be able to easily move your app between databases (but this is less important with introduction of datasources).
Type 4 is a high performance all Java driver which communicates direcxtly with the database of choice.
I would recommend you get a Type 4 if at all possible.
Cheers,
Robert
 
reply
    Bookmark Topic Watch Topic
  • New Topic