Trace says that its unable to find MySql jdbc driver class.

Try adding the mysql jdbc driver jar file to project build path!


- Rakesh

can u plese tell me how can i add this . i want to know the procedure

can u plese tell me how can i add mysql jdbc driver jar file to project build path . i want to know the procedure
-Ruzdi

good working code, thanks...

-----------------------------------------------------------------------------------------------------------------------------------------------------------------
http://coco4info.com/comment.aspx
http://commentdirectory.com/resources.aspx

you can find information about setting classpath at the bellow given url

http://java.sun.com/j2se/1.4.2/docs/...classpath.html


- Rakesh

All you need is loading the driver class before calling DriverManger.getConnection.

put this
Class.forName("com.mysql.jdbc.Driver") and as long as you have mysql java connector jar file in your classpath, the driver should be able to connect.
Get the jar file from
http://dev.mysql.com/downloads/connector/j/5.1.html

It can't be any simpler.


They even have a quick start guide in the connector download that you can just copy paste.

Hi ...... I had also faced the


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

While connecting Java application to the mysql.
On both platform windows and linux

I m done with its solution and writing the steps i followed ... Hope it will help

1 . The java code for connectivity



import java.sql.*;

public class Jdbc11 {
public static void main(String args[]){

try {
Statement stmt;
Class.forName("com.mysql.jdbc.Driver");
String url ="jdbc:mysql://localhost:3306/mysql";
Connection con = DriverManager.getConnection(url,"root", "");
stmt = con.createStatement();
stmt.executeUpdate("CREATE DATABASE payroll1");
stmt.executeUpdate(
"GRANT SELECT,INSERT,UPDATE,DELETE," +
"CREATE,DROP " +
"ON JunkDB.* TO 'root'@'localhost' " +
"IDENTIFIED BY '';");
con.close();
}catch( Exception e ) {
e.printStackTrace();
}//end catch
}//end main
}//end class Jdbc11



This code on execution will create a database named payroll1......

2.
Mysql is installed by default on port 3306
if you will simply install the mysql and run the above code
you will get the

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

3
Here is the solution for this for windows


Simply put a file Named
" mysql-connector-java-3.0.17-ga-bin.jar "
(You can get this file easily downloadable on Internet , Search by
its name)
on the following location ... i m giving the location where i put it

" C:\Program Files\Java\jdk1.6.0_14\jre\lib\ext "



Simply paste the " mysql-connector-java-3.0.17-ga-bin.jar "
file over the above location relative to your machine....

After this execute the code it will gonna work fine....
Our editors will seek connector on the above location
but for deployed application read below....

Secondly when you will deploy your connectivity code into an
application , then u will have to save the connector
" mysql-connector-java-3.0.17-ga-bin.jar "
on the following location
i m giving the location where i put it
" C:\Program Files\Java\jre6\lib\ext "
deployed application will seek connector on this location...

it will gonna work fine after this....create stattement object and
execute as much query as you want
4
Here is the solution for Linux

simply put the connector
" mysql-connector-java-3.0.17-ga-bin.jar "

on the following location...i m giving the location where i put it
"/usr/lib/jvm/default-java/jre/lib/ext "

i need to restart the system to verify whether i wrote the right location for linux...Because i m working on windows right now...so forgive and work yourself to find the exact location ,,but trust me i think i wrote the right location....try your self....



Do Reply

import java.sql.Connection;
import java.sql.DriverManager;


/**
*
* @author mairaj
*/
public class DB {
static Connection con =null;
public static Connection getCon(){
try{
Class.forName("com.mysql.jdbc.Driver");
con =DriverManager.getConnection("jdbc:mysql:\\localho st:3306\test","root","root") ;
}
catch(Exception e){}
return con;
}

}

You can read all about JDBD on this site.

http://sunjava-expert.blogspot.com/2...onnection.html

http://sunjava-expert.blogspot.com/search/label/JDBC

Hi,ruzdi

this code will definately help you,

import="java.sql.*"


try
{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase?","root","root");
Statement st=conn.createStatement();



// your code goes here...

//close try block

conn.close();
}catch(Exception e){
System.out.println("error"+e);
}


//3306 is default portnumber of mysql

//mydatabase is databasename in mysql

//root is username

//root is password

It will work 100%

Try it..


All the best..