jdbc connection

Hi,
I am having a simple java program which connects with the mysql database in the path c:\>j2sdk1.4.2_16/bin.when i compile this it compiles well.
I am having my sql.jar file (ie)mysql-connector-java-3.0.17-ga folder which consist of meta-inf and mysql-connector-java-3.0.17-ga-bin.jar in the path c:\>j2sdk1.4.2_16/lib.when i compiled and run my program like this

c:\>j2sdk1.4.2_16/bin/javac Connect.java
c:\>java -classpath .:j2sdk1.4.2_16/lib/mysql-connector-java-3.0.17-ga/lib/mysql-connector-java-3.0.17-ga-bin.jar Connect

It displays the error:

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

my program is:

import java.sql.*;
import java.io.*;
import java.util.*;
import java.awt.event.*;
import java.sql.ResultSet;
   public class Connect1
   {
       public static void main (String[] args)
       {
           
 String createString;
        createString = "create table Credit cards " +
                            "(cardid int not null PRIMARY Key, " +
                            "name varchar(50), " +
                            "type varchar(20))";
Statement st;
        Connection conn = null;
           try
           {
               String userName = "dialer";
               String password = "1234";
               String url = "jdbc:mysql://192.168.1.5:3306/test";
               Class.forName ("com.mysql.jdbc.Driver").newInstance ();
               conn = DriverManager.getConnection (url, userName, password);
st = conn.createStatement();
st.executeUpdate(createString);
 
               System.out.println ("Database connection established");
           }
           catch (Exception e)
           {
               e.printStackTrace();
           }
           finally
           {
               if (conn != null)
               {
                   try
                   {
                       conn.close ();
                       System.out.println ("Database connection terminated");
                   }
                   catch (Exception e) { /* ignore close errors */ }
               }
           }
       }
   }

.

Thanks.

public class Connect1

There's your problem - the source file does not contain a class called Connect.

sorry by mistake i have posted like that.I had given the name correctly.but i am getting error like the same

The name of the class you are trying to run using the java command and the
is different from the name of your class.

The name of the class should be the same.

thats what i mentioned in the last post.by mistake i have posted wrongly.I have given the class name Connect in the program.

Thanks.

please anyone guide me to do this

You're using a colon to separate the classpath entries. But on Windows, a semicolon is the correct separator.

c:\>java -classpath .;j2sdk1.4.2_16/lib/mysql-connector-java-3.0.17-ga/lib/mysql-connector-java-3.0.17-ga-bin.jar Connect

you mention java-classpath.;this semicolon...if so i've already given.....

Thank you all.I got the jdbc connection.I set the classpath in environment variables .