Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

WHich Driver for which use?

 
Sanjay Deshpande
Ranch Hand
Posts: 111
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic