What does this transaction block do if the second insert fai…
What does this transaction block do if the second insert fails? Connection con = DriverManager.getConnection(url, user, pass); con.setAutoCommit(false); try { Statement stmt = con.createStatement(); stmt.executeUpdate(“INSERT INTO users(name) VALUES (‘John’)”); stmt.executeUpdate(“INSERT INTO users(email) VALUES (‘test@example.com’)”); // Fails con.commit(); } catch (SQLException e) { con.rollback(); System.out.println(“Rolled back”); }
Read Details