MySql e JDBC com J2SE?

1 resposta
E

Ola estou com problema em usar o jdbc para conectar o BD MySQL !!! Espero que alguem possa me ajudar !!

package files;

import java.sql.*;

public class CreateCoffees {
    public static void main(String args[]) {
    	String url = "jdbc:mysql://127.0.0.1/test?user="+"xxx"; 
        Connection con;
        String createString;
        createString = "create table COFFEES " +
                            "(COF_NAME VARCHAR(32), " +
                            "SUP_ID INTEGER, " +
                            "PRICE FLOAT, " +
                            "SALES INTEGER, " +
                            "TOTAL INTEGER)";
        Statement stmt;

        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch(java.lang.ClassNotFoundException e) {
            System.err.print("ClassNotFoundException: ");
            System.err.println(e.getMessage());
        }
        catch(Exception e) {
        	
        }

        try {
            con = DriverManager.getConnection(url);
            stmt = con.createStatement();
            stmt.executeUpdate(createString);
            stmt.close();
            con.close();

        } catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }
    }
}

e esta dando o seguinte erro:

SQLException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:283)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2541)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:264)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:193)
	at files.CreateCoffees.main(CreateCoffees.java:29)


** END NESTED EXCEPTION **



Last packet sent to the server was 60 ms ago.

desde já espero que alguem possa me ajudar e agradeço !!!

1 Resposta

E

Reinstalei o MySQL apartir das fontes e ai funcionou blz, sem mais dor de cabeça !!!

Criado 12 de agosto de 2005
Ultima resposta 13 de ago. de 2005
Respostas 1
Participantes 1