java.sql.Blob |
A Java interface representing the SQL
BLOB
type.
An SQL
BLOB
type stores a large array of binary data (bytes) as the
value in a column of a database.
The
java.sql.Blob
interface provides methods for setting and
retrieving data in the
Blob
, for querying
Blob
data length,
and for searching for data within the
Blob
.
Public Methods | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
|
Frees any resources held by this blob.
|
||||||||||
|
Retrieves
length
bytes from this
Blob
, starting at 1-based
offset
pos
, and returns them as a binary stream.
|
||||||||||
|
Retrieves this
Blob
object as a binary stream.
|
||||||||||
|
Gets a portion of the value of this
Blob
as an array of bytes.
|
||||||||||
|
Gets the number of bytes in this
Blob
object.
|
||||||||||
|
Search for the position in this
Blob
at which a specified pattern
begins, starting at a specified position within the
Blob
.
|
||||||||||
|
Search for the position in this
Blob
at which the specified
pattern begins, starting at a specified position within the
Blob
.
|
||||||||||
|
Gets a stream that can be used to write binary data to this
Blob
.
|
||||||||||
|
Writes a specified array of bytes to this
Blob
object, starting
at a specified position.
|
||||||||||
|
Writes a portion of a specified byte array to this
Blob
.
|
||||||||||
|
Truncate the value of this
Blob
object to a specified length in
bytes.
|
Frees any resources held by this blob. After
free
is called, calling
method other than
free
will throw
SQLException
(calling
free
repeatedly will do nothing).
SQLException |
---|
Retrieves
length
bytes from this
Blob
, starting at 1-based
offset
pos
, and returns them as a binary stream.
InputStream
giving access to the
Blob
data.
SQLException |
if an error occurs accessing the
Blob
.
|
---|
Retrieves this
Blob
object as a binary stream.
InputStream
giving access to the
Blob
data.
SQLException |
if an error occurs accessing the
Blob
.
|
---|
Gets a portion of the value of this
Blob
as an array of bytes.
pos |
the position of the first byte in the
Blob
to get,
where the first byte in the
Blob
has position 1.
|
---|---|
length | the number of bytes to get. |
Blob
, starting
at
pos
and is up to
length
bytes long.
SQLException |
if an error occurs accessing the
Blob
.
|
---|
Gets the number of bytes in this
Blob
object.
long
value with the length of the
Blob
in
bytes.
SQLException |
if an error occurs accessing the
Blob
.
|
---|
Search for the position in this
Blob
at which a specified pattern
begins, starting at a specified position within the
Blob
.
pattern |
a
Blob
containing the pattern of data to search for in
this
Blob
.
|
---|---|
start |
the position within this
Blob
to start the search,
where the first position in the
Blob
is
1
.
|
long
value with the position at which the pattern
begins. Returns
-1
if the pattern is not found in this
Blob
.
SQLException |
if an error occurs accessing the
Blob
.
|
---|
Search for the position in this
Blob
at which the specified
pattern begins, starting at a specified position within the
Blob
.
pattern |
a byte array containing the pattern of data to search for in
this
Blob
.
|
---|---|
start |
the position within this
Blob
to start the search,
where the first position in the
Blob
is
1
.
|
long
value with the position at which the pattern
begins. Returns
-1
if the pattern is not found in this
Blob
.
SQLException |
if an error occurs accessing the
Blob
.
|
---|
Gets a stream that can be used to write binary data to this
Blob
.
pos |
the position within this
Blob
at which to start
writing, where the first position in the
Blob
is
1
.
|
---|
InputStream
which can be used to write data into
the
Blob
starting at the specified position.
SQLException |
if an error occurs accessing the
Blob
.
|
---|
Writes a specified array of bytes to this
Blob
object, starting
at a specified position. Returns the number of bytes written.
pos |
the position within this
Blob
at which to start
writing, where the first position in the
Blob
is
1
.
|
---|---|
theBytes |
an array of bytes to write into the
Blob
.
|
Blob
.
SQLException |
if an error occurs accessing the
Blob
.
|
---|
Writes a portion of a specified byte array to this
Blob
. Returns
the number of bytes written.
pos |
the position within this
Blob
at which to start
writing, where the first position in the
Blob
is
1
.
|
---|---|
theBytes |
an array of bytes to write into the
Blob
.
|
offset |
the offset into the byte array from which to start writing
data - the first byte in the array has offset
0
.
|
len | the length of data to write in number of bytes. |
Blob
.
SQLException |
if an error occurs accessing the
Blob
.
|
---|
Truncate the value of this
Blob
object to a specified length in
bytes.
len |
the length of data in bytes after which this
Blob
is to be truncated.
|
---|
SQLException |
if an error occurs accessing the
Blob
.
|
---|