O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required