connect MYSQL with netbeans 7.4

Question

Iam new on using NetBeans 7.4 , i want to connect my java application to MYSQL , the application is desktop application . i have already install MYSQL workbench 5.2 and create database with one table . from NetBeans services on Databases i register MYSQL server , i enter these values : localhost : 127.0.0.1 , user : root and password : root.

from NetBeans

NetBeans ask me to set MYSQL command Path (Path to start command) i insert this path : C:\Program Files\MySQL\Connector ODBC 5.1\myodbc-installer.exe

from main class in java i saw from net how to set connection :

 Connection conn = null;
    try {
   conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/sameer", "root","root");
  System.out.println("Connected database successfully...");
    } catch (Exception e) {
        System.out.println(e);
    }

but all time the exception will execute :

java.sql.SQLException: No suitable driver found for jdbc:mysql://127.0.0.1:3306/sameer

elbuild · Accepted Answer · 2014-01-30 21:16:23Z

4

You need to include the mysql connector jar in your project.

If you haven't downloaded it yet you can find it here http://dev.mysql.com/downloads/connector/j/

Once you have downloaded it:

right click on the project
select Properties
select Libraries -> Add JAR/Folder
navigate your file system to select the jar you previously downloaded
save and it will run correctly

answered Jan 30, 2014 at 21:16

elbuild

4,8894 gold badges26 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

connect MYSQL with netbeans 7.4

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related