• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Difference between drivers

 
Sandeep Lodhia
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There are 4 categories of drivers viz.jdbc-odbc bridge driver,Native API...,Net Protocol...,Native Protocol..
Please explain me differences(or detailed tutorial on these).
Sandeep
 
KASI VISHWANATH
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The first type uses ODBC as the intermediate. In this jdbc relies on the ODBC for the connections.
The second form, the type two uses the drivers of the respective databases directly. Example the MYSQL and Oracle Drivers
------------------
I.K.VISHWANATH
 
KASI VISHWANATH
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The third one is pure java driver that uses networking protocol and the middle ware to communicate with a server. The server translates the protocol to the DBMS specific function calls.
The fourth on uses JAVA to implement DBMS vendor networking protocol such as ORACLE with no client installation or configuratin unlike the type type where it is required.
------------------
I.K.VISHWANATH
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic