diff options
| author | Simon Rettberg | 2016-07-22 16:25:45 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2016-07-22 16:25:45 +0200 |
| commit | 77e5f7923230d1fda31efa01fc5aaa8277dc88cf (patch) | |
| tree | eca8841b321944e21561cc32300928d83be9d250 | |
| parent | [server] Cancel incoming transfer if a block failed more than 3 times (diff) | |
| download | tutor-module-77e5f7923230d1fda31efa01fc5aaa8277dc88cf.tar.gz tutor-module-77e5f7923230d1fda31efa01fc5aaa8277dc88cf.tar.xz tutor-module-77e5f7923230d1fda31efa01fc5aaa8277dc88cf.zip | |
[server] Fix embarassing messup in setExpireDate method (SQL and forgot commit)
| -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; |