Which JDBC type driver is best for enterprise application?

Type 4 drivers are more efficient.

Type 4 drivers are entirely written in Java that communicate directly with vendor's database through socket connection. Here no translation or middleware layer, are required which improves performance.

The driver converts JDBC calls into the vendor-specific database protocol so that client applications can communicate directly with the database server.

Advantages:

These drivers don't translate the requests into db request to ODBC or pass it to client api for the db, nor do they need a middleware layer for request indirection. Thus the performance is considerably improved.

Disadvantage:

At client side, a separate driver is needed for each database.

Retrieved from "http://en.wikipedia.org/wiki/JDBC_driver"

dvohra09a at 2007-7-14 22:57:58 >