Mysql DB connection with JDBC freezing program

Question

I have the MySQL JDBC library added to my eclipse project but I still cant connect to a database, the program doesn't throw an error, it just freezes on me. Here's the link to the Library I used http://dev.mysql.com/downloads/connector/j and my current code ( username, host, and passwords omitted.

  private Connection connect = null;
  private Statement statement = null;
  private PreparedStatement preparedStatement = null;
  private ResultSet resultSet = null;

@Override
    try {
          // This will load the MySQL driver, each DB has its own driver
          Class.forName("com.mysql.jdbc.Driver");
          // Setup the connection with the DB
          connect = DriverManager
              .getConnection("jdbc:mysql://host:8080/feedback?"
                  + "user=******Admin&password=********");

          // Statements allow to issue SQL queries to the database
          statement = connect.createStatement();
          // Result set get the result of the SQL query
          System.out.println("Connected");
        } catch (Exception e) {
          System.out.println("Connection failed");

SOLUTION I had the port wrong, the driver installed improperly AND the database name was wrong. Here was the correct connection line after fixing the driver.

 connect = DriverManager
                  .getConnection("jdbc:mysql://localhost:3306/DataBase?"
                      + "user=****Admin&password=*******");

Can you use a debugger to find out where the program freezes? — Sotirios Delimanolis
– Sotirios Delimanolis, Commented Sep 3, 2013 at 20:37
I run it in eclipse with my personal method of debugging (adding comments as checkpoints) and narrowed it down to the connection line as fault. When i enter intentionally wrong details for the connection it will throw an exception and it is caught in the catch. — Chris
– Chris, Commented Sep 3, 2013 at 20:40
Just tested with a faulty username and got the same result.. crashed program. The user exists.. I think? I couldnt change the MySQL root password so I created a new user in phpmyadmin — Chris
– Chris, Commented Sep 3, 2013 at 20:42
have you enabled remote access for the user? In case the server is remote ... And the port ... 8080, are you sure that's correct? — Katona
– Katona, Commented Sep 3, 2013 at 20:46

Ever Think · Accepted Answer · 2013-09-04 05:53:04Z

4

Try to connect in the format

DriverManager.getConnection("jdbc:mysql://localhost:port","username" , "password");

Please use the latest driver that fits you mysql version.

answered Sep 4, 2013 at 5:53

Ever Think

81112 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Katona · Accepted Answer · 2013-09-03 20:56:35Z

1

Unless you changed the port of your MySQL server to 8080, your jdbc url is wrong. If you have not changed the default port, then you should use jdbc:mysql://host/feedback?user=******Admin&password=********.

answered Sep 3, 2013 at 20:56

Katona

4,9011 gold badge25 silver badges28 bronze badges

8 Comments

Chris Over a year ago

the host is correct, it throws an error if it is wrong. Ive already tested that.

Katona Over a year ago

@user2341336 ok, but what about with the port? 8080 is usually a webcontainer (like tomcat), mysql's default port is 3306, which you can omit, if you have not changed it, this is what I am pointing on in my answer

Chris Over a year ago

i'll try that, Im using wamp running a webserver off of port 8080

Chris Over a year ago

Exception thrown and printed Connection failed.

Katona Over a year ago

@user2341336 by the way, if you have your mysql running locally, then you should use localhost instead of host

|

Collectives™ on Stack Overflow

Mysql DB connection with JDBC freezing program

2 Answers 2

Comments

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related