Estou estudando a apostila da caelum fj-21 e meu banco de dados não quer conectar.
Minha classe de conexão é:
package br.com.caelum.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectionFactory {
public Connection getConnection(){
System.out.println("Conectado ao Banco");
try {
return DriverManager.getConnection("jdbc:mysql://localhost:3306/fj21","root","admin");
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
minha classe de teste é:
package br.com.caelum.jdbc.teste;
import java.sql.Connection;
import java.sql.SQLException;
import br.com.caelum.jdbc.ConnectionFactory;
public class TestaConexao {
public static void main(String[] args) throws SQLException {
Connection connection = new ConnectionFactory().getConnection();
System.out.println("Conectado");
connection.close();
}
}
E o erro que esta dando é:
Conectado ao Banco
Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/fj21
at br.com.caelum.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:15)
at br.com.caelum.jdbc.teste.TestaConexao.main(TestaConexao.java:11)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/fj21
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at br.com.caelum.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:12)
... 1 more
para entrar no administrador do MySQL tenho que colocar root e admin, já criei o banco fj21 e a tabela Contato, mas o erro continua.
Se alguém puder ajudar agradeço.
