Win a copy of Machine Learning for Business: Using Amazon SageMaker and JupyterE this week in the Jython/Python forum
or Object Design Style Guide in the Object-Oriented programming 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
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
  • Knute Snortum
Sheriffs:
  • Liutauras Vilda
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Joe Ess
  • salvin francis
  • fred rosenberger

DRIVERS AND EXAMPLES

 
Ranch Hand
Posts: 207
  • 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?
 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • 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
  • 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
  • Mark post as helpful
  • send pies
  • 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
  • Quote
  • Report post to moderator
looks like a homework question to me.
 
thomas davis
Ranch Hand
Posts: 207
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please do it ...
 
thomas davis
Ranch Hand
Posts: 207
  • 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
  • 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.
 
Power corrupts. Absolute power xxxxxxxxxxxxxxxx is kinda neat.
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!