jMonkeyEngine.org

Hi,
I made a small game which uses mysql database. The game just retrieves data from the mysql database and update data aswell. It just stores the float data of the spatial’s position and updates it. The database works properly in my laptops localhost, but when I made a free host database online and tried to connect there it gives an error, below is the error:

“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.”

this is the class for connecting to the database:

package ClientSide.login;

import java.sql.*;

public class loginInfo {
    public String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    public String DATABASE_URL = "jdbc:mysql://localhost:1433/link-to-my-database";

    public Connection conn = null;
    public Statement state = null;

    public boolean isExit(String user, String pass)
    {
        boolean exist = false;

        try{
            Class.forName(JDBC_DRIVER);
            conn = DriverManager.getConnection(DATABASE_URL,"root","password");
            state = conn.createStatement();
            ResultSet resultSet = state.executeQuery("Select * FROM login WHERE user = '"+user+"' AND pass = '"+pass+"'");
            int count = 0;
            while(resultSet.next())
            {
                count++;
            }

            if(count > 0)
            {
                exist = true;
            }

        }catch(Exception e){
            System.out.println(e);
        }finally{

            try{
                state.close();
                conn.close();
            }catch(Exception e){
            }

        }

        return exist;
    }
}

It will be very helpful if any one can help me with this. Thanks in advance.
K Out!

@sbook

No no, i am not offended i welcome any good advices plus I am doing this to get the connection right with the online database. Just am determined to make it work.

Yes, this is the code for connecting to the online database.

I changed the port to 3306 and now have a new error message, below:
“java.sql.SQLException: Access denied for user ‘root’@'localhost’ (using password: YES)”

I also tried with the port 3307 but gives the previous error.

kamran said:
Yes, this is the code for connecting to the online database.

I changed the port to 3306 and now have a new error message, below:
“java.sql.SQLException: Access denied for user ‘root’@'localhost’ (using password: YES)”

The online database is not located on localhost (which is your laptop), its located somewhere online, like “freedatabases.com” (I really hope that’s not a real website)

Of course, I can’t be sure without some info on which online host this is, but you’ll probably want something like:

public String DATABASE_URL = "jdbc:mysql://freedatabases.com:3306/name-of-your-database";

madjack said:
MySQL might be denying access because it’s set to refuse remote root connection.

This could also have something to do with it. I’m 99.99999% sure that an online hosting company is not giving you the username “root”.

is it looking for the database in my local server for some reason?

yes, It was “localhost” all this time but now i changed it to the online database one which is
“jdbc:mysql://game.something.com:3306/game_something_mmo”. But still the above error is giving.

yes I am using the root and username that they gave me.

root is for example something like this “12345_root”

Can you post a link to the online service you’re using? Its hard to help you without knowing how their service is supposed to be configured!