From 77e5f7923230d1fda31efa01fc5aaa8277dc88cf Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Fri, 22 Jul 2016 16:25:45 +0200 Subject: [server] Fix embarassing messup in setExpireDate method (SQL and forgot commit) --- .../src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'dozentenmodulserver/src/main/java') diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java index 47aa2ced..7ffba241 100644 --- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java +++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java @@ -991,11 +991,12 @@ public class DbImage { public static void setExpireDate(String imageVersionId, long expireTime) throws SQLException { try (MysqlConnection connection = Database.getConnection()) { - MysqlStatement stmt = connection.prepareStatement("UPDATE imageversionid SET expiretime = :expiretime" + MysqlStatement stmt = connection.prepareStatement("UPDATE imageversion SET expiretime = :expiretime" + " WHERE imageversionid = :imageversionid"); stmt.setString("imageversionid", imageVersionId); stmt.setLong("expiretime", expireTime); stmt.executeUpdate(); + connection.commit(); } catch (SQLException e) { LOGGER.error("Query failed in DbImage.setExpireDate()", e); throw e; -- cgit v1.2.3-55-g7522