Sunday 21 February 2016

JDBC/ODBC alternative in Java 8


java8.jpg

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:-
Disadvantages
  1. Performance issue the calls have to go through the JDBC bridge to the ODBC driver so it is slower than other types of drivers.
  2. The ODBC driver must be installed on the client machine.

Also visit Findnerd to read and post tech blogs and can also Ask tech Query over Findnerd.

No comments:

Post a Comment