MYSQL - Communications link failure; timeout

Question

The class below creates a connection to my MYSQL user, it then submits some data into a table.. I've checked and double checked the username and password, it's definitely 100% correct, but why does it keep throwing this memory leak? I am having trouble figuring this out myself, I've been reading all the related topics, but none really seems to be the same issue as mine.

package com.rs.MYSQL;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

import com.rs.Settings;
import com.rs.utils.Lottery;

public class LotteryMYSQL {

    private static Connection connection;

    private static long lastConnection = System.currentTimeMillis();

    public static void createConnection() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection(
                    "jdbc:mysql://runerebellion.com:3306/database",
                    "user", "pass");//fake user&pass
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void destroyConnection() {
        try {
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void init() {
        createConnection();
    }

    public static boolean updateInfo() {
        try {
            if (Settings.DisableMYSQL == true)
                return false;
            createConnection();
            Statement stmt = connection.createStatement();
            if (Lottery.getCurrentLotteryWinner() != null)
                stmt.executeUpdate("UPDATE info SET moneyEarned = '"
                        + Lottery.options.size() + "', lastWinner = '"
                        + Lottery.getCurrentLotteryWinner() + "'");
            else
                stmt.executeUpdate("UPDATE info SET moneyEarned = '"
                        + Lottery.options.size() + "', lastWinner = '"
                        + Lottery.getLastLotteryWinner() + "'");
            destroyConnection();
        } catch (Throwable e) {
            if (System.currentTimeMillis() - lastConnection > 10000) {
                destroyConnection();
                createConnection();
                lastConnection = System.currentTimeMillis();
            }
        }
        return false;
    }
}

The memory leak is below

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1137)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:356)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2504)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2541)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2323)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at com.rs.MYSQL.LotteryMYSQL.createConnection(LotteryMYSQL.java:19)
    at com.rs.Launcher.main(Launcher.java:103)
Caused by: java.net.ConnectException: Connection timed out: connect
    at java.net.DualStackPlainSocketImpl.connect0(Native Method)
    at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
    at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
    at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
    at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.SocksSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:258)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:306)
    ... 16 more

Are you able to connect to the MySQL database via command line or a client like MySQL workbench? — ivan.sim, Aug 23 '14 at 03:11
@RuneTebellion This guy gave a pretty thorough solution with a number of things to try [here](http://stackoverflow.com/a/10772407/1144203). Give it a go. — ivan.sim, Aug 23 '14 at 03:56

score -1 · Answer 1 · answered Aug 23 '14 at 17:06

Used this: and it worked fine

Class.forName("com.mysql.jdbc.Driver").newInstance();
            String IP = "";
            String DB = "";
            String User = "";
            String Pass = "";
            connection = DriverManager.getConnection("jdbc:mysql://" + IP + "/"
                    + DB, User, Pass);

MYSQL - Communications link failure; timeout

1 Answers1