<![CDATA[Latest posts for the topic "Communications link failure Last packet sent to the server was 0 ms ago"]]> http://www.sqlpower.ca/forum/posts/list/2.page JForum - http://www.jforum.net Communications link failure Last packet sent to the server was 0 ms ago i am connecting to the MySQL DB which is present in server.
it is giving the exception"Communications link failure Last packet sent to the server was 0 ms ago". where as it is working fine in localhost. i am using redhat OS, tomcat 5, MySQL 5.
Does anybody know what is the problem?]]> http://www.sqlpower.ca/forum/posts/preList/1911/2800.page http://www.sqlpower.ca/forum/posts/preList/1911/2800.page GMT Re:Communications link failure Last packet sent to the server was 0 ms ago
You can send us a more detailed exception message by reproducing the error, and then clicking the 'Show Details' button. Please copy and paste the detailed message into a reply on this thread.]]> http://www.sqlpower.ca/forum/posts/preList/1911/2801.page http://www.sqlpower.ca/forum/posts/preList/1911/2801.page GMT Communications link failure Last packet sent to the server was 0 ms ago ]]> http://www.sqlpower.ca/forum/posts/preList/1911/2834.page http://www.sqlpower.ca/forum/posts/preList/1911/2834.page GMT Communications link failure Last packet sent to the server was 0 ms ago
com.mysql.jdbc.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:71
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:29
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(libgcj.so.7rh)
at java.sql.DriverManager.getConnection(libgcj.so.7rh)
at KTAMobileCoupon.doGet(KTAMobileCoupon.java:34)
at javax.servlet.http.HttpServlet.service(tomcat5-servlet-2.4-api-5.5.23.jar.so)
at javax.servlet.http.HttpServlet.service(tomcat5-servlet-2.4-api-5.5.23.jar.so)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(catalina-5.5.23.jar.so)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(catalina-5.5.23.jar.so)
at org.apache.catalina.core.StandardWrapperValve.invoke(catalina-5.5.23.jar.so)
at org.apache.catalina.core.StandardContextValve.invoke(catalina-5.5.23.jar.so)
at org.apache.catalina.core.StandardHostValve.invoke(catalina-5.5.23.jar.so)
at org.apache.catalina.valves.ErrorReportValve.invoke(catalina-5.5.23.jar.so)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(catalina-optional-5.5.23.jar.so)
at org.apache.catalina.core.StandardEngineValve.invoke(catalina-5.5.23.jar.so)
at org.apache.catalina.connector.CoyoteAdapter.service(catalina-5.5.23.jar.so)
at org.apache.coyote.http11.Http11Processor.process(tomcat-http-5.5.23.jar.so)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(tomcat-http-5.5.23.jar.so)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(tomcat-util-5.5.23.jar.so)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(tomcat-util-5.5.23.jar.so)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(tomcat-util-5.5.23.jar.so)
at java.lang.Thread.run(libgcj.so.7rh)
Caused by: java.net.ConnectException: No route to host
at gnu.java.net.PlainSocketImpl.connect(libgcj.so.7rh)
at java.net.Socket.connect(libgcj.so.7rh)
at java.net.Socket.connect(libgcj.so.7rh)
at java.net.Socket.<init>(libgcj.so.7rh)
at java.net.Socket.<init>(libgcj.so.7rh)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)
...23 more

]]> http://www.sqlpower.ca/forum/posts/preList/1911/2835.page http://www.sqlpower.ca/forum/posts/preList/1911/2835.page GMT Re:Communications link failure Last packet sent to the server was 0 ms ago
[quote] Caused by: java.net.ConnectException: No route to host[/quote]

Looks like you have a network connectivity issue between your Tomcat server and you MySQL database server. Are you running them on separate machines?

Also, seeing as how this error is coming from Tomcat, is this issue actually related to Power*Architect in any way?]]> http://www.sqlpower.ca/forum/posts/preList/1911/2836.page http://www.sqlpower.ca/forum/posts/preList/1911/2836.page GMT Re:Communications link failure Last packet sent to the server was 0 ms ago
since this exception is coming while connecting to the database i posted in
Power*Architect.]]> http://www.sqlpower.ca/forum/posts/preList/1911/2837.page http://www.sqlpower.ca/forum/posts/preList/1911/2837.page GMT Re:Communications link failure Last packet sent to the server was 0 ms ago
I don't think this is the appropriate forum for you to ask your question unless you are asking specifically about Power*Architect issues.

If you are having issues with Tomcat and MySQL, you would probably be able to get more useful answers from a Tomcat or MySQL-specific forum or mailing list.

Here is a list of the official Tomcat mailing lists:
http://tomcat.apache.org/lists.html

And the official MySQL forum
http://forums.mysql.com/

That being said, as far as I can tell, the web application you have deployed on your Tomcat server does not have it's database settings configured properly. In particular, it doesn't look like you specified the right host as your database server.]]> http://www.sqlpower.ca/forum/posts/preList/1911/2838.page http://www.sqlpower.ca/forum/posts/preList/1911/2838.page GMT Re:Communications link failure Last packet sent to the server was 0 ms ago http://jdbcerrorinfo.blogspot.com/2009/11/communication-link-failure-mysqljdbc.html]]> http://www.sqlpower.ca/forum/posts/preList/1911/5721.page http://www.sqlpower.ca/forum/posts/preList/1911/5721.page GMT