Blob

Represents a BLOB value.

Methods
void free()
Release all resources of this object.
void free()
Release all resources of this object.
InputStream getBinaryStream()
Returns the input stream.
InputStream getBinaryStream() throws SQLException
Returns the input stream.
Returns:
the input stream
InputStream getBinaryStream(long pos, long length)
[Not supported] Returns the input stream, starting from an offset.
InputStream getBinaryStream(long pos, long length) throws SQLException
[Not supported] Returns the input stream, starting from an offset.
Parameters:
pos - where to start reading
length - the number of bytes that will be read
Returns:
the input stream to read
byte[] getBytes(long pos, int length)
Returns some bytes of the object.
byte[] getBytes(long pos, int length) throws SQLException
Returns some bytes of the object.
Parameters:
pos - the index, the first byte is at position 1
length - the number of bytes
Returns:
the bytes, at most length bytes
long length()
Returns the length.
long length() throws SQLException
Returns the length.
Returns:
the length
long position(byte[] pattern, long start)
[Not supported] Searches a pattern and return the position.
long position(byte[] pattern, long start) throws SQLException
[Not supported] Searches a pattern and return the position.
Parameters:
pattern - the pattern to search
start - the index, the first byte is at position 1
Returns:
the position (first byte is at position 1), or -1 for not found
long position(Blob blobPattern, long start)
[Not supported] Searches a pattern and return the position.
long position(Blob blobPattern, long start) throws SQLException
[Not supported] Searches a pattern and return the position.
Parameters:
blobPattern - the pattern to search
start - the index, the first byte is at position 1
Returns:
the position (first byte is at position 1), or -1 for not found
OutputStream setBinaryStream(long pos)
Get a writer to update the Blob.
OutputStream setBinaryStream(long pos) throws SQLException
Get a writer to update the Blob. This is only supported for new, empty Blob objects that were created with Connection.createBlob(). The Blob is created in a separate thread, and the object is only updated when OutputStream.close() is called. The position must be 1, meaning the whole Blob data is set.
Parameters:
pos - where to start writing (the first byte is at position 1)
Returns:
an output stream
int setBytes(long pos, byte[] bytes)
Fills the Blob.
int setBytes(long pos, byte[] bytes) throws SQLException
Fills the Blob. This is only supported for new, empty Blob objects that were created with Connection.createBlob(). The position must be 1, meaning the whole Blob data is set.
Parameters:
pos - where to start writing (the first byte is at position 1)
bytes - the bytes to set
Returns:
the length of the added data
int setBytes(long pos, byte[] bytes, int offset, int len)
[Not supported] Sets some bytes of the object.
int setBytes(long pos, byte[] bytes, int offset, int len) throws SQLException
[Not supported] Sets some bytes of the object.
Parameters:
pos - the write position
bytes - the bytes to set
offset - the bytes offset
len - the number of bytes to write
Returns:
how many bytes have been written
void truncate(long len)
[Not supported] Truncates the object.
void truncate(long len) throws SQLException
[Not supported] Truncates the object.
Parameters:
len - the new length