jdbc connection with mysql on unix

[minal silimkar]

I want to connect jdbc with mysql on unix.
How will I do that?

[David O'Meara]

Do you have a specific issue that we can help with?

[minal silimkar]

I installed MySql with RedHat installation.
I want to check database connectivity with MySql.

I tried following code for database connectivity

    
 
String userName = "root";
String password = "admin";
String url = "jdbc:mysql://localhost:3306/test";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
Connection conn = DriverManager.getConnection (url,userName ,password );
 

it is giving error as below

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver not found in [file:/usr/share/java/libgcj-3.4.2.jar, file:./, core:/]
at java.net.URLClassLoader.findClass(java.lang.String) (/usr/lib/libgcj.so.5.0.0)
at gnu.gcj.runtime.VMClassLoader.findClass(java.lang.String) (/usr/lib/libgcj.so.5.0.0)
at java.lang.ClassLoader.loadClass(java.lang.String, boolean) (/usr/lib/libgcj.so.5.0.0)
at _Jv_FindClass(_Jv_Utf8Const, java.lang.ClassLoader) (/usr/lib/libgcj.so.5.0.0)
at java.lang.Class.forName(java.lang.String, boolean, java.lang.ClassLoader) (/usr/lib/libgcj.so.5.0.0)
at java.lang.Class.forName(java.lang.String) (/usr/lib/libgcj.so.5.0.0)
at JdbcConnection.main(java.lang.String[]) (Unknown Source)

[Jeanne Boyarsky]

Minal,
Can you show the classpath where you set it to include mysql?