Solved Using MySQL Error (EOFException)

Hello,

Currently I have been making a point system for a plugin of mine and ran into an error (I'm using -_Husky_- 's Resource for using MySQL in Bukkit plugins). Here some information:
Stacktrace:

Code:

[18:28:53 WARN]: Caused by: java.io.EOFException: Can not read response from ser
ver. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly l
ost.
[18:28:53 WARN]:        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2529)
[18:28:53 WARN]:        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
a:2979)
[18:28:53 WARN]:        ... 36 more

Whole class:

Code:java

import org.bukkit.Bukkit;
 
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
public class PointPlayer {
 
    private Statement statement;
    private String playerName;
    private int balance = 0;
    private ResultSet res;
 
    public PointPlayer(String player) {
        try{
            statement = instance.c.createStatement();
            playerName = player;
            res = statement.executeQuery("SELECT * FROM points WHERE PlayerName = '" + playerName + "';");
            while(res.next()) {
                if(res.getString("PlayerName") != null) {
                    balance = res.getInt("points");
                    if(balance == 0) {
                        this.addPoints(50);
                    }
                }else{
                    statement.executeUpdate("INSERT INTO points ('PlayerName', 'points') VALUES ('" + playerName + "', '50');");
                }
            }
        }catch(SQLException e) {e.printStackTrace();}
    }
 
    public void addPoints(int amount) {
        balance = balance + amount;
        updateValues();
    }
 
    private void updateValues() {
        try{
            startConnection();
            Bukkit.broadcastMessage(playerName + "." + balance);
            statement = instance.c.createStatement();
            statement.executeUpdate("INSERT INTO points ('PlayerName', 'points') VALUES ('" +
                    playerName + "', '" +
                    balance + "');");
        }catch(SQLException e) {e.printStackTrace();}
    }
 
    public void setPoints(int bal) {
        this.balance = bal;
        updateValues();
    }
 
    public void removePoints(int amount) {
        if((balance - amount) == 0) {
            return;
        }
        balance = balance - amount;
        updateValues();
    }
 
    public int getBalance() {
        return balance;
    }
 
    public boolean hasAmount(int amount) {
        return balance >= amount;
    }
 
    public void startConnection() {
            instance.mySQL.openConnection();
            instance.mySQL.getConnection();
    }
}

One of the stacktraces I saw pointed to this line:

Code:java

res = statement.executeQuery("SELECT * FROM points WHERE PlayerName = '" + playerName + "';");

I am hosting the MySQL database from GoDaddy, and created the table manually through PHPMyAdmin.

Any help is appreciated

 

I'm sorry, is this topic solved or not?

 

By the looks of things, the server is not communicating with your plugin. Have you logged into the server on your main class? Try hoisting the server so me where else and see if the problem carry's on.

 

mazentheamazin
Did you happen to leave it for a while before calling this? I find that same issue when leaving he server for a while, then having a method called that attempts to access the server.

Reloading seems to resolve the issue, so I feel safe putting it down to a timeout issue, despite me having it check the connection whenever running a method regarding mysql.

 

valon750
+1 for necrodooming a thread xD I've fixed this a long time ago, hence why this the thread tag 'Solved'