Jdbc Connection using MySql DataBase

I had written the program JDBCConnection. i.e.,

Code:

---

import java.sql.*;

  public class Connect
  {
      public static void main (String[] args)
      {
          Connection conn = null;

          try
          {
              String userName = "Root";
              String password = "admin";
              String url = "jdbc:mysql://localhost:3306/test";
              Class.forName ("com.mysql.jdbc.Driver").newInstance ();
              conn = DriverManager.getConnection (url,userName ,password );
              System.out.println ("Database connection established");
          }
          catch (Exception e)
          {
              System.err.println ("Cannot connect to database server");
          }
      }
  }

---

Here admin is mysql password.

I had copied the mysql-connector-java-5.0.8-bin.jar file in the location of C:\Program Files\Java\jdk1.5.0\jre\lib folder and set the class path as same path.

When i had compile the program it has compile successfully. But when i was runeed it has displayed an error message.
i.e.,

Exception in thread "main" java.lang.NoClassDefFoundError: Connect

Please tell me what is the mistake any one knows.

Split from this resolved thread into its own thread.

rajeshlab,

your compiler "javac" could see the classpath to the jar file.
make sure your executable "java" can also see it.
"javac" & "java" are two different programs, and they each require parameters.

this is necessary especially in editors & IDEs that attempt to execute and compile. the parameter is required separately because the executable is different.

hope this helps
:)