19.3.1. Types of JDBC Drivers

Try these first

1. 1.

   What does JDBC stand for?

   Hint

   Think about what JDBC is used for.

2. 2.

   Why is the JDBC-ODBC Bridge Driver deprecated?

   Hint

   What are ODBC drivers typically used for?

3. 3.

   What is the main disadvantage of the JDBC-ODBC Bridge Driver?

   • Performance issues
   • Ease of use
   • Wide compatibility

   Hint

   Think about why we avoid using deprecated technologies.

4. 4.

   True or False: The Thin Driver is written entirely in Java and is platform-independent.

   • True
   • False

   Hint

   What advantages do you see in using a programming language designed for portability?

5. 5.

   Suppose you are developing an application that needs to access multiple types of databases efficiently (e.g., MySQL and Oracle). Which JDBC driver would you choose and why?

   Hint

   What does platform independence offer you in terms of flexibility?

6. 6.

   In what situations might a Native-API Driver become the preferred choice despite its limitations?

   Hint

   Think about specific use cases that might require deep integration with certain databases.