which is the best driver among the 4 jdbc drivers?

1.
a. Type 4 driver is the best driver among 4 drivers because it need not be load other API's, because the code is developed only in java language, so other language API's are not need.

b. Type 4 is the best driver because it directly interact with database without any usage od intermediate serversor other technology.Because of this reason Type-4 driver is also called Thin Driver

c. . Use Type 4 driver for applet to database communication.

2. Use Type 2 driver for two tiered applications for communication between java client and the database that gives better performance when compared to Type1 driver

3. Use Type 1 driver if your database doesn't support a driver. This is rare situation because almost all major databases support drivers or you will get them from third party vendors.

4.Use Type 3 driver to communicate between client and proxy server ( weblogic, websphere etc) for three tiered applications that gives better performance when compared to Type 1 & 2 drivers.

there, the order in which the drivers can be used is 4213,

SOURCE : www.referjava.com