Re: Communication link failure

I've seen this error before when I end a job from a connection pool under
QUSRWRK. Is someone possibly ending jobs under QUSRWRK or QSYSWRK?

I'm sure there are other reasons, but that's one that has happened to me.

--
James R. Perkins


On Thu, Mar 5, 2009 at 08:37, Glenn Holmer <gholmer@xxxxxxxxxxxxxx> wrote:

Is anyone familiar with this type of exception? We had a whole storm of
them over a couple days, but our iSeries tech guys can't figure out what
might have caused it. How to diagnose and/or prevent something like
this?

2009-02-27 08:37:12,590 [ACS Order Thread] ERROR
com.weycogroup.service.order.impl.WeycoOrderServiceImpl - *** Error looking
up UPC code
org.springframework.dao.DataAccessResourceFailureException:
StatementCallback; SQL [SELECT COUNT(*) FROM ACSDBASE3.STYLPU WHERE SUUPC =
23938208324]; Communication link failure. (Connection timed out); nested
exception is java.sql.SQLExc
eption: Communication link failure. (Connection timed out)
Caused by:
java.sql.SQLException: Communication link failure. (Connection timed out)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
at
com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2839)
at
com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1568)
at
com.ibm.as400.access.AS400JDBCStatement.executeQuery(AS400JDBCStatement.java:2136)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

--
____________________________________________________________
Glenn Holmer gholmer@xxxxxxxxxxxxxx
Software Engineer phone: 414-908-1809
Weyco Group, Inc. fax: 414-908-1601



--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.