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.Type s.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 DB2ConnectionPo olDataSource
driver.
Anyone else done this, or something similar before?
Thanx to anyone who can help!
Stephen Pennine
BCBSRI
We use the setObject() method, passing it a character array as the 2nd
argument, and specify the type as the 3rd argument,
(javax.sql.Type s.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 DB2ConnectionPo olDataSource
driver.
Anyone else done this, or something similar before?
Thanx to anyone who can help!
Stephen Pennine
BCBSRI