Type 1 Driver
In this tutorial, we are going to discuss about the Type 1 Driver in JDBC. The Type 1 JDBC driver, also known as the JDBC-ODBC Bridge Driver, serves as a bridge between JDBC API calls in Java applications and ODBC API calls in the underlying operating system.
This Driver provided by Sun Micro Systems as the Part of JDK. But this Support is available until 1.7 Version only.
Internally this Driver will take Support of ODBC Driver to communicate with Database. Type 1 Driver converts JDBC Calls (Java Calls) into ODBC Calls and ODBC Driver converts ODBC Calls into Database specific Calls. Hence Type 1 Driver acts as Bridge between JDBC and ODBC.
Advantages
- It is very easy to use and maintain.
- We are not required to install any separate Software because it is available as the Part of JDK.
- Type-1 Driver won’t communicates directly with the Database. Hence it is Database Independent Driver. Because of this migrating from one Database to another Database will become Easy.
Limitations
- It is the slowest Driver among all JDBC Drivers (Snail Driver), because first it will convert JDBC Calls into ODBC Calls and ODBC Driver converts ODBC Calls into Database specific Calls.
- This Driver internally depends on ODBC Driver, which will work only on Windows Machines. Hence Type-1 Driver is Platform Dependent Driver.
- No Support from JDK 1.8 Version onwards.
Because of above Limitations it is never recommended to use Type 1 Driver.
That’s all about the Type 1 Driver in JDBC. If you have any queries or feedback, please write us email at contact@waytoeasylearn.com. Enjoy learning, Enjoy Java.!!