creating .jar with jdbc driver?

[Godsent]

Ok, i made swing GUI that works just fine and connects to SQL, and then i made it into .jar using this line:

"C:\Program Files\Java\jdk1.6.0_06\bin\jar.exe" cfm MyJar.jar Manifest.txt blist/

So all files that is in blist folder will be in jar file, and they are. Everything seems to work, except connecting to SQL.

Connecting looks like this:

	public void createConnection() {
		try {
			setParameters(0, "step 1...");
			String serverName = "127.0.0.1";
			String mydatabase = "blist"; 
			String url = "jdbc:mysql://" + serverName + "/" + mydatabase;
			setParameters(40, "step 2...");
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			setParameters(60, "step 3...");
			con = DriverManager.getConnection(url, "root", "");
			stmt = con.createStatement();
			setParameters(80, "step 4...");
			connected = true;
			setParameters(100, "step 5!");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

I use setParameters void to set custom text for jLabel to find out where my application stops. And its step 2.

So the problem must be with

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

Maybe i put it in .jar wrong, maybe i need specific line if using these jdbc?
Please help

[markw8500]

It sounds like your app can not find your driver... I compile all of my apps with netBeans and netBeans automatically creates a directory called "lib" and puts my driver in it... So you might want to try something like that...

[OrangeDog]

either copy the files from the driver's jar into yours, or add it to the classpath when you run the application