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