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&useUnicode=true&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&user=appyyy&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.
Subject
Written By
Posted
Re: Communications link failure
February 02, 2008 08:03AM
February 25, 2008 05:54PM
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.