# HG changeset patch # User Sascha L. Teichmann # Date 1299088040 0 # Node ID c0d025df722d8621b3ab7aa4f07a6d504b6acb6e # Parent 5369582d4fbfabfd6db14e4287d891be570ec98d Enable backend to delete users artifacts/trunk@1370 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r 5369582d4fbf -r c0d025df722d artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java --- a/artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java Wed Mar 02 17:43:25 2011 +0000 +++ b/artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java Wed Mar 02 17:47:20 2011 +0000 @@ -822,7 +822,7 @@ Connection connection = null; PreparedStatement stmnt_next_id = null; PreparedStatement stmnt_insert = null; - ResultSet res_id = null; + ResultSet result = null; String identifier = newIdentifier(); @@ -835,13 +835,13 @@ stmnt_next_id = connection.prepareStatement(SQL_USERS_NEXT_ID); stmnt_insert = connection.prepareStatement(SQL_USERS_INSERT); - res_id = stmnt_next_id.executeQuery(); + result = stmnt_next_id.executeQuery(); if (!res_id.next()) { throw new RuntimeException("No id generated"); } - int id = res_id.getInt(1); + int id = result.getInt(1); stmnt_insert.setInt(1, id); stmnt_insert.setString(2, identifier); @@ -873,8 +873,8 @@ logger.error(sqle.getLocalizedMessage(), sqle); } finally { - if (res_id != null) { - try { res_id.close(); } + if (result != null) { + try { result.close(); } catch (SQLException sqle) {} } if (stmnt_insert != null) {