JDBC with Connector/J with MySQL
Hi to all...
I just want to connect to mysql database with connector/J ( JDBC)
I have downloaded "mysql-connector-java-5.1.15.zip" .... Then i extracted the file from this folder to---->
"C:\Program Files\Java\jdk1.6.0_13\jre\lib\ext\mysql-connector-java-5.1.15-bin.jar " and set environmental variables classpath to above url too...
I can compile the code successfully ........
But while running it gives errors.....
I have given my code and running scenario too....
Kindly help....
########################################
import java.sql.*;
import javax.sql.*;
public class jdbc
{
public static void main(String[] args)
{
System.out.println("MySQL Connect Example.");
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";
String dbName = "jdbctutorial";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "sonali";
try
{
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,userName,pa ssword);
System.out.println("Connected to the database");
conn.close();
System.out.println("Disconnected from database");
}
catch (Exception e) {e.printStackTrace();}
}
}
################################################## ##
On cmd-------->
##########################################
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>cd C:\Program Files\Java\jdk1.6.0_13\bin
C:\Program Files\Java\jdk1.6.0_13\bin>javac jdbc.java
C:\Program Files\Java\jdk1.6.0_13\bin>java jdbc
Exception in thread "main" java.lang.NoClassDefFoundError: jdbc
Caused by: java.lang.ClassNotFoundException: jdbc
at java.net.URLClassLoader$1.run(URLClassLoader.java: 200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 07)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 52)
at java.lang.ClassLoader.loadClassInternal(ClassLoade r.java:320)
Could not find the main class: jdbc. Program will exit.
C:\Program Files\Java\jdk1.6.0_13\bin>
############################################
