Java, SQL Database Connection eror

Question

I am newbie, is learning to make the program connect to the mysql database, but there is an error. i want to know how to look for url jdbc: mysql:

public class KoneksiDatabase {
private static Connection koneksi;
public static Connection getKoneksi(){
    if (koneksi == null) {
        try {
            String url = "jdbc:mysql://localhost/universitas";
            String user = "root";
            String pasword = "kendo";

            DriverManager.registerDriver (new com.mysql.jdbc.Driver());
            koneksi = DriverManager.getConnection (url, user, pasword);
        } catch (SQLException t) {
            System.out.println ("Eror Java Database Connection");
        }

    }
    return koneksi;
}

What error? What error message? This information is kind of somewhat sort of important. — Hovercraft Full Of Eels, May 27 '18 at 02:51
Mysql generally run on port 3306, did you forgot to mention port number in url? — Mesar ali, May 27 '18 at 02:54
example when run, Eror Java Database Connection Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException at program.universitas.Form.loadData(Form.java:39) at program.universitas.Form.(Form.java:31) — Atenk941, May 27 '18 at 02:54
OK, so what are lines 39 and 31 in the Form class? Please ask a more complete question, one that doesn't require that we continue to extract information out of you. Please go through the [help] and the [ask]. — Hovercraft Full Of Eels, May 27 '18 at 03:02
Did `Eror Java Database Connection` print? If so, log the actual exception using `t.printStackTrace();` — Vasan, May 27 '18 at 03:02
These are lines in the Form class, a class you're not posting. — Hovercraft Full Of Eels, May 27 '18 at 03:03
@crack_iT port number already tried but still wrong, I am still confused how to input url. — Atenk941, May 27 '18 at 03:04

score 0 · Answer 1 · answered May 27 '18 at 02:50

0

Have you added the mysql-connector.jar file into your Library? It's an external resource not included with the default java package.

answered May 27 '18 at 02:50

Scott

279
3
14

mysql-connector.jar file has been added to the library, but when in run error occurs. Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException – Atenk941 May 27 '18 at 02:57

Java, SQL Database Connection eror

1 Answers1