how to connect mysql database to desktop java application using jdbc?

Question

how to connect mysql database to desktop java application using jdbc ? the environment is ubuntu 12.04 Lts i tried so many ways but all of them throw an exception on executing

 Class.forName("com.mysql.jdbc.Driver");

the exception say :

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

the full code is :

import java.sql.*;

public class CRUDForGoods {
    private Connection connection ;
    public Vector<GoodsStore> goods ;

    public CRUDForGoods(){
        try{
           DriverManager.registerDriver(new JdbcOdbcDriver());
            connection = DriverManager.getConnection("jdbc:odbc:dbName","root", "root");



        }
           catch(Exception ex) {
            System.out.println("##connection");
            ex.printStackTrace();
        }
    }

My goodness why are you using reflection?

jsj
– jsj

2012-09-08 14:08:10 +00:00
Commented Sep 8, 2012 at 14:08 — jsj
– jsj, Commented Sep 8, 2012 at 14:08
Is mysql-connector.jar on your classpath?

Reimeus
– Reimeus

2012-09-08 14:08:30 +00:00
Commented Sep 8, 2012 at 14:08 — Reimeus
– Reimeus, Commented Sep 8, 2012 at 14:08

Vikdor · Accepted Answer · 2012-09-08 14:15:45Z

1

com.mysql.jdbc.Driver not found while executing the code.

You need mysql connector to get it run (the jar includes com.mysql.jdbc.Driver). You can find it here

Download and include the jar file in your classpath.

edited Sep 8, 2012 at 14:15

Vikdor

24.2k10 gold badges66 silver badges86 bronze badges

answered Sep 8, 2012 at 14:15

Satish Pandey

1,1844 gold badges12 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

how to connect mysql database to desktop java application using jdbc?

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