MySQL DataBase

[Rajesh Rami Reddy]

Hello friends,
I had wrote a programe for establish a connection MySql database using JDBC. My Programming code is

import java.io.*;
import java.sql.*;
public class JdbcConnection {
  public static void main (String[] args)
{
  System.out.println("Copyright 2004, R.G.Baldwin");
     try{
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 );
System.out.println ("Database connection established");
   }catch (Exception e)
  {
   e.printStackTrace();
    System.err.println ("Cannot connect to database server");
  }
     }
}

When i was run this programme it is displaying as


Copyright 2004, R.G.Baldwin
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at JdbcConnection.main(JdbcConnection.java:11)
Cannot connect to database server

I am setting the CLASS PATH is "C:\Program Files\Java\jdk1.5.0\jre\lib\MYSQL.jar;C:\Program Files\Java\jdk1.5.0\jre\lib\mysql-connector-java-5.0.8-bin.jar;"

Could you know where i did a mistake. Please tell me.
[ March 04, 2008: Message edited by: Ulf Dittmer ]

[Ulf Dittmer]

Dows it work if you add the jar file on the command line, like

java -classpath ".;C:\Program Files\Java\jdk1.5.0\jre\lib\mysql-connector-java-5.0.8-bin.jar" JdbcConnection

[ March 04, 2008: Message edited by: Ulf Dittmer ]

[Rajesh Rami Reddy]

Thank you Sir.
Now Jdbc Connection is established and perform the Transactions only sample programs.
I am also setting the classpath as you suggested previously in the Environment Variables.
What is the difference bitween setting the class path as command prompt and environment variables in Mycomputer properties in windows mode.

i had never expect raise this type of problams.

Once again Thank you very much.

could you know how to establish a connection pool in tomcat server using hibernate and spring frameworks. The database is Sql Server 2000.

[Ulf Dittmer]

could you know how to establish a connection pool in tomcat server using hibernate and spring frameworks.

Hibernate can do that using the C3PO pool implementation. Shouldn't take more than the appropriate entries in the hibernate.properties file. See this for further information.
[ March 05, 2008: Message edited by: Ulf Dittmer ]