- c = DriverManager.getConnection(credentials.getProperty("url"),
- credentials.getProperty("user"),
- credentials.getProperty("password"));
+ c = DriverManager.getConnection(credentials.getProperty("sql.url")
+ + "?zeroDateTimeBehavior=convertToNull",
+ credentials.getProperty("sql.user"),
+ credentials.getProperty("sql.password"));
+ PreparedStatement ps = c
+ .prepareStatement("SET SESSION wait_timeout=?;");
+ ps.setInt(1, CONNECTION_TIMEOUT);
+ ps.execute();
+ ps.close();
+ adHoc = c.createStatement();