Sybex Practice Tests 11 - Chapter 11 - Q #11

[Andrey Kotelnikov]

Option D says "The code does not compile due to line s2."

But in code there is no such line with a comment //s2

var url = "jdbc:derby:bunnies";
var sql = "INSERT INTO bunny(name, color) VALUES (?, ?)";
try (var conn = DriverManager.getConnection(url);
  var stmt = conn.prepareStatement(sql)) {  // s1

  stmt.setString(1, "Daisy");
  stmt.setString(2, "Brown");

  stmt.executeUpdate();

  stmt.setString(1, "Cinna");
  stmt.setString(2, "Brown");

  stmt.executeUpdate();
}

[Campbell Ritchie]

Does the question show a catch or a finally? Neither is absolutely necessary because this is a try with resources.

[Andrey Kotelnikov]

Campbell Ritchie wrote:Does the question show a catch or a finally? Neither is absolutely necessary because this is a try with resources.

There are no catch or finally. They are not necessary here.
Eror is in option D description.
It says about some line with comment  //s2
But there is no line with such a comment in code. Though option D is not correct I think authors missed this comment (//s2) in code.

[Jeanne Boyarsky]

Agreed. Added to the errata.