Using mysql in Java on ubuntu

[dearvivekkumar]

Hi,

I am new to Java programming language. I am studying from these from Java server programming from Black book.

I am not getting this example basically the first part for registering the driver object with DriverManager class.

package com.kogent.jdbc;

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

public class CallableStatementEx1 {
	private static final String url = "jdbc:mysql://localhost";
	private static final String user = "root";
	private static final String password = "v";
	
	public static void main(String[] args) throws Exception {
		Class.forName("com.mysql.jdbc.Driver").newInstance();
		Connection con = DriverManager.getConnection(url, user, password);
		
		// Get CallableStatement
		CallableStatement cs = con.prepareCall("{call createAccount (?, ?, ?, ?, ?, ?,)}");
		
		// Set IN parameters
		cs.setInt(1, 103);
		cs.setInt(2, 9);
		cs.setString(3, "Vivek");
		cs.setInt(4, 10000);
		cs.setString(5, "Delhi");
		cs.setInt(6, 965068);
		
		// Executing stored procedure
		cs.execute();
		System.out.println("Account created");
		
		// Close the connection
		con.close();
	}
}

when running this program. I am getting the below exceptions.

Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:186)
	at com.kogent.jdbc.CallableStatementEx1.main(CallableStatementEx1.java:13)

If have problem in understanding below lines of the program.
url = "jdbc:mysql://localhost";
Class.forName("com.mysql.jdbc.Driver").newInstance ();
Any suggestion will be greatly helpful.

Thanks!

[eRaaaa]

You have to add the mysql driver (jdbc driver) to your build path / classpath :-)
MySQL :: Download Connector/J

[dearvivekkumar]

I have already added in the CLASSPATH env variable.

[Tolls]

Never use the environment variable to hold your Java classpath.
Use the -cp switch of either java (in this case) or javac to define the classpath, or define it in whatever IDE you are using.

How are you running this?