Cannot connect to database server:Cannot connect to database server
801498Feb 6 2009 — edited Feb 7 2009I know all must be tired of this question, bit I am near crying stage....
Please help me I just want to get passed this connection error....
This is my code again. I went back and started all over again:
mport java.sql.Connection;
import java.sql.DriverManager;
public class ConnectTest
{
public static void main (String[] args)
{
Connection conn = null;
try
{
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection("jdbc:mysql://localhost/sampdb", "sampadm","secret");
System.out.println ("Database connection established");
}
catch (Exception e)
{
System.err.println ("Cannot connect to database server");
System.err.println("Exception: " + e.getMessage());
}
finally
{
if (conn != null)
{
try
{
conn.close ();
System.out.println ("Database connection terminated");
}
catch (Exception e) { /* ignore close errors */ }
}
}
}
}
And again getting this error:
Cannot connect to database server
Exception: com.mysql.jdbc.Driver
I have setup my PATH as: %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;c:\Program Files\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\Java\jdk1.6.0_11\bin;C:\Program Files\MySQL\MySQL Server 5.1\bin;C:\JAVA DOCUMENTATION\BasicJava1\Code;C:\Program Files\Mysql Connector J\mysql-connector-java-5.1.7\mysql-connector-java-5.1.7-bin.jar
My CLASSPATH as: C:\Program Files\Mysql Connector J\mysql-connector-java-5.1.7\;C:\Program Files\Mysql Connector J\mysql-connector-java-5.1.7-bin
Eish man something must give now !!!!!
Thank...