Olá galera, estou iniciando meus estudos com java, mais estou esbarrando nesse infeliz problema. Estou tentando realizar a conexão com banco de dados MySQL mais toda vez eu recebo o erro de Connection Refused.
Aqui está o programa que eu fiz:
import java.sql.*;
import org.gjt.mm.mysql.Driver;
public class bancoTeste1 {
private static final String STR_DRIVER = "com.mysql.jdbc.Driver";
private static final String DATABASE = "myBase";
private static final String IP = "localhost";
private static final String STR_CON = "jdbc:mysql://" + IP + ":3306/" + DATABASE;
private static final String USER = "root";
private static final String PASSWORD = "abc123";
public static void main(String[] args){
Connection con = null;
try {
Class.forName(STR_DRIVER);
con = DriverManager.getConnection(STR_CON, USER, PASSWORD);
System.out.println("CONECTANDO");
} catch (ClassNotFoundException e) {
System.out.println("CLASS ERROR");
} catch (SQLException e) {
System.out.println("SQL ERROR"+e);
}
}
Detalhes do meu sistema:
Slackware 12.1
MySQL 5.0.51b
JDK 1.6.0
Driver MySQL:mysql-connector-java-5.0.8-bin.jar
Eclipse 3.3.1.1.
Consigo manipular o banco de dados normalmente pelo phpMyAdmin e pelo console.
Não consigo de jeito nenhum conectar no banco de dados com o java. Ja tentei varios IPs (127.0.0.1,localhost,192.168.0.102 (meu ip de rede)), o login e a senha estão corretos, ja tentei com varios usuarios (root e outros), tambem ja tentei com a porta 3306 e sem passar porta nenhuma. Não sei mais o que fazer.
Esse é o erro que recebo:SQL ERRORcom.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.ConnectException
MESSAGE: Connection refused
STACKTRACE:
java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at SMD.bancoTeste1.main(bancoTeste1.java:21)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.