RE: Strange JDBC issue -- JAVA400-L

Most of the time an intermittent failure like this is some other thread messing with the objects this thread is using.

Another possibility is a memory allocation error.

Are any of these soft references that could be clobbered by the garbage collector?

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
bounces@xxxxxxxxxxxx] On Behalf Of Matt Pryor
Sent: Friday, January 31, 2014 11:14 AM
To: java400-l@xxxxxxxxxxxx
Subject: Strange JDBC issue

Hello,

This seems to be happening intermittently, and once it happens it happens
repeatedly until the JVM is restarted - suggests not a data issue?

Stacktrace (unfortunately truncated to the right):

null

com.ibm.as400.access.JDServerRow.isInput(JDServerRow.java:840)
com.ibm.as400.access.AS400JDBCPreparedStatement.setValue
(AS400JDBCPrepar

com.ibm.as400.access.AS400JDBCPreparedStatement.setString(AS400JDBCPr
epa

com.internationalpresence.impscloudgateway.dcfreader.DCFReader.loadFile
s

Here is the Java code:

String sql = (
"UPDATE "+lib+".RTGI SET RIRT=?, RIDRV=?, RITL=?, RIX7=? where TELEX = "
+
"(select min(telex) from "+lib+".RTGIR where RIURG=? and (RISPR3='' or
RISPR3 is null) and (RIRT is null or RIRT='' or
(RIX7='Cld"+MessageStatus.RETRYING.getCode()+"' and
RIRT='"+MessageStatus.RETRYING.getCode()+"')) "+
whereClause+")");
stmt = StatementManager.prepareStatement(conn, sql);
for (int xPriority=0; xPriority <
DriverConfig.getDriverConfig().getMinimumPriority()+1; xPriority++) {
stmt.setString (1, MessageStatus.WAITING_FOR_RESOURCE.getCode());
stmt.setString (2, CloudQ.getDriverId());
stmt.setString (3, ritsFormat.format(checkingTime));
stmt.setString (4, MessageStatus.WAITING_FOR_RESOURCE.getRIX7Code());
stmt.setInt (5, xPriority);
int records = stmt.executeUpdate();
stmt.clearParameters();
if (records == 1) {
break;
}
}

Highlighted line is the one that breaks - but this is a constant so can't
be null.

Any thoughts?

Many thanks for any input and hope you all have a great weekend.

--
--
Matt Pryor

--
--
Matt Pryor

The International Presence Group of Companies
Registered Office:10 Coppergate Mews, 109 - 111 Brighton Road, Surbiton,
Surrey KT6 5NE

TEL UK: +44 (0)845 130 6458, FAX: +44 (0)845 130 6459
TEL US: +1 321 726 9941, FAX +1 321 726 6210
EMAIL: pryor@xxxxxxxxxxxxxxx

URL: www.International-presence.com

International Presence Limited: Registered in England and Wales No.3709669

This E-mail and any attachments transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you are not the intended recipient please destroy this
message and kindly notify the sender by reply E-Mail. Opinions, conclusions
and other information in this message that do not relate to the official
business of International Presence Limited do not necessarily reflect the
views of the company.

International Presence Ltd
Unit 10, Coppergate Mews
Surbiton
Surrey KT6 5NE
--
This is the Java Programming on and around the IBM i (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.