Bug fixed: made robust against lost of connection with db.

[logicplayer.git] / server / com / company / dbConnect.java

diff --git a/server/com/company/dbConnect.java b/server/com/company/dbConnect.java
index 309a9796dd6a6ed08834c9fed85d9612eb9b145a..7e9dd7866f82d0940c5278af31ed5ff0265da851 100644 (file)
--- a/server/com/company/dbConnect.java
+++ b/server/com/company/dbConnect.java
@@ -333,6 +333,10 @@ public class dbConnect
     }
 
     public String dbQuery(String input) throws SQLException, ClassNotFoundException, IllegalAccessException, InstantiationException, IOException, NoSuchAlgorithmException {
+        if(!db.isValid(2)) {
+            db = DriverManager.getConnection(global.dbConstant.dbLink + global.dbConstant.dbName, global.dbConstant.dbAdmin, global.dbConstant.dbPassword);
+            stmt = db.createStatement();
+        }
         deletetmp();
         if (input.charAt(0) == '0')
             return splitUsrPass(input.substring(2), 0);