Problem with jdbc mysql public connection to database

[Mason Wyatt]

I am working on a small project but very important one for school, and I want to link my public database to the software using jdbc. I am getting connection error to the database!

I have started my project in localhost and it worked just fine.

PS: I am using, also, mysql-connector-java-8.0.15.jar and Hibernate.

I am using this method for the connection:

public static Connection getInstance() throws SQLException, ClassNotFoundException {
    if (conn == null){
        Class.forName("com.mysql.cj.jdbc.Driver");
        conn = DriverManager.getConnection(url, username, password);
    }
    return conn;
}

I can't show you the host ofc but I'll provide the format that I used and I am sure that it is the correct format.

static final String host = "***********";
static final String dbname = "**********";
static final String url = "jdbc:mysql://"+host+":3306/"+dbname";

I am excepting a normal connection to the database but, unfortunately, I can't!

[Knute Snortum]

Whenever you say, "I got an error," be sure to post the full error message and stack trace if any.

[Mike London]

You need to post additional information.

Did you try to step through your JDBC code in the debugger?

I would also try creating a simple database locally for testing. Make sure you can connect to that first.


- mike

[Tim Holloway]

Also, get rid of the Class.forName() line. It's long obsolete.