oi pessoal continuo com problemas para conectar a minha base(mysql)
depois de ter criado as seguintes classes:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectionFactory {
public static Connection getConnection() throws SQLException {
try {
Class.forName(“com.mysql.jdbc.Driver”);
System.out.println(“Conectando ao banco”);
return DriverManager.getConnection(“jdbc:mysql://root@stelio-desktop/escola”,“root”,“stelioklesio”); //desconfio desde ponto
} catch (ClassNotFoundException e) {
throw new SQLException(e.getMessage());
}
}
}
sua emplementacao:
import java.sql.Connection;
import java.sql.SQLException;
public class Testa {
public static void main (String[] args) throws SQLException {
Connection connection = ConnectionFactory.getConnection();
connection.close();
}
}
surge o seguinte na consola do eclipse:
Conectando ao banco
Exception in thread “main” com.mysql.jdbc.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:723)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(libgcj.so.81)
at java.sql.DriverManager.getConnection(libgcj.so.81)
at ConnectionFactory.getConnection(ConnectionFactory.java:12)
at Testa.main(Testa.java:7)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:335)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)
…7 more
Caused by: java.net.UnknownHostException: root@stelio-desktop
at java.net.ResolverCache.getHostByName(libgcj.so.81)
at java.net.InetAddress.getAllByName(libgcj.so.81)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:243)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)
…8 more
agora qual deverá ser o problema??? por favor ajudem me!!