I cannot see the highlighted line and the code is a bit hard to read.

My initial guess would be that you for some reason actually pass in a null
value to stmt.setString(...) causing it to complain.

If the reason the stack trace is truncated is because you have copied it
from QPRINT, you may want to tell System.out and System.err to wrap their
output, or use log4j/logback/etc to log to a file.



-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Matt Pryor
Sent: 31. januar 2014 18:14
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(AS400JDBCPrepa

com.internationalpresence.impscloudgateway.dcfreader.DCFReader.loadFiles

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 ...


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

This mailing list archive is Copyright 1997-2022 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.