Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™

Inserting and Updating Large Objects

Large objects need to be handled differently because of their size. Rather than assigning a value directly to a large object, output streams are used to move data into CLOBs and BLOBs. Three methods are available for creating output streams. Two methods are meant for character objects, and the third is for binary objects.

• OutputStream setAsciiStream(long position), setUnicodeStream(long position)

  The setAsciiStream() method returns an output stream that contains ASCII bytes, and the setUnicodeStream() method is used for Unicode characters. The position parameter specifies the starting point for writing values in the BLOB.

• OutputStream setBinaryStream(long position)

  The setBinaryStream() method returns an output ...