jdbc: split updates

1 files changed, 6 insertions, 2 deletions

diff --git a/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java b/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java
index f579577f..0c53740d 100644
--- a/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java
+++ b/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java
@@ -188,11 +188,15 @@ public class MessagesServiceImpl extends BaseJdbcService implements MessagesServ
                 new Object[]{mid, ridnew, uid, rid, attachment, txt},
                 new int[]{Types.INTEGER, Types.SMALLINT, Types.INTEGER, Types.SMALLINT, Types.CHAR, Types.VARCHAR});
 
-        if (ridnew > 0)
+        if (ridnew > 0) {
+            getJdbcTemplate().update(
+                    "UPDATE messages SET replies = replies + 1 WHERE message_id = ?",
+                    mid);
             getJdbcTemplate().update(
                     "UPDATE messages, (SELECT ts FROM replies) as r " +
-                            "SET messages.replies = messages.replies + 1, messages.updated = r.ts WHERE message_id = ?",
+                            "SET messages.updated = r.ts WHERE message_id = ?",
                     mid);
+        }
         return ridnew;
     }