wood burning stoves 2.0*
The moose likes JDBC and the fly likes WHich Driver  for which use? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "WHich Driver  for which use?" Watch "WHich Driver  for which use?" New topic
Author

WHich Driver for which use?

Sanjay Deshpande
Ranch Hand

Joined: May 22, 2001
Posts: 111
Can anyone plz tell me which JDBC driever can b used for what peropse?
A little explaination woud be very helpfull
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Originally posted by Sanjay Deshpande:
Can anyone plz tell me which JDBC driever can b used for what peropse?
A little explaination woud be very helpfull

A JDBC driver can be used to read, write and update data, table definitions and anything else that is within the JDBC interface specification and the underlying implementation of the driver to the database.
Jamie
Aashish Kaushik
Greenhorn

Joined: Mar 20, 2003
Posts: 4
Hi,
Originally posted by Sanjay Deshpande:
<Sanjay>Can anyone plz tell me which JDBC driever can b used for what peropse?
A little explaination woud be very helpfull </Sanjay>
Sanjay,Drivers can be classified in to four basic types and their usage depends on the Applications constraints.
1) Type 1 : JDC-ODBC Bridge Drivers
2) Type 2 : Partly Java part Native Drivers
3) Type 3: Intermediate database access server drivers
4) Type 4: Pure Java Drivers.
Usage of the Drivers depends on your application
but I have encountered most of the app. easily do away with Type 4 -Pure Java Drivers as they are the most efficient type with least system overhead
e.g Oracle thin Drivers.
However certain App. Servers like weblogic use Type 3 Drivers thus relieving the clients of loading,configuring the drivers.
I Hope that answers your question.
It would be better ,If you look around the net for resources.
Regards,
Aashish
Aashish Kaushik
Greenhorn

Joined: Mar 20, 2003
Posts: 4
Hi,
Originally posted by Sanjay Deshpande:
<Sanjay>Can anyone plz tell me which JDBC driever can b used for what peropse?
A little explaination woud be very helpfull </Sanjay>
Sanjay,Drivers can be classified in to four basic types and their usage depends on the Applications constraints.
1) Type 1 : JDC-ODBC Bridge Drivers
2) Type 2 : Partly Java part Native Drivers
3) Type 3: Intermediate database access server drivers
4) Type 4: Pure Java Drivers.
Usage of the Drivers depends on your application
but I have encountered most of the app. easily do away with Type 4 -Pure Java Drivers as they are the most efficient type with least system overhead
e.g Oracle thin Drivers.
However certain App. Servers like weblogic use Type 3 Drivers thus relieving the clients of loading,configuring the drivers.
I Hope that answers your question.
It would be better ,If you look around the net for resources.
Regards,
Aashish
 
 
subject: WHich Driver for which use?
 
Similar Threads
What is a top level class?
Java/J2EE, Siebel, SQL, PL/SQL, PeopleSoft requirements for Bangalore/Hyderabad
How can I used JSP to access MYSQL database??
URL monitor
doubt in EL