# Clob

Represents a CLOB value.

Methods
void | free() Release all resources of this object.
void | free() Release all resources of this object.
InputStream | getAsciiStream() Returns the input stream.
InputStream | getAsciiStream() throws SQLException Returns the input stream. Returns: the input stream
Reader | getCharacterStream() Returns the reader.
Reader | getCharacterStream() throws SQLException Returns the reader. Returns: the reader
Reader | getCharacterStream(long pos, long length) [Not supported] Returns the reader, starting from an offset.
Reader | getCharacterStream(long pos, long length) throws SQLException [Not supported] Returns the reader, starting from an offset.
String | getSubString(long pos, int length) Returns a substring.
String | getSubString(long pos, int length) throws SQLException Returns a substring. Parameters: pos - the position (the first character is at position 1) length - the number of characters Returns: the string
long | length() Returns the length.
long | length() throws SQLException Returns the length. Returns: the length
long | position(String pattern, long start) [Not supported] Searches a pattern and return the position.
long | position(String pattern, long start) throws SQLException [Not supported] Searches a pattern and return the position.
long | position(Clob clobPattern, long start) [Not supported] Searches a pattern and return the position.
long | position(Clob clobPattern, long start) throws SQLException [Not supported] Searches a pattern and return the position.
OutputStream | setAsciiStream(long pos) [Not supported] Returns an output stream.
OutputStream | setAsciiStream(long pos) throws SQLException [Not supported] Returns an output stream.
Writer | setCharacterStream(long pos) Get a writer to update the Clob.

Writer

setCharacterStream(long pos) throws SQLException
Get a writer to update the Clob. This is only supported for new, empty Clob objects that were created with Connection.createClob() or createNClob(). The Clob is created in a separate thread, and the object is only updated when Writer.close() is called. The position must be 1, meaning the whole Clob data is set.
Parameters:
pos - where to start writing (the first character is at position 1)
Returns:
a writer

int | setString(long pos, String str) Fills the Clob.
int | setString(long pos, String str) throws SQLException Fills the Clob. This is only supported for new, empty Clob objects that were created with Connection.createClob() or createNClob(). The position must be 1, meaning the whole Clob data is set. Parameters: pos - where to start writing (the first character is at position 1) str - the string to add Returns: the length of the added text
int | setString(long pos, String str, int offset, int len) [Not supported] Sets a substring.
int | setString(long pos, String str, int offset, int len) throws SQLException [Not supported] Sets a substring.
void | truncate(long len) [Not supported] Truncates the object.
void | truncate(long len) throws SQLException [Not supported] Truncates the object.