Hello friends, If we use type-1 driver in our application and DBMS is changed in the server. Can we still be able to run the application? If not , and we have to change the driver in the client.. will this mean type-1 driver is DBMS specific? Thanks in advance.
Type 1 is the JDBC/ODBC bridge. It depends on an ODBC connection, not on a particular DB. As long as the DB in question supports ODBC connectivity, you should be able to replace it without changing the JDBC code. (That you should not use the JDBC/ODBC bridge at all is another matter.)