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 Advantages of type3 jdbc driver when compare to typd4 jdbc driver 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 "Advantages of type3 jdbc driver when compare to typd4 jdbc driver" Watch "Advantages of type3 jdbc driver when compare to typd4 jdbc driver" New topic
Author

Advantages of type3 jdbc driver when compare to typd4 jdbc driver

subash subbu
Greenhorn

Joined: May 25, 2011
Posts: 17
Hi please tel me the advantages of type3 when compare to type4.
Pranav Raulkar
Ranch Hand

Joined: Apr 20, 2011
Posts: 73

Hi Radha,
Here is a short description from Oracle site http://www.oracle.com/technetwork/java/overview-141217.html

Type 3: Pure Java Driver for Database Middleware
This style of driver translates JDBC calls into the middleware vendor's protocol, which is then translated to a DBMS protocol by a middleware server. The middleware provides connectivity to many different databases.

Type 4: Direct-to-Database Pure Java Driver
This style of driver converts JDBC calls into the network protocol used directly by DBMSs, allowing a direct call from the client machine to the DBMS server and providing a practical solution for intranet access.

Also refer to this for a more detailed information http://www.roseindia.net/jdbc/jdbc-driver-and-its-types.shtml. Hope this hepls you.
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19649
    
  18

I'll move this thread to our JDBC forum.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Advantages of type3 jdbc driver when compare to typd4 jdbc driver
 
Similar Threads
Distributed Transactions
Hibernate + sun's jdbcodbc Driver
WSAD and JSQLConnect Driver
Type -3 JDBC driver : Network-Protocol Driver
type 3 or type 4 driver