Olá,
Peguei a apostila da Caelum e estou estudando J2EE. Criei essas suas classes:package br.com.caelum.jdbc;
import java.sql.*;
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://localhost/teste", "root", "root");
} catch (ClassNotFoundException e) {
throw new SQLException(e.getMessage());
}
}
}
package br.com.caelum.jdbc.teste;
import java.sql.*;
import br.com.caelum.jdbc.*;
public class TestaConexao {
public static void main(String[] args) throws SQLException, ClassNotFoundException {
Connection con = ConnectionFactory.getConnection();
con.close();
}
}
Conectando ao banco
Exception in thread "main" com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1768)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3444)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2062)
at com.mysql.jdbc.ConnectionImpl.<init>(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.90)
at java.sql.DriverManager.getConnection(libgcj.so.90)
at br.com.caelum.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:8)
at br.com.caelum.jdbc.teste.TestaConexao.main(TestaConexao.java:7)
Alguém poderia me dar alguma luz?
Abraços,
Hélio
