View RSS Feed

JDBC

Type 2: Native-API/partly Java driver

Rate this Entry
by , 04-27-2012 at 06:59 PM (2412 Views)
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.

Pros
Type 2 drivers typically offer significantly better performance than the JDBC-ODBC Bridge.

Cons
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 3 and type 4 drivers.

Submit "Type 2: Native-API/partly Java driver" to Facebook Submit "Type 2: Native-API/partly Java driver" to Digg Submit "Type 2: Native-API/partly Java driver" to del.icio.us Submit "Type 2: Native-API/partly Java driver" to StumbleUpon Submit "Type 2: Native-API/partly Java driver" to Google

Categories
Driver

Comments