| java.sql.Clob |
 Known Indirect Subclasses
|
A Java interface mapping for the SQL CLOB type.
An SQL CLOB type stores a large array of characters as the value in a
column of a database.
The java.sql.Clob interface provides methods for setting and
retrieving data in the Clob, for querying Clob data length,
for searching for data within the Clob.
| Public Methods | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Frees any resources held by this clob.
| |||||||||||
Gets the value of this
Clob object as an ASCII stream.
| |||||||||||
Gets the data of this
Clob object in a java.io.Reader.
| |||||||||||
Returns a
Reader that reads length characters from this clob, starting
at 1-based offset {code pos}.
| |||||||||||
Gets a copy of a specified substring in this
Clob.
| |||||||||||
Retrieves the number of characters in this
Clob object.
| |||||||||||
Retrieves the character position at which a specified substring appears
in this
Clob object.
| |||||||||||
Retrieves the character position at which a specified
Clob object
appears in this Clob object.
| |||||||||||
Retrieves a stream which can be used to write Ascii characters to this
Clob object, starting at specified position.
| |||||||||||
Retrieves a stream which can be used to write a stream of unicode
characters to this
Clob object, at a specified position.
| |||||||||||
Writes a given Java String to this
Clob object at a specified
position.
| |||||||||||
Writes
len characters of a string, starting at a specified
character offset, to this Clob.
| |||||||||||
Truncates this
Clob after the specified number of characters.
| |||||||||||
Frees any resources held by this clob. After free is called, calling
method other than free will throw SQLException (calling free
repeatedly will do nothing).
| SQLException |
|---|
Gets the value of this Clob object as an ASCII stream.
Developers
InputStream giving access to the
Clob data.| SQLException | if an error occurs accessing the Clob.
|
|---|
Gets the data of this Clob object in a java.io.Reader.
Clob data.| SQLException | if an error occurs accessing the Clob.
|
|---|
Returns a Reader that reads length characters from this clob, starting
at 1-based offset {code pos}.
| SQLException |
|---|
Gets a copy of a specified substring in this Clob.
| pos | the index of the start of the substring in the Clob. |
|---|---|
| length | the length of the data to retrieve. |
| SQLException | if an error occurs accessing the Clob.
|
|---|
Retrieves the number of characters in this Clob object.
Clob.| SQLException | if an error occurs accessing the Clob.
|
|---|
Retrieves the character position at which a specified substring appears
in this Clob object.
| searchstr | the string to search for. |
|---|---|
| start | the position at which to start the search within this Clob. |
Clob.| SQLException | if an error occurs accessing the Clob.
|
|---|
Retrieves the character position at which a specified Clob object
appears in this Clob object.
| searchstr | the specified Clob to search for. |
|---|---|
| start | the position within this Clob to start the search |
Clob occurs within this Clob.| SQLException | if an error occurs accessing the Clob.
|
|---|
Retrieves a stream which can be used to write Ascii characters to this
Clob object, starting at specified position.
| pos | the position at which to start the writing. |
|---|
Clob.| SQLException | if an error occurs accessing the Clob.
|
|---|
Retrieves a stream which can be used to write a stream of unicode
characters to this Clob object, at a specified position.
| pos | the position at which to start the writing. |
|---|
Clob.| SQLException | if an error occurs accessing the Clob.
|
|---|
Writes a given Java String to this Clob object at a specified
position.
| pos | the position at which to start the writing. |
|---|---|
| str | the string to write. |
| SQLException | if an error occurs accessing the Clob.
|
|---|
Writes len characters of a string, starting at a specified
character offset, to this Clob.
| pos | the position at which to start the writing. |
|---|---|
| str | the String to write. |
| offset | the offset within str to start writing from. |
| len | the number of characters to write. |
| SQLException | if an error occurs accessing the Clob.
|
|---|
Truncates this Clob after the specified number of characters.
| len | the length in characters giving the place to
truncate this Clob. |
|---|
| SQLException | if an error occurs accessing the Clob.
|
|---|