try to update your sql queries
Connection con = null;
+ PreparedStatement offline = null;
+ ResultSet rs = null;
+ try
+ {
+ con = ConnectionPool.getConnection();
+ offline = con.prepareStatement("SELECT * FROM character_memo_alt WHERE obj_id =?");
+ offline.setInt(1, player.getObjectId());
+ rs = offline.executeQuery();
+
+ while (rs.next())
+ {
+ String name = rs.getString("name");
+ String value = rs.getString("value");
+ long expire_time = rs.getLong("expire_time");
+ long curtime = System.currentTimeMillis();
+
+ if ((expire_time <= curtime) && (expire_time > 0))
+ {
+ deleteExpiredVar(player, name, rs.getString("value")); // TODO: Remove the Var
+ continue;
+ }
+
+ player.getVariables().put(name, new PlayerVar(player, name, value, expire_time));
+ }
+
+ con.close();
+ }
+ catch (Exception e)
+ {
+ e.printStackTrace();
+ }
+ finally
+ {
+ Mysql.closeQuietly(con, offline, rs);
+ }
such code is pre JDK8
thanks for sharing