• 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:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

DRIVERS AND EXAMPLES

 
Ranch Hand
Posts: 207
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
1)Please give a brief description of all type of drivers and their advantages, disadvantages, usage and examples?
TYPE 1 JDBC-ODBC driver
Description:
Example:
Advantage:
Disadvantage:
Where and when to use:
TYPE 2 NATIVE-API driver
Description:
Example (both Oracle and Sql Server):
Advantage:
Disadvantage:
Where and when to use:

TYPE 3 NET-PROTOCOL driver
Description:
Example (both Oracle and Sql Server):
Advantage:
Disadvantage:
Where and when to use:

TYPE 4 NATIVE-PROTOCOL driver
Description:
Example (both Oracle and Sql Server):
Advantage:
Disadvantage:
Where and when to use:
Could someone help me in this regard?
 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
A description of the four driver types can be found here at the Java site. You can find specific drivers using the dirver search at the same site.
Dave
 
thomas davis
Ranch Hand
Posts: 207
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I thought of gathering all basic information of JDBC from all of you and club together and put it in one place so that anybody could find it easily..These are basic questions to be clarified ...And these are not properly mentioned in the link given by you.So please encourage the people to put these in a table format and make it more readable.I am sure that this type formatting definetly help the developers..I hope you got my intention..Please bear with me..I am afraid that I am demanding too much..
There are some information say advantages,disadvantages,driver names are missing..
 
thomas davis
Ranch Hand
Posts: 207
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
And more than that some experienced guys could add more details with that...
 
Ranch Hand
Posts: 925
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
looks like a homework question to me.
 
thomas davis
Ranch Hand
Posts: 207
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Please do it ...
 
thomas davis
Ranch Hand
Posts: 207
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sr NoType Of DriverDescriptionExample for Sql Server & Oracle
1TYPE 1 JDBC-ODBC driver
2TYPE 2 NATIVE-API driver
3TYPE 3 NET-PROTOCOL driver
4TYPE 4 NATIVE-PROTOCOL driver

AdvantageDisadvantageWhere to useWhen to use
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
We've given you the tools to get you started, what I can't understand is why you refuse use that to get started and then ask us for help to fill the blanks. Your initial post was on the 4th, it's now 5 days later and you're not showing us anything.
reply
    Bookmark Topic Watch Topic
  • New Topic