Connecting java with sql. error

Question

package pokemon;
import java.sql.Connection;
import java.sql.DriverManager;


public class Main {

public static void main(String[] args) throws Exception {

    getConnection();

}
public static Connection getConnection() throws Exception{
    try{
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306:Pokedex";
        String username = "test";
        String password = "password";
        Class.forName(driver);

        Connection conn =      DriverManager.getConnection(url,username,password);  
        System.out.println("Connected");
        return conn;            
    } catch(Exception e){System.out.println(e);}


    return null;
}
}

I get the error

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "3306:Pokedex"'.

I'm simply trying to see if I'm connected to the database so that I can enter data in my tables.

Your url is incorrect. It should be jdbc:mysql://localhost:3306/Pokedex — Bunti
– Bunti, Commented Mar 8, 2016 at 4:49

Vipin Jain · Accepted Answer · 2016-03-08 05:03:03Z

1

You are write wrong url. plz Replace it with this line

String url = "jdbc:mysql://localhost:3306/Pokedex";

https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-connect-drivermanager.html

answered Mar 8, 2016 at 5:03

Vipin Jain

3,77618 silver badges36 bronze badges

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

Comments

Bunti · Accepted Answer · 2016-03-08 05:03:19Z

1

Your database URL is incorrect. It needs to be

jdbc:mysql://localhost:3306/Pokedex

You would use a JDBC connection pool whenever possible unless you have a very basic application.

answered Mar 8, 2016 at 5:03

Bunti

1,76016 silver badges21 bronze badges

1 Comment

Coty Over a year ago

Thank you very much!! That did indeed fix it.

Collectives™ on Stack Overflow

Connecting java with sql. error

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related