connect to remote mysql server

[cucucur]

hi! I'm trying to connect to a remote mysql server what I do is:

 public static Connection connectDB(){

    	Connection conn = null;
    	try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
    	    conn = DriverManager.getConnection("jdbc:mysql://ip:3306/spb", "user", "pass");
    	        	    
        } catch (Exception e){
        	System.out.println(e.toString());
        } 
        return conn;
    }

I got this exception,

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.ConnectException
MESSAGE: Connection timed out: connect

STACKTRACE:

java.net.ConnectException: Connection timed out: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(Unknown Source)
	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at mysqlRemoto.connectDB(mysqlRemoto.java:20)
	at mysqlRemoto.main(mysqlRemoto.java:44)


** END NESTED EXCEPTION **



Last packet sent to the server was 1 ms ago.

Do I have to do something in my server? Thanks!!!

[masijade]

That sounds like either a firewall dropping packets (either on the way to the db server or on the way back) or bad routing that essentially sends the packet in circles.