Question: How many different types of JDBC drivers are present? Discuss them.

Answer: Type 1: JDBC-ODBC Bridge plus ODBC Driver: The first type of JDBC driver is the JDBC-ODBC Bridge. It is a driver that provides JDBC access to databases throughODBC drivers. The ODBC driver must be configured on the client for the bridge to work. This driver type is commonly used for prototyping or when there is no JDBC driveravailable for a particular DBMS.

Type 2: Native-API partly-Java Driver: The Native to API driver converts JDBC commands to DBMS-specific native calls. This is much like the restriction of Type 1 drivers.The client must have some binary code loaded on its machine. These drivers do have an advantage over Type 1 drivers because they interface directly with the database.

Type 3: JDBC-Net Pure Java Driver: The JDBC-Net drivers are a three-tier solution. This type of driver translates JDBC calls into a databaseindependent network protocolthat is sent to a middleware server. This server then translates this DBMSindependent protocol into a DBMS-specific protocol, which is sent to a particular database. Theresults are then routed back through the middleware server and sent back to the client. This type of solution makes it possible to implement a pure Java client. It also makesit possible to swap databases without affecting the client.

Type 4: Native-Protocol Pur Java Driver: These are pure Java drivers that communicate directly with the vendor's database. They do this by converting JDBC commandsdirectly into the database engine's native protocol. This driver has no additional translation or middleware layer, which improves performance tremendously.

Question: How many different types of JDBC drivers are present? Discuss them.Answer:

Type 1: JDBC-ODBC Bridge plus ODBC Driver: The first type of JDBC driver is the JDBC-ODBC Bridge. It is a driver that provides JDBC access to databases throughODBC drivers. The ODBC driver must be configured on the client for the bridge to work. This driver type is commonly used for prototyping or when there is no JDBC driveravailable for a particular DBMS.

Type 2: Native-API partly-Java Driver: The Native to API driver converts JDBC commands to DBMS-specific native calls. This is much like the restriction of Type 1 drivers.The client must have some binary code loaded on its machine. These drivers do have an advantage over Type 1 drivers because they interface directly with the database.

Type 3: JDBC-Net Pure Java Driver: The JDBC-Net drivers are a three-tier solution. This type of driver translates JDBC calls into a databaseindependent network protocolthat is sent to a middleware server. This server then translates this DBMSindependent protocol into a DBMS-specific protocol, which is sent to a particular database. Theresults are then routed back through the middleware server and sent back to the client. This type of solution makes it possible to implement a pure Java client. It also makesit possible to swap databases without affecting the client.

Type 4: Native-Protocol Pur Java Driver: These are pure Java drivers that communicate directly with the vendor's database. They do this by converting JDBC commandsdirectly into the database engine's native protocol. This driver has no additional translation or middleware layer, which improves performance tremendously. Source: CoolInterview.com

Four Types of Database drivers:Type 1: Uses the JDBC-ODBC bridges.Type 2: Uses adirect connection to Databse.The RDBMSvor client-access support provided by the databse vendor must reside on the same host as the client program. this is the most efficient driverType 3: The client is connected to the Database over a TCP/IP connectionType 4: atype 4 driver is like type 3 driver but contains only java code.only type 4 driver are guaranteed to pure java Source: CoolInterview.com