Greetings all, we have some Java code that inserts to MVS/DB2 V6.1.
We use the setObject() method, passing it a character array as the 2nd
argument, and specify the type as the 3rd argument,
(javax.sql.Types.CLOB_TYPE).
It works if the CLOB length is <= 10901 bytes. If it is 10902 or longer, no
data is written to the column at all (LENGTH(COLNAME) returns 0), no
exception is thrown in the Java, and no errors are written to the
DB2DIAG.log.
Curiously, the same Java works when run against a UDB DB2 7.2 (fp6)
database running on AIX, using similarly constructed tables.
We're running WAS 4.0, JDK 1.3.1, single-phase DB2ConnectionPoolDataSource
driver.
Anyone else done this, or something similar before?
Thanx to anyone who can help!
Stephen Pennine
BCBSRI