Re: Communications link failure
Posted by: zattarz za
Date: February 02, 2008 08:03AM

help!
most of the time connection works ok.
somtime we are getting
"Communications link failure Last packet sent to the server was 16 ms ago"
---------
on one server is win 2003 server standard we have tomcat 5.5 on secod also win2003 server mysql v 5.0.45
jdbc driver is:mysql-connector-java-5.1.5-bin.jar

here under the full setting in the tomcat

<Context name="/ccc" docBase="D:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\ccc\web">
<Parameter name="configurationPath" value="D:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\ccc\config" override="true"/>

<Resource name="jdbc/copo" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="appyyy" password="xxxx" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://10.0.0.1:3306/tech_db?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=utf8"/>

<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://10.0.0.1:3306/tech_db?autoReconnect=true&amp;user=appyyy&amp;password=xxxx"
userTable="admin_users"
userNameCol="admin_username"
userCredCol="admin_password"
userRoleTable="admin_users_roles"
roleNameCol="admin_user_role_name"/>
</Context>

hereunder the fal exepetion


path is =D:\Program Files\Apache Software Foundation\Tomcat 5.5\bin\bootstrap.jar;D:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\copo\web\WEB-INF\lib\jmagick.jar;D:\Program Files\Apache Software Foundation\Tomcat 5.5\common\lib\mysql-connector-java-5.1.5-bin.jar
com.mysql.jdbc.CommunicationsException: Communications link failure

Last packet sent to the server was 16 ms ago.
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3134)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1818)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at com.dig.data.db.utils.DatabaseHandler.executeQuery(DatabaseHandler.java:89)
at com.dig.data.db.resources.BarcodeTransactions.get(BarcodeTransactions.java:57)
at com.dig.web.handler.app.GetTransactionsDataHandler.performTask(GetTransactionsDataHandler.java:185)
at com.dig.web.control.ControlServlet.performTask(ControlServlet.java:116)
at com.dig.web.control.ControlServlet.doGet(ControlServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:686)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:656)
at org.apache.jsp.b_jsp._jspService(b_jsp.java:58)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3119)


can someone help us?

Best,
Zattarz



Edited 1 time(s). Last edit at 02/02/2008 08:40AM by zattarz za.

Options: ReplyQuote


Subject
Written By
Posted
January 16, 2008 01:14AM
January 17, 2008 10:10AM
Re: Communications link failure
February 02, 2008 08:03AM
January 19, 2009 11:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.