Skip to Main Content

New to Java

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot connect to database server:Cannot connect to database server

801498Feb 6 2009 — edited Feb 7 2009
I 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...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2009
Added on Feb 6 2009
9 comments
520 views