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