Changeset 76 for trunk/CrossPare/src

Timestamp:

05/06/16 09:25:03 (8 years ago)

Author:

sherbold

Message:

• modified MySQL connection to automatically reconnect

File:

• trunk/CrossPare/src/de/ugoe/cs/cpdp/eval/MySQLResultStorage.java (modified) (1 diff)

trunk/CrossPare/src/de/ugoe/cs/cpdp/eval/MySQLResultStorage.java

@@ -96 +96 @@
     {
         try {
+            Properties connectionProperties = new Properties();
+            connectionProperties.put("user", dbUser);
+            connectionProperties.put("password", dbPass);
+            connectionProperties.put("autoReconnect", "true");
+            connectionProperties.put("maxReconnects", "10000");
             Class.forName("com.mysql.jdbc.Driver");
             con = DriverManager.getConnection("jdbc:mysql://" + dbHost + ":" + dbPort + "/" +
-                dbName + "?" + "user=" + dbUser + "&" + "password=" + dbPass);
+                dbName, connectionProperties);
         }
         catch (ClassNotFoundException e) {