Communications link failure Last packet sent to the server was 0 ms ago

Hi All,
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?

Hello,

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.

this is the only exception i am getting.

now i got the full exception:

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

Hello,

Caused by: java.net.ConnectException: No route to host

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?

tomcat and MySQL is running in the same machine...

since this exception is coming while connecting to the database i posted in
Power*Architect.

Hello,

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://jdbcerrorinfo.blogspot.com/2009/11/communication-link-failure-mysqljdbc.html

exception message by reproducing the erro