Type1 Driver

Type1 Driver

Fig: Type1 Driver.JPG

·         THIS type of drivers are referred as Bridge drivers

·         And as of now we are available with only bridging to ODBC and such driver is referred as JDBC-ODBC Bridge driver.

Advantages of Type of Driver:

1.       This is a database independent JDBC driver

2.       T his type of driver is implemented as a part of the reference implementation and is included into the JDK. Thus provides an early access to use JDBC.

3.       EVERY data store that we can access using the ODBC, can be accessed using this type of JDBC Driver.

Disadvantages of this type of Driver:

1.       Because of multiple conversions the response time high compared to the other three type of JDBC Driver.

2.       This type of Driver is partly implemented in native and thus this application is unsafe, like any bug in the native code(i.e: ODBC Driver) could crash the JRE

When should we use TYPE 1 Driver:

1.       We use this type of driver in the development environment for performing unit testing of part of our application decision on using which JDBC driver is still pending.

2.       We want to use this type of JDBC driver in production (i.e. live)environment only if we don’t  have a JDBC Type-2 or 4 Drivers for the datastore that we want to access.

For example MS-Access  and MS Excel are accessed using this type of Driver (i.e via ODBC) Because of non availability of Type-2 or 4 Driver.