File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes JDBC drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC drivers" Watch "JDBC drivers" New topic
Author

JDBC drivers

Deepika Wadhwa
Ranch Hand

Joined: Aug 05, 2000
Posts: 57
Hi all,
what is the type 4 JDBC driver?
I checked thru so many sites and books... but didn't get complete details...
if anybody of u have used it please give me response asap.
thanx in advance,
Deepika
Deepika Wadhwa
Ranch Hand

Joined: Aug 05, 2000
Posts: 57
Hey !!!
No body is there to give me detailed description of JDBC Type 4 Driver ....
plz don't ignore this post.

Deepika
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
See: http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/intro.html#1018502


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
Deepika Wadhwa
Ranch Hand

Joined: Aug 05, 2000
Posts: 57
Thanx Thomas for ur response ,
But I think u didn't get my point. We are using oracle database for our application to make connection, we are using type 4 driver while for Oracle type 2 and type 4 both drivers are available.
so what are the benefits of using type for drivers ?

Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Did you read the info at the site:
Driver categories 3 and 4 are the preferred way to access databases using the JDBC API. Driver categories 1 and 2 are interim solutions where direct pure Java drivers are not yet available.
In the case of type 2 drivers, they are undesirable because they are not a pure Java solution and require special native drivers to be installed on the client.
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
JDBC driver type 2 (the native-API/partly Java driver)converts JDBC calls into database-specific calls for databases such as SQL Server, Informix, Oracle, or Sybase. The type 2 driver communicates directly with the database server; therefore it requires that some binary code be present on the client machine.
The vendor database library needs to be loaded on each client machine. Consequently, type 2 drivers cannot be used for the Internet. Type 2 drivers show lower performance than type 4 drivers.
The JDBC driver type 4 (native-protocol/all-Java driver) converts JDBC calls into the vendor-specific database management system (DBMS) protocol so that client applications can communicate directly with the database server. Level 4 drivers are completely implemented in Java to achieve platform independence.Since type 4 JDBC drivers don't have to translate database requests to ODBC or a native connectivity interface or to pass the request on to another server, performance is typically quite good. Also, there's no need to install special software on the client or server.
But With type 4 drivers, the user needs a different driver for each database.


Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
Deepika Wadhwa
Ranch Hand

Joined: Aug 05, 2000
Posts: 57
thanx Thomas & Parmeet Bedi,
now its clear to me.
thanx a lot,
Deepika
 
jQuery in Action, 2nd edition
 
subject: JDBC drivers