Bug 44784

Informational

GemConnect

2.4, 2.3

All Platforms

Reading/Writing BLOBS/CLOBS > 64K using default LONG/LONGRAW configuration will silently truncate

By default BLOBS/CLOBS in GemConnect are treated as Oracle LONG/LONGRAW datatypes, and are limited to the default textLimit size of 65532 bytes. In earlier releases, attempting to read/write BLOBS/CLOBS larger than this would trigger a #typeConversionError (except for bug 44775).  But in 2.3, GemConnect will read/write the data to/from Oracle but silently truncate the BLOB/CLOB to 65532 bytes.

Workaround

Use the alternative BLOB/CLOB API by setting the connection lobLimit > 0 to generate GsOracleBLOB/GsOracleCLOB instances and then calling #readAll/#writeAll: to read/write the bytearray/string to/from the Oracle BLOB/CLOB.


Last updated: 7/19/18