wood burning stoves 2.0*
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 Android Security Essentials Live Lessons this week in the Android 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: 19656
    
  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
 
Don't get me started about those stupid light bulbs.
 
subject: Advantages of type3 jdbc driver when compare to typd4 jdbc driver
 
Similar Threads
Distributed Transactions
type 3 or type 4 driver
Hibernate + sun's jdbcodbc Driver
WSAD and JSQLConnect Driver
Type -3 JDBC driver : Network-Protocol Driver