| java.sql.Blob |
A Java interface mapping for the SQL BLOB type.
An SQL CLOB type stores a large array of bytes (binary data) 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 Clob data length, for searching for data within the Blob.
| Public Methods | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
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 the specified pattern
begins, starting at a specified position within the Blob.
| |||||||||||
Search for the position in this Blob at which a 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 portion of a specified byte array to this Blob.
| |||||||||||
Writes a specified array of bytes to this Blob.
| |||||||||||
Truncate the value of this Blob object to a specified length in bytes.
| |||||||||||
Retrieves this Blob object as a binary stream.
| 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 |
length bytes long| SQLException | if an error occurs accessing the Blob |
|---|
Gets the number of bytes in this Blob object.
| 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 |
| 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 |
| 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 |
|---|
| 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, as the number of bytes |
| 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 |
| 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 to truncate the value of this Blob |
|---|
| SQLException | if an error occurs accessing the Blob |
|---|