Erro na Conexão com o MySql

Front-end
#1

Estou comproblemas na concexão com meu banco MySQL 5.0.
Segue o código de conexão:

[code] private Connection getConnection() throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException {

    String URL = "jdbc:mysql://robinho.no-ip.info/dese";
    String usuario = "root";
    String senha = "root";

    Class.forName("org.gjt.mm.mysql.Driver").newInstance();
    Connection connection = DriverManager.getConnection(URL, usuario, senha);
    
    return connection;
}

[/code]

Segue a exceção:
[i]
Iniciando chamada FACADE - ::getLembretes()
Iniciando execução => getLembretes
java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect

** BEGIN NESTED EXCEPTION **

java.net.ConnectException
MESSAGE: Connection refused: connect

STACKTRACE:

java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
at java.net.Socket.connect(Socket.java:461)
at java.net.Socket.connect(Socket.java:411)
at java.net.Socket.(Socket.java:310)
at java.net.Socket.(Socket.java:125)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:121)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:220)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1768)
at com.mysql.jdbc.Connection.(Connection.java:440)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:400)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at br.com.cinderela.core.dao.CinderelaDAO.getConnection(CinderelaDAO.java:72)
at br.com.cinderela.core.dao.CinderelaDAO.getLembretes(CinderelaDAO.java:430)
at br.com.cinderela.core.facade.CinderelaFacade.getLembretes(CinderelaFacade.java:142)
at br.com.cinderela.control.action.ShowCreateAccountAction.execute(ShowCreateAccountAction.java:47)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)

[/i]

Alguém sabe pq não consigo conectar?!

#2

Problema Resolvido Eu tinha esquecido de colocar no número da porta do MySql no host.

String URL = "jdbc:mysql://robinho.no-ip.info:3309/dese
#3

Olá

java.net.ConnectException > classe para conexão com Sockets.
java.sql.Connection > Classe para conexão com banco de dados via jdbc.

Vc está usando a primeira, sendo que o seu caso é o da segunda.

Flws!

#4