# Clob Represents a CLOB value.
Methods
InputStream | getAsciiStream() Returns the input stream.
InputStream | getAsciiStream() throws SQLException Returns the input stream. Returns: the input stream
Reader | getCharacterStream()
Reader | getCharacterStream() throws SQLException
Reader | getCharacterStream(long pos, long length) Returns the reader, starting from an offset.
Reader | getCharacterStream(long pos, long length) throws SQLException Returns the reader, starting from an offset. Parameters: pos - 1-based offset length - length of requested area Returns: the reader
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) Fills the Clob.
int | setString(long pos, String str, int offset, int len) 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 offset - the string offset len - the number of characters to read Returns: the length of the added text
void | truncate(long len) [Not supported] Truncates the object.
void | truncate(long len) throws SQLException [Not supported] Truncates the object.