Win a copy of Rust Web Development this week in the Other Languages 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

Type3 and Type4 drivers for JDBC

 
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I have worked using TYPE2 driver for Oracle-JDBC scenario.It was reasonably cool.And I was comfortable with that.But I have not used TYPE 3 and TYPE4 drivers.I have heard that they are more generic in the sense they are completely Java based.And the reusability is pretty good.The syntax wise also the changes are easy to be made.is it so?Does the "Java Data" deal with these advanced drivers? I hope it does.
 
Author
Posts: 65
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Vaibhav,
yes, Pro Java Data does discuss all types of JDBC drivers, including type 3 and type 4. But I don't think these are any more "advanced" than type 2 drivers, they're just implemented differently.
Regards,

------------------
Bjarki Holm
Author of Professional Java Data
 
vaibhav punekar
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Bjarki.
By the way how should we pronounce your name?I know you guys also might be finding our names tricky to be pronounced.
So is it that people are shifting to TYPE3 and TYPE4?Or TYPE2 is pretty ok as far as reusability and perfonmance goes.
 
Bjarki Holm
Author
Posts: 65
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Well, it really depends on what drivers you are using, and what DBMS is targeted. There is really no simple answer to this. In one place, a type 2 driver might be the best choice, whereas you could have a type 3 driver somewhere else.
Hmmm... how my name is pronounced? Try "Bjaarghi"... this is Icelandic, which is probably hard for everyone to pronounce (except for, maybe, Germans)
Regards,
------------------
Bjarki Holm
Author of Professional Java Data
 
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Type 3: Net-protocol/all-Java driver follows a three-tiered approach whereby the JDBC database requests are passed through the network to the middle-tier server. The middle-tier server then translates the request (directly or indirectly) to the database-specific native-connectivity interface to further the request to the database server. If the middle-tier server is written in Java, it can use a type 1 or type 2 JDBC driver to do this.
Type 4: Native-protocol/all-Java driver
The native-protocol/all-Java driver converts JDBC calls into the vendor-specific DBMS protocol so that client applications can communicate directly with the database server. Level 4 drivers are completely implemented in Java to achieve platform independence and eliminate deployment administration issues.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic