Bom galera…
Não estou conseguindo me conectar ao MySQL.
Baixei o driver Connector/J.
Aqui está meu código:
[code]import java.sql.*;
public class Principal {
Connection connection;
Statement statement;
public Principal() {
super();
try {
String user = "root@localhost";
String password = "xxxxxx";
String url = "jdbc:mysql://127.0.0.1/test/user="+user+"&password=xxxxxx";
Class.forName("com.mysql.jdbc.Driver");//.newInstance();
connection = DriverManager.getConnection(url);
System.out.println(connection.isClosed());
}
catch(ClassNotFoundException ex) {
ex.printStackTrace();
}
catch(SQLException ex) {
ex.printStackTrace();
}
catch(Exception ex) {
ex.printStackTrace();
}
}
public static void main(String[] args) {
new Principal();
}
}[/code]
E a excessão que o código está lançando é está:
[code]java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.SocketException: java.net.ConnectException: Connection refused: connect
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:143)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:225)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1805)
at com.mysql.jdbc.Connection.<init>(Connection.java:452)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Principal.<init>(Principal.java:18)
at Principal.main(Principal.java:34)
** END NESTED EXCEPTION **
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1875)
at com.mysql.jdbc.Connection.<init>(Connection.java:452)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Principal.<init>(Principal.java:18)
at Principal.main(Principal.java:34)[/code]
Por favor me ajudem heheh