Multiple choice

Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?

  1. Type 1 only

  2. Type 2 only

  3. Both Type 3 and Type 4

  4. All of Type 1, Type 2, Type 3 and Type 4
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When the Web server and DBMS run on the same machine, all four JDBC driver types (Type 1: JDBC-ODBC bridge, Type 2: Native API, Type 3: Net protocol, Type 4: Pure Java) can be used. The three-tier architecture with local co-location removes network restrictions that might limit some driver types. Type 4 drivers are most commonly preferred for being pure Java solutions.

Keep practicing — related questions