Conexão ao MySQL

1 resposta
Guilherme_Moreira

Eu tenho o seguinte código:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class teste {

	public static void main(String[] args) {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("Teste");
			Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1/teste","root","");
			System.out.println("Conectado!");
			con.close();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		
	}

}

e ele me retorna o seguinte erro

Teste
java.sql.SQLException: Error during query: Unexpected Exception: java.io.CharConversionException message given: null

Nested Stack Trace:


** BEGIN NESTED EXCEPTION ** 

java.io.CharConversionException

STACKTRACE:

java.io.CharConversionException
   at gnu.gcj.convert.Input_iconv.read(char[], int, int) (/usr/lib/libgcj.so.6.0.0)
   at java.lang.String.init(byte[], int, int, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
   at java.lang.String.String(byte[], int, int, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
   at com.mysql.jdbc.SingleByteCharsetConverter.SingleByteCharsetConverter(java.lang.String) (Unknown Source)
   at com.mysql.jdbc.SingleByteCharsetConverter.initCharset(java.lang.String) (Unknown Source)
   at com.mysql.jdbc.SingleByteCharsetConverter.getInstance(java.lang.String, com.mysql.jdbc.Connection) (Unknown Source)
   at com.mysql.jdbc.StringUtils.getBytes(java.lang.String, java.lang.String, java.lang.String, boolean) (Unknown Source)
   at com.mysql.jdbc.ByteArrayBuffer.writeStringNoNull(java.lang.String, java.lang.String, java.lang.String, boolean) (Unknown Source)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(com.mysql.jdbc.Statement, java.lang.String, java.lang.String, com.mysql.jdbc.Buffer, int, com.mysql.jdbc.Connection, int, int, boolean, java.lang.String, boolean) (Unknown Source)
   at com.mysql.jdbc.Connection.execSQL(com.mysql.jdbc.Statement, java.lang.String, int, com.mysql.jdbc.Buffer, int, int, boolean, boolean, java.lang.String, boolean, byte, boolean) (Unknown Source)
   at com.mysql.jdbc.Connection.configureClientCharacterSet() (Unknown Source)
   at com.mysql.jdbc.Connection.initializePropsFromServer(java.util.Properties) (Unknown Source)
   at com.mysql.jdbc.Connection.createNewIO(boolean) (Unknown Source)
   at com.mysql.jdbc.Connection.Connection(java.lang.String, int, java.util.Properties, java.lang.String, java.lang.String, com.mysql.jdbc.NonRegisteringDriver) (Unknown Source)
   at com.mysql.jdbc.NonRegisteringDriver.connect(java.lang.String, java.util.Properties) (Unknown Source)
   at java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties) (/usr/lib/libgcj.so.6.0.0)
   at java.sql.DriverManager.getConnection(java.lang.String, java.lang.String, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
   at teste.main(java.lang.String[]) (Unknown Source)
   at gnu.java.lang.MainThread.call_main() (/usr/lib/libgcj.so.6.0.0)
   at gnu.java.lang.MainThread.run() (/usr/lib/libgcj.so.6.0.0)


** END NESTED EXCEPTION **


   at com.mysql.jdbc.Connection.execSQL(com.mysql.jdbc.Statement, java.lang.String, int, com.mysql.jdbc.Buffer, int, int, boolean, boolean, java.lang.String, boolean, byte, boolean) (Unknown Source)
   at com.mysql.jdbc.Connection.configureClientCharacterSet() (Unknown Source)
   at com.mysql.jdbc.Connection.initializePropsFromServer(java.util.Properties) (Unknown Source)
   at com.mysql.jdbc.Connection.createNewIO(boolean) (Unknown Source)
   at com.mysql.jdbc.Connection.Connection(java.lang.String, int, java.util.Properties, java.lang.String, java.lang.String, com.mysql.jdbc.NonRegisteringDriver) (Unknown Source)
   at com.mysql.jdbc.NonRegisteringDriver.connect(java.lang.String, java.util.Properties) (Unknown Source)
   at java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties) (/usr/lib/libgcj.so.6.0.0)
   at java.sql.DriverManager.getConnection(java.lang.String, java.lang.String, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
   at teste.main(java.lang.String[]) (Unknown Source)
   at gnu.java.lang.MainThread.call_main() (/usr/lib/libgcj.so.6.0.0)
   at gnu.java.lang.MainThread.run() (/usr/lib/libgcj.so.6.0.0)

eu pensei que era problema de não conectar mas não, pois se eu colocar uma senha pra acessar o banco, ele dá acesso negado

Access denied for user 'root'@'localhost'

Alguém tem alguma idéia pra ajudar?

1 Resposta

Guilherme_Moreira

Mesmo que ninguém tenha postado a resposta, eu troquei a máquina virtual para a 5.0 e rosou perfeitamente :slight_smile:

Até a próxima

Criado 15 de junho de 2006
Ultima resposta 15 de jun. de 2006
Respostas 1
Participantes 1