Java database connection issue

Question

I have the following issue with my code :

import java.sql.*;

public class App {

    public static void main(String[] args){

        String url = "jdbc:mysql://localhost:3306" ;
        try{ 
            Class.forName("com.mysql.jdbc.Driver"); 
            }
        catch(ClassNotFoundException e) 
                { System.out.println("Eroare incarcare driver!\n" + e);
                return; 
                }
        try{ 
            Connection con = DriverManager.getConnection(url);

        // Golim tabelul persoane 
                String sql = "DELETE FROM persoane"; 
                Statement stmt = con.createStatement(); 
                stmt.executeUpdate(sql);
                stmt.execute("CREATE DATABASE IF NOT EXISTS test");
                stmt.execute("USE test");

i get the exception...any idea how i can make this work? thx.

enter code here

it`s the exception. Eroare incarcare driver! java.lang.ClassNotFoundException: com.mysql.jdbc.Driver — George Marin
– George Marin, Commented Mar 16, 2015 at 12:57

Promination · Accepted Answer · 2015-03-16 13:00:33Z

2

You need to download and add the jdbc connector to your classpath.

http://dev.mysql.com/downloads/connector/j/

answered Mar 16, 2015 at 13:00

Promination

1566 bronze badges

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

Comments

Sarz · Accepted Answer · 2015-03-16 13:23:44Z

1

java.lang.ClassNotFoundException occured due to "class not found" in your project/war/ear. Exception is very self explanatory, How to solve it. In your case:

Add com.mysql.jdbc.Driver driver class/jar in your build/deployment/lib path you can download it HERE

Read here Offical

edited Mar 16, 2015 at 13:23

answered Mar 16, 2015 at 13:17

Sarz

1,9764 gold badges23 silver badges44 bronze badges

Comments

jesse · Accepted Answer · 2015-03-16 13:02:38Z

1

Make sure you have the MySQL driver on your application classpath.

answered Mar 16, 2015 at 13:02

jesse

281 silver badge6 bronze badges

Comments

Benjamin · Accepted Answer · 2015-03-16 13:11:46Z

1

Change

   Connection con = DriverManager.getConnection(url);

to

 Connection con = DriverManager.getConnection(url,"username","password");

and replace it with yourusername and password

edited Mar 16, 2015 at 13:11

Benjamin

2,3061 gold badge17 silver badges24 bronze badges

answered Mar 16, 2015 at 12:58

Raju Guduri

1,3072 gold badges13 silver badges26 bronze badges

Collectives™ on Stack Overflow

Java database connection issue

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related