[SOLVED] Java's JDBC MySQL connector failing?
Posted: Fri Oct 20, 2006 5:10 am
Code: Select all
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
public class MySQLApp
{
public static void main(String[] args)
{
Statement stmt;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception e) {
System.out.println("Class Loading Failed: " + e.getMessage());
}
String url = "jdbc:mysql://127.0.0.1:3306/my_db";
System.out.println("Trying to connect with the following credentials: " + url);
Connection c;
try {
c = DriverManager.getConnection(url, "my_user", "password");
} catch (SQLException e) {
System.out.println("Failed: " + e.getMessage());
}
}
}I just keep getting connection refused even though I've opened up this particular database to anyone and any location. Everything except my java app works fine
Code: Select all
[d11wtq@pc-cac MySQLApp]$ java MySQLApp
Trying to connect with the following credentials: jdbc:mysql://127.0.0.1/my_db
Failed: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2569)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at MySQLApp.main(MySQLApp.java:26)
** END NESTED EXCEPTION **
Last packet sent to the server was 20 ms ago.
[d11wtq@pc-cac MySQLApp]$