You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Douglas Reames <do...@rmsfinance.com> on 2003/04/16 17:23:46 UTC
Communication link failure: java.net.SocketException
Hi,
I am attempting to run a sample struts app from James Goodwill's 'Mastering
Jakarta Struts' [ Wiley ]. When using this app, I frequently get the
error: - Communication link failure: java.net.SocketException.
My Setup: Tomcat 4.1; mysql-connector-java-3.0.5-gamma-bin.jar; Struts 1.0.2
Edit, Delete, and Select transactions are successful 70% ( ? ) of the time.
Insert has never worked.
Finally, when I cut & paste the application-constructed sql statement from
the application log into JEDIT's buffer, I can successfully execute the
failed transaction every time.
Can someone refer me to a troubleshooting checklist?
Best regards,
Douglas Reames
RMS Finance
919 929 3465
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
RE: Communication link failure: java.net.SocketException
Posted by Douglas Reames <do...@rmsfinance.com>.
Thanks for the tip Brandon; I'll let you know how I came out.
Regards,
Doug
At 10:06 AM 4/16/2003 -0600, you wrote:
>Yep! If you are using tomcat 4.1 dbcp see the tomcat docs for setting up for
>mysql.
>
>http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how
>to.html#MySQL%20DBCP%20Example
>
>Brandon Goodin
>Phase Web and Multimedia
>PO Box 85
>Whitefish MT 59937
>P (406) 862-2245
>F (406) 862-0354
>mail@phase.ws
>http://www.phase.ws
>
>
>-----Original Message-----
>From: Douglas Reames [mailto:dougr@rmsfinance.com]
>Sent: Wednesday, April 16, 2003 10:07 AM
>To: Struts Users Mailing List
>Subject: Re: Communication link failure: java.net.SocketException
>
>
>I have since changed the MYSQL Driver to the mm.mysql-2.0.14 version (
>which I assume explains the why the exception thrown changed to
>java.io.IOException ), but I get the same results: Edits, Deletes, Selects
>work 70+% of the time. Adds never work. The stack trace is:
>
>java.sql.SQLException: Communication link failure: java.io.IOException
> at org.gjt.mm.mysql.MysqlIO.clearAllReceive(Unknown Source)
> at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
> at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
> at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
> at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
> at org.gjt.mm.mysql.Statement.execute(Unknown Source)
> at org.gjt.mm.mysql.jdbc2.Statement.execute(Unknown Source)
> at
>org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java
>:183)
> at com.wiley.AddEmployeeAction.insertUser(AddEmployeeAction.java:63)
> at com.wiley.AddEmployeeAction.perform(AddEmployeeAction.java:119)
> at org.apache.struts.action.Action.execute(Action.java:401)
> at
>org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
>sor.java:446)
> at
>org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
> at
>org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
> at
>org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at ...
>
>Anyone seen this before?
>
>Regards,
>Douglas Reames
>
>
>At 11:23 AM 4/16/2003 -0400, you wrote:
> >Hi,
> >I am attempting to run a sample struts app from James Goodwill's
> >'Mastering Jakarta Struts' [ Wiley ]. When using this app, I frequently
> >get the error: - Communication link failure: java.net.SocketException.
> >
> >My Setup: Tomcat 4.1; mysql-connector-java-3.0.5-gamma-bin.jar; Struts
>1.0.2
> >
> >Edit, Delete, and Select transactions are successful 70% ( ? ) of the
> >time. Insert has never worked.
> >
> >Finally, when I cut & paste the application-constructed sql statement from
> >the application log into JEDIT's buffer, I can successfully execute the
> >failed transaction every time.
> >
> >Can someone refer me to a troubleshooting checklist?
> >
> >Best regards,
> >Douglas Reames
> >RMS Finance
> >919 929 3465
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: struts-user-help@jakarta.apache.org
> >
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: struts-user-help@jakarta.apache.org
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: struts-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
RE: Communication link failure: java.net.SocketException
Posted by Brandon Goodin <ma...@phase.ws>.
Yep! If you are using tomcat 4.1 dbcp see the tomcat docs for setting up for
mysql.
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how
to.html#MySQL%20DBCP%20Example
Brandon Goodin
Phase Web and Multimedia
PO Box 85
Whitefish MT 59937
P (406) 862-2245
F (406) 862-0354
mail@phase.ws
http://www.phase.ws
-----Original Message-----
From: Douglas Reames [mailto:dougr@rmsfinance.com]
Sent: Wednesday, April 16, 2003 10:07 AM
To: Struts Users Mailing List
Subject: Re: Communication link failure: java.net.SocketException
I have since changed the MYSQL Driver to the mm.mysql-2.0.14 version (
which I assume explains the why the exception thrown changed to
java.io.IOException ), but I get the same results: Edits, Deletes, Selects
work 70+% of the time. Adds never work. The stack trace is:
java.sql.SQLException: Communication link failure: java.io.IOException
at org.gjt.mm.mysql.MysqlIO.clearAllReceive(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
at org.gjt.mm.mysql.Statement.execute(Unknown Source)
at org.gjt.mm.mysql.jdbc2.Statement.execute(Unknown Source)
at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java
:183)
at com.wiley.AddEmployeeAction.insertUser(AddEmployeeAction.java:63)
at com.wiley.AddEmployeeAction.perform(AddEmployeeAction.java:119)
at org.apache.struts.action.Action.execute(Action.java:401)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:446)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at ...
Anyone seen this before?
Regards,
Douglas Reames
At 11:23 AM 4/16/2003 -0400, you wrote:
>Hi,
>I am attempting to run a sample struts app from James Goodwill's
>'Mastering Jakarta Struts' [ Wiley ]. When using this app, I frequently
>get the error: - Communication link failure: java.net.SocketException.
>
>My Setup: Tomcat 4.1; mysql-connector-java-3.0.5-gamma-bin.jar; Struts
1.0.2
>
>Edit, Delete, and Select transactions are successful 70% ( ? ) of the
>time. Insert has never worked.
>
>Finally, when I cut & paste the application-constructed sql statement from
>the application log into JEDIT's buffer, I can successfully execute the
>failed transaction every time.
>
>Can someone refer me to a troubleshooting checklist?
>
>Best regards,
>Douglas Reames
>RMS Finance
>919 929 3465
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: struts-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
Re: Communication link failure: java.net.SocketException
Posted by Douglas Reames <do...@rmsfinance.com>.
I have since changed the MYSQL Driver to the mm.mysql-2.0.14 version (
which I assume explains the why the exception thrown changed to
java.io.IOException ), but I get the same results: Edits, Deletes, Selects
work 70+% of the time. Adds never work. The stack trace is:
java.sql.SQLException: Communication link failure: java.io.IOException
at org.gjt.mm.mysql.MysqlIO.clearAllReceive(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
at org.gjt.mm.mysql.Statement.execute(Unknown Source)
at org.gjt.mm.mysql.jdbc2.Statement.execute(Unknown Source)
at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183)
at com.wiley.AddEmployeeAction.insertUser(AddEmployeeAction.java:63)
at com.wiley.AddEmployeeAction.perform(AddEmployeeAction.java:119)
at org.apache.struts.action.Action.execute(Action.java:401)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at ...
Anyone seen this before?
Regards,
Douglas Reames
At 11:23 AM 4/16/2003 -0400, you wrote:
>Hi,
>I am attempting to run a sample struts app from James Goodwill's
>'Mastering Jakarta Struts' [ Wiley ]. When using this app, I frequently
>get the error: - Communication link failure: java.net.SocketException.
>
>My Setup: Tomcat 4.1; mysql-connector-java-3.0.5-gamma-bin.jar; Struts 1.0.2
>
>Edit, Delete, and Select transactions are successful 70% ( ? ) of the
>time. Insert has never worked.
>
>Finally, when I cut & paste the application-constructed sql statement from
>the application log into JEDIT's buffer, I can successfully execute the
>failed transaction every time.
>
>Can someone refer me to a troubleshooting checklist?
>
>Best regards,
>Douglas Reames
>RMS Finance
>919 929 3465
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: struts-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org