This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Driver types 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 "Driver types" Watch "Driver types" New topic
Author

Driver types

Shilpa Jain
Greenhorn

Joined: Aug 17, 2000
Posts: 16
Can anyone pls explain me what are the types of drivers, what are they used for and what is the difference between them?
Thank you
Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
Check put java.sun.com/product/jdbc. You will find links to:
#1 JDBC Drivers
#2 Sun's Tutorial's
#3 The answer to you question better than i ever could...
Hope this helps...

------------------
We learn more from our mistake's than from our success's.


Multi Platform Database Developer & DBA on E.S.T.
imran rafi
Greenhorn

Joined: Oct 21, 2000
Posts: 14
Sun has defined four JDBC driver types. These are:
1.Type 1: JDBC-ODBC Bridge Driver
The first type of JDBC dirver is JDBC-ODBC Bridge which provide JDBC access to any ODBC complaint databases through ODBC drivers. Sun's JDBC-ODBC bridge is example of type 1 driver.
2.Type 2: Native -API Partly - Java Driver
Type 2 drivers are developed using native code libraries, which were originally designed for accessing the database through C/C++. Here a thin code of Java wrap around the native code and converts JDBC commands to DBMS-specific native calls.

3.Type 3: JDBC-Net Pure Java Driver
Type 3 drivers are a three-tier solutions. This type of driver
communicates to a middleware component which in turn connects to database and provide database connectivity.

4.Type 4: Native-Protocol Pure Java Driver
Type 4 drivers are entirely written in Java that communicate directly with vendor's database through socket connection. Here no translation or middleware layer, are required which improves performance tremendously.
 
wood burning stoves
 
subject: Driver types
 
Similar Threads
types of relationships
What are the types of servlet containers
servlet containers
Values in VO getting lost in Stub
testing