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