Solved MySQL Help

Typically you want to remove the need for that. Mysql#query() and MySQL()#update already exist for that reason, you usually want to make the methods individually that would handle that specific data.

 

Well, it seems as if the problem wasn't with the code ; rather, it was Godaddy kicking me out for some security reasons. I've created a localhost MySQL server for temporary testing, and it works like a charm.
Anways, thank you to all who helped!

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Wizehh I completely reserve myself the right to say, "Told you so".

 

Maurdekye You were right

 

If anyone is still looking for a solution here is how it can be fixed:
1. Create a scheduler that will update the static Connection variable every 500k ticks (~7 hours).
2. Make sure that you access the Connection variable in a static manner (Ex: Plugin.connection.createStatement(); )

Code:java

 
public static Connection connection;
 
void loadDatabase(){
    final MySQL MySQL = new MySQL(this, host, port, database, user, password);
    connection = MySQL.openConnection();
 
    //schedule reconnect
    Bukkit.getScheduler().scheduleSyncRepeatingTask(this, new Runnable(){
        public void run(){
            connection = MySQL.openConnection();
        }
    }, 500000, 500000);
}