Problem to connect netbeans with Mysql

0

I'm having trouble connecting a netbean project with one from Mysql, I imported Mysql and added it to the library. But I have the following error:

java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1062)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3556)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2513)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at mysql.Mysql.main(Mysql.java:29)
Caused by: java.lang.ClassCastException: java.math.BigInteger cannot be cast to 
java.lang.Long
at 
com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1007)

This is the code I have in the netbeans project:

package mysql;
import java.sql.*;

public class Mysql {

/**
 * @param args the command line arguments
 */
public static void main(String[] args) {


    String url ="jdbc:mysql://127.0.0.1:3306/";
    String dbName = "bookstore";
    String drive = "com.mysql.jdbc.Driver";
    String userName = "root";
    String password = "root";

    try{
        //Class.forName(drive).newInstance();
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection(url+dbName,userName,password);

        conn.close();
    }catch (Exception e){
        e.printStackTrace();
    }


}

}

Thanks so much for the help!

    
asked by Chris 07.12.2018 в 13:11
source

0 answers