Different types of database drivers in java

6 rows · Since ODBC drivers and vendor Database libraries are available almost for all database Estimated Reading Time: 10 mins. 4- JDBC Driver for SQLServer (JTDS) JTDS is another JDBC library managing database SQLServer, it is a open source library. jTDS is an open source % pure Java (type 4) JDBC driver for Microsoft SQL Server (, 7, , , , ) and Sybase ASE (10, 11, 12, 15). jTDS is based on FreeTDS and is currently the fastest production.  · If you are accessing one type of database, such as Oracle, Sybase, or IBM, the preferred driver type is type If your Java application is accessing multiple types of databases at the same time, type 3 is the preferred driver. Type 2 drivers are useful in situations, where a type 3 or type 4 Estimated Reading Time: 4 mins.

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. JDBC Driver 1) JDBC-ODBC bridge driver. The JDBC-ODBC bridge driver uses ODBC driver to connect to the database. The JDBC-ODBC 2) Native-API driver. The Native API driver uses the client-side libraries of the database. The driver converts JDBC 3) Network Protocol driver. The Network Protocol. If you are accessing one type of database, such as Oracle, Sybase, or IBM, the preferred driver type is type If your Java application is accessing multiple types of databases at the same time, type 3 is the preferred driver. Type 2 drivers are useful in situations, where a type 3 or type 4.

Native-API partly-Java driver: This kind of driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix, DB2, or other DBMS. Note that. A Java application that wishes to communicate with any specific database uses JDBC Application Programming Interface(API). JDBC API is set of methods and. for portable access to an underlying database. Java can be used to write different types of executables, such as −. •. Java Applications. •. Java Applets.