Different types of database drivers

The JDBC and ODBC drivers are part of IBM Data Server Driver Package too. So, to test the connectivity for JDBC and ODBC drivers, you can follow the connectivity test steps documented under sections “IBM Data Server Driver for JDBC and SQLJ” and “IBM Data Server Driver for ODBC and CLI”. The following lists the IBM data server clients and drivers: IBM Data Server Driver Package; IBM Data Server Client; IBM Data Server Runtime Client; IBM Data Server Driver for JDBC and SQLJ. IBM Data Server Driver for ODBC and CLI.  · There are 4 types of JDBC drivers namely, Type-1, Type-2, Type-3 and, Type

Today, there are five types of JDBC drivers in use: Type 1: JDBC-ODBC bridge Type 2: partial Java driver Type 3: pure Java driver for database middleware Type 4: pure Java driver for direct-to-database Type 5: highly-functional drivers with superior performance. The following lists the IBM data server clients and drivers: IBM Data Server Driver Package; IBM Data Server Client; IBM Data Server Runtime Client; IBM Data Server Driver for JDBC and SQLJ. IBM Data Server Driver for ODBC and CLI. The JDBC and ODBC drivers are part of IBM Data Server Driver Package too. So, to test the connectivity for JDBC and ODBC drivers, you can follow the connectivity test steps documented under sections “IBM Data Server Driver for JDBC and SQLJ” and “IBM Data Server Driver for ODBC and CLI”.

JDBC Driver Types · Type 1 – Bridge Drivers · Type 2 – Native API · Type 3 – Network Protocol · Type 4 – Native Protocol · How to determine which driver to use for. 9 thg 2, JDBC Drivers · Type-1 driver or JDBC-ODBC bridge driver · Type-2 driver or Native-API driver · Type-3 driver or Network Protocol driver · Type The Type 1 driver translates all JDBC calls into ODBC calls and sends them to the ODBC driver. ODBC is a generic API. The JDBC-ODBC Bridge driver is recommended.