JDBC/ODBC alternative in Java 8
The JDBC/ODBC driver is the type 1 driver it is also known as JDBC-ODBC bridge. It is ODBC driver to connect the database that convert the JDBC calls to ODBC function calls. Type 1 driver is fully platform dependent and use the native libraries of operating system. The ODBC driver must be installed in operating system. The Sun Microsystem provide JDBC-ODBC driver name as sun.jdbc.odbc.JdbcOdbcDriver but Oracle’s JDBC-ODBC Bridge was removed in Java 8 for following reasons:-
- Performance issue the calls have to go through the JDBC bridge to the ODBC driver so it is slower than other types of drivers.
- The ODBC driver must be installed on the client machine.