File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Regarding Independent Drivers for Java Application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Regarding Independent Drivers for Java Application" Watch "Regarding Independent Drivers for Java Application" New topic

Regarding Independent Drivers for Java Application

srinath jeyanthi

Joined: Feb 14, 2001
Posts: 18
In my Apllication have Different OS's But Oracle Server(DataBAse) Running In Unix OS.But My code is work for all
type of Client Operating System.In This Situation How to write code for OS independent Application.
please clearly explain the Type 4 driver.
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
The native-protocol/all-Java driver (JDBC driver type 4) converts JDBC calls into the vendor-specific database management system protocol so that client applications can communicate directly with the database server. These Drivers are completely implemented in Java to achieve platform independence and eliminate deployment administration issues.
Advantages -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. Moreover, the native-protocol/all-Java driver boasts better performance than types 1 and 2. Also, there's no need to install special software on the client or server. Further, these drivers can be downloaded dynamically.
Disadvantages - With type 4 drivers, the user needs a different driver for each database.

Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
For intranet applications it would be useful to consider type 2 drivers. But since type 3 and type 4 drivers show significantly better performance than type 2 drivers and the trend is towards development of more robust pure-Java drivers, it might be useful to evaluate type 3 or type 4 for intranet situations too.
For Internet-related applications, there is no option but to use type 3 or type 4 drivers. Type 3 drivers are best suited for environments that need to provide connectivity to a variety of DBMS servers and heterogeneous databases and that require significantly high levels of concurrently connected users where performance and scalability are major concerns. Type 4 drivers are generally aimed at the workgroup level.
I agree. Here's the link:
subject: Regarding Independent Drivers for Java Application
It's not a secret anymore!