From 87cade6d92ba75d01d8b61133328a0753e0d7840 Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Thu, 21 Apr 2022 17:07:03 +0200 Subject: [server] Fix query call (not an update) --- .../java/org/openslx/bwlp/sat/database/mappers/DbMailQueue.java | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'dozentenmodulserver') diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbMailQueue.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbMailQueue.java index 479392dc..360f4f6a 100644 --- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbMailQueue.java +++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbMailQueue.java @@ -39,10 +39,10 @@ public class DbMailQueue { // Delete old mails that got stuck in the queue, optimize table MysqlStatement delStmt = connection.prepareStatement("DELETE FROM mailqueue" + " WHERE UNIX_TIMESTAMP() - dateline > 86400 * 2"); - int cnt = delStmt.executeUpdate(); - if (cnt != 0 || Math.random() < .01) { + delStmt.executeUpdate(); + if (Math.random() < .01) { MysqlStatement optStmt = connection.prepareStatement("OPTIMIZE TABLE mailqueue"); - optStmt.executeUpdate(); + optStmt.execute(); } MysqlStatement stmt = connection.prepareStatement("SELECT" + " mailid, userid, message FROM mailqueue" -- cgit v1.2.3-55-g7522