Código:
Me arroja este error al intentar conectarse a la base de datos.try { Class.forName("org.gjt.mm.mysql.Driver"); Connection conexion = DriverManager.getConnection("jdbc:mysql://205.251.132.163/forza", "root", "root"); if (!conexion.isClosed()) { Statement st = conexion.createStatement(); ResultSet rs = st.executeQuery("select * from login" ); out.println("<table border=\"1\"><tr><td>Id</td><td>email</td><td>password</td><td>Tipo</td></tr>"); while (rs.next()) { out.println("<tr>"); out.println("<td>"+rs.getObject("id_login")+"</td>"); out.println("<td>"+rs.getObject("email")+"</td>"); out.println("<td>"+rs.getObject("password")+"</td>"); out.println("<td>"+rs.getObject("tipo_usr")+"</td>"); out.println("</tr>"); } out.println("</table>"); conexion.close(); } else out.println("fallo"); } catch (Exception e) { out.println("Excepcion "+e); e.printStackTrace(); }
Excepcion com.mysql.jdbc.CommunicationsException: 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(Stand ardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284) at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2569) at com.mysql.jdbc.Connection.(Connection.java:1485) at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager .java:582) at java.sql.DriverManager.getConnection(DriverManager .java:185) at org.apache.jsp.pruebaconexion_jsp._jspService(prue baconexion_jsp.java:72) at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet .java:717) at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:386) at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet .java:717) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run( JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:619) ** END NESTED EXCEPTION ** Last packet sent to the server was 1 ms ago.
les agradesco antemano la ayuda que me puedan ofrecer.