Re: Issues with either SQL or JAVA after upgrading from v5.4 to v7.2

I don't remember at what OS release it happened but DB2 introduced a data
truncation property on it's driver settings and you need to set it to false
as it defaults to true. True means it throws an error, false means it will
truncate the data and not throw an error.

-----Original Message-----
From: JAVA400-L [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of a4g
atl
Sent: Wednesday, July 11, 2018 2:00 PM
To: java400-l@xxxxxxxxxxxx
Subject: Issues with either SQL or JAVA after upgrading from v5.4 to v7.2

We have upgraded to V7.2 from V5.4. I do not know if this is a JAVA or SQL
issue or both.

We have a number of Web Methods interfaces to our systems using the JT400
tools. In v5r4 it works fine, but in v7 something is going wrong and the
database or system is returning a data truncation error. We cannot find
what this truncation is.

We installed the latest JT400 on the remote system.

Web methods is trying to do a simple INSERT into a file that returns a
truncation error.

I ran a communications trace with IBM and IBM sees the request, it is
processed and does not return an error.

What is strange is that IBM sees a PREPARE statement but the EXECUTE is
never received from the client system. The client, a UNIX box, does not
send a PREPARE followed by an EXECUTE so IBMi is doing something under the
covers to convert to PREPARE and EXECUTE. This process must be generating
the error.

Has anyone experienced this issue and if so, how do you overcome the
problem.

TIA

Darryl Freinkel.
--
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: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

--
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: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.