This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan 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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 19541
    
  16

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
Hibernate + sun's jdbcodbc Driver
Distributed Transactions
WSAD and JSQLConnect Driver
Type -3 JDBC driver : Network-Protocol Driver
type 3 or type 4 driver