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