File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DRIVERS AND EXAMPLES

 
thomas davis
Ranch Hand
Posts: 207
  • 0
  • Mark post as helpful
  • send pies
  • 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?
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
And more than that some experienced guys could add more details with that...
 
SJ Adnams
Ranch Hand
Posts: 925
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
looks like a homework question to me.
 
thomas davis
Ranch Hand
Posts: 207
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please do it ...
 
thomas davis
Ranch Hand
Posts: 207
  • 0
  • Mark post as helpful
  • send pies
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • 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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic