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
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 ?
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.
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.