wood burning stoves*
The moose likes JDBC and the fly likes DRIVERS AND EXAMPLES Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DRIVERS AND EXAMPLES" Watch "DRIVERS AND EXAMPLES" New topic
Author

DRIVERS AND EXAMPLES

thomas davis
Ranch Hand

Joined: Feb 01, 2003
Posts: 207
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

Joined: Mar 06, 2001
Posts: 13459

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

Joined: Feb 01, 2003
Posts: 207
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

Joined: Feb 01, 2003
Posts: 207
And more than that some experienced guys could add more details with that...
SJ Adnams
Ranch Hand

Joined: Sep 28, 2001
Posts: 925
looks like a homework question to me.
thomas davis
Ranch Hand

Joined: Feb 01, 2003
Posts: 207
Please do it ...
thomas davis
Ranch Hand

Joined: Feb 01, 2003
Posts: 207
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

Joined: Mar 06, 2001
Posts: 13459

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.
 
 
subject: DRIVERS AND EXAMPLES
 
Similar Threads
Type 3 Driver
Hibernate + sun's jdbcodbc Driver
type 3 drive
finding Driver Type
Regarding Oracle thin and thick drivers