connecting java to Mysql using Mysql-connector/j

Question

I use netbeans 6.9 IDE and its features to connect my java class to Mysql database. as you know, Mysql-connector driver is embedded in netbeans. I make new connection to Mysql database using Mysql(connector/j) driver, and every thing is okay, it displays all databases in Mysql and all tables in these databases, but when I create my java class to test the connetion and start manipulation, ClassNotFoundException is thrown when I call Class.forName("com.mysql.jdbc.Driver").newInstance(); ie. there is no driver ? why i got that exception ? the same happened when I connect to derby embedded db? can you help? here my test class

public static void main(String[] args) {
        Connection con = null;
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            System.out.println("driver true");
            con = DriverManager.getConnection("jdbc:mysql:///test",
                    "root", "123456");
            if (!con.isClosed()) {
                System.out.println("Successfully connected to "
                        + "MySQL server using TCP/IP...");
            }
        } catch (Exception e) {
            e.printStackTrace();
            System.err.println("Exception: " + e.getMessage());
        } finally {
            try {
                if (con != null) {
                    con.close();
                }
            } catch (SQLException e) {
            }
        }
    }

Marlon Abeykoon · Accepted Answer · 2014-04-05 11:43:33Z

4

You have to add the mysql connector .jar file (Libraries + Add Library + Mysql JDBC Driver) to your project.

edited Apr 5, 2014 at 11:43

Marlon Abeykoon

12.6k4 gold badges60 silver badges78 bronze badges

answered Oct 20, 2011 at 10:49

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

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

Comments

ismylhakki · Accepted Answer · 2011-12-28 23:26:57Z

1

On the left side Right-Click "libraries"->"Add Library..."-Select->"MySQL JDBC Driver" then rebuild the project.

answered Dec 28, 2011 at 23:26

ismylhakki

112 bronze badges

Comments

Samrat · Accepted Answer · 2011-10-20 10:50:20Z

0

The answer is with your question. Driver is with your netbeans IDE and not with your java project. Add the required dirver (Jar file) to the project and run.

answered Oct 20, 2011 at 10:50

Samrat

3672 gold badges4 silver badges21 bronze badges

Collectives™ on Stack Overflow

connecting java to Mysql using Mysql-connector/j

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related