wood burning stoves 2.0*
The moose likes JDBC and the fly likes MySQL connection Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySQL connection Problem" Watch "MySQL connection Problem" New topic
Author

MySQL connection Problem

Anshul Mathur
Greenhorn

Joined: Nov 07, 2003
Posts: 22
hi
I am trying to connect to Mysql Database using the folling code.But not able to do it Database name is StudentPerformance.Please Guide Me where and what is the problem in this code
thanks
ANSHUL

*****************CODE***************

import java.sql.*;
public class SQLFirst
{
public static void main(String agrs[])
{
Statement stmt1;
ResultSet rs1;
DatabaseMetaData dbms1;
try
{
Class.forName("com.mysql.jdbc.Driver");

}
catch (Exception e)
{
System.out.println("Error" + e);
}
try
{
Connection conn1 = DriverManager.getConnection("jdbc:mysql:StudentPerformance");
stmt1 = conn1.createStatement();
rs1 = stmt1.executeQuery("Select * from patients");
dbms1 = conn1.getMetaData();
System.out.println("DATABASE NAME" + dbms1.getDatabaseProductName());
}catch(Exception e)
{
System.out.println("Error" + e);
}
}

}
Greg T Robertson
Ranch Hand

Joined: Nov 18, 2003
Posts: 91
You will need to provide the actual error you are getting to help diagnose
Things to look for
1) Be sure that the mysql driver is in your classpath.
2) Be sure that the URL you are using to connect is valid
3) Be sure that you can connect to the DB and run the SQL query without Java.
Without seeing the error you are getting it's hard to give any other advice
Craig Jackson
Ranch Hand

Joined: Mar 19, 2002
Posts: 405
Also, not to sound funny, please be sure the server is running.
One more thing, after you have successfully compiled your code, mySQL listens to port 3306 by default.
For example your connection string should be similar to:
"jdbc:mysql://localhost:3306/StudentPerformance"
I hope this helps.
Craig.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: MySQL connection Problem
 
Similar Threads
Transactions
program to make start-connect by (oracle )
NULL POINTER eXCEPTION
Auto Commit option fails to work
how to pause and resume the thread.