how can i connect java with mysql



whenever i connect really i am suffer for this problem
"java.lang.classNotFound Exception:org.gjt.mm.mysql.Driver


please any body help me

Try adding the mySql connector jar file [mysql driver] to your class path and then try connecting to the mysql db.

- Rakesh

  thanks rakesh
 i already try what you say

i create classpath and denoting mysql jar even it display same error.
my class path as follows



class path="c://programfiles/jdk../lib/mysql.jar";

Is any mistake has myclass path ?

        Rakesh i really forget one matter,

i denote both mysql.jar and mysqlconnector.jar
[u]class path</u>

class path="c://progarm files/jdk.../lib/mysql.jar";c://progarm files/jdk.../lib/mysqlconnector.jar"

MySql Connector is enough.
"classpath" variable name should not have space in it. its a single word. try like
set classpath=%classpath%;c:/program files/jdk.../lib/mysqlconnector.jar;

another thing is because of the space in "program files" the path wont be considered as a valid one in few operating systems like 2003 server and i dought 2000 server also. try placing the connector jar file in an direct folder like c:\mysql\mysqlconnector.jar

Third option you've is place the mysqlconnector.jar file in your JAVA_HOME/JRE/ext/lib directory.

Hope that solves your problem.

- Rakesh