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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.