diff options
| -rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java | 3 |
1 files changed, 2 insertions, 1 deletions
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; |