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.