quando tento inserir, estou com o seguinte erro:
Exception in thread "main" java.sql.SQLException: Unknown initial character set index '48' received from server. Initial client character set can be forced via the 'characterEncoding' property.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2345)
at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3913)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2683)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at br.com.david.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:11)
at br.com.david.dao.TesteDAO.<init>(TesteDAO.java:14)
at br.com.david.teste.TestaInsere.main(TestaInsere.java:14)
TesteDAO.java
package br.com.david.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import br.com.david.bean.Teste;
import br.com.david.jdbc.ConnectionFactory;
public class TesteDAO {
private Connection con;
public TesteDAO() throws SQLException {
this.con = ConnectionFactory.getConnection();
}
public void adiciona(Teste teste) throws SQLException {
PreparedStatement stmt = this.con.prepareStatement("insert into teste (nome) values (?)");
stmt.setString(1, teste.getNome());
stmt.execute();
stmt.close();
con.close();
}
}
ConnectionFactory.java
package br.com.david.jdbc;
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");
return DriverManager.getConnection("jdbc:mysql://localhost/teste", "root", "" );
} catch(ClassNotFoundException e) {
throw new SQLException(e.getMessage());
}
}
}
TesteInsere.java
package br.com.david.teste;
import java.sql.SQLException;
import br.com.david.bean.Teste;
import br.com.david.dao.TesteDAO;
public class TestaInsere {
public static void main(String[] args) throws SQLException {
Teste teste = new Teste();
teste.setNome("david");
TesteDAO dao = new TesteDAO();
dao.adiciona(teste);
}
}