Ayyyyy, bueno, pues no, sigue sin funcionarme...
- Tengo la IP estática interna (he puesto 192.168.1.35 finalmente)
- Tengo el dns vXXX.no-ip.info
- He configurado la Nat para que me deje pasar lo que vaya al puerto 3307.
Y cuando intento conectar con la base de datos (desde este mismo ordenador) de la siguiente forma:
String url = "jdbc:mysql://vXXX.no-ip.info:3307/mex_bd";
[...]
try{
mi_conexion = DriverManager.getConnection(url, login, pass);
[...]
Me da un error kilométrico que casi me sabe mal escribir y todo:
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(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:516)
at java.net.Socket.connect(Socket.java:466)
at java.net.Socket.(Socket.java:366)
at java.net.Socket.(Socket.java:208)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
at com.mysql.jdbc.Connection.(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at gestorBD.conectar(gestorBD.java:42)
at main_clase.(main_clase.java:20)
at main_clase$6.run(main_clase.java:243)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
¿Alguien puede ayudarme? Muchas gracias