Class BlobFromLocator

java.lang.Object

com.mysql.jdbc.BlobFromLocator

All Implemented Interfaces:

Blob

public class BlobFromLocator
extends Object
implements Blob

The representation (mapping) in the JavaTM programming language of an SQL BLOB value. An SQL BLOB is a built-in type that stores a Binary Large Object as a column value in a row of a database table. The driver implements Blob using an SQL locator(BLOB), which means that a Blob object contains a logical pointer to the SQL BLOB data rather than the data itself. A Blob object is valid for the duration of the transaction in which is was created. Methods in the interfaces ResultSet, CallableStatement, and PreparedStatement, such as getBlob and setBlob allow a programmer to access an SQL BLOB value. The Blob interface provides methods for getting the length of an SQL BLOB (Binary Large Object) value, for materializing a BLOB value on the client, and for determining the position of a pattern of bytes within a BLOB value. This class is new in the JDBC 2.0 API.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
(package private) class	BlobFromLocator.LocatorInputStream

Constructor Summary

Constructors

Constructor	Description
BlobFromLocator(ResultSetImpl creatorResultSetToSet, int blobColumnIndex, ExceptionInterceptor exceptionInterceptor)	Creates an updatable BLOB that can update in-place

Method Summary

Modifier and Type	Method	Description
(package private) PreparedStatement	createGetBytesStatement()
void	free()
InputStream	getBinaryStream()	Retrieves the BLOB designated by this Blob instance as a stream.
InputStream	getBinaryStream(long pos, long length)
byte[]	getBytes(long pos, int length)	Returns as an array of bytes, part or all of the BLOB value that this Blob object designates.
(package private) byte[]	getBytesInternal(PreparedStatement pStmt, long pos, int length)
long	length()	Returns the number of bytes in the BLOB value designated by this Blob object.
long	position(byte[] pattern, long start)
long	position(Blob pattern, long start)	Finds the position of the given pattern in this BLOB.
OutputStream	setBinaryStream(long indexToWriteAt)
int	setBytes(long writeAt, byte[] bytes)
int	setBytes(long writeAt, byte[] bytes, int offset, int length)
void	truncate(long length)

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

BlobFromLocator

BlobFromLocator(ResultSetImpl creatorResultSetToSet,
 int blobColumnIndex,
 ExceptionInterceptor exceptionInterceptor)
         throws SQLException

Creates an updatable BLOB that can update in-place

Throws:

SQLException

Method Details

setBinaryStream

public OutputStream setBinaryStream(long indexToWriteAt)
                             throws SQLException

Specified by:

setBinaryStream in interface Blob

Throws:

SQLException

See Also:

• Blob.setBinaryStream(long)

getBinaryStream

public InputStream getBinaryStream()
                            throws SQLException

Retrieves the BLOB designated by this Blob instance as a stream.

Specified by:

getBinaryStream in interface Blob

Returns:

this BLOB represented as a binary stream of bytes.

Throws:

SQLException - if a database error occurs

setBytes

public int setBytes(long writeAt,
 byte[] bytes,
 int offset,
 int length)
             throws SQLException

Specified by:

setBytes in interface Blob

Throws:

SQLException

See Also:

• Blob.setBytes(long, byte[], int, int)

setBytes

public int setBytes(long writeAt,
 byte[] bytes)
             throws SQLException

Specified by:

setBytes in interface Blob

Throws:

SQLException

See Also:

• Blob.setBytes(long, byte[])

getBytes

public byte[] getBytes(long pos,
 int length)
                throws SQLException

Returns as an array of bytes, part or all of the BLOB value that this Blob object designates.

Specified by:

getBytes in interface Blob

Parameters:

pos - where to start the part of the BLOB

length - the length of the part of the BLOB you want returned.

Returns:

the bytes stored in the blob starting at position pos and having a length of length.

Throws:

SQLException - if a database error occurs

length

public long length()
            throws SQLException

Returns the number of bytes in the BLOB value designated by this Blob object.

Specified by:

length in interface Blob

Returns:

the length of this blob

Throws:

SQLException - if a database error occurs

position

public long position(Blob pattern,
 long start)
              throws SQLException

Finds the position of the given pattern in this BLOB.

Specified by:

position in interface Blob

Parameters:

pattern - the pattern to find

start - where to start finding the pattern

Returns:

the position where the pattern is found in the BLOB, -1 if not found

Throws:

SQLException - if a database error occurs

position

public long position(byte[] pattern,
 long start)
              throws SQLException

Specified by:

position in interface Blob

Throws:

SQLException

See Also:

• Blob.position(byte[], long)

truncate

public void truncate(long length)
              throws SQLException

Specified by:

truncate in interface Blob

Throws:

SQLException

See Also:

• Blob.truncate(long)

createGetBytesStatement

PreparedStatement createGetBytesStatement()
                                   throws SQLException

Throws:

SQLException

getBytesInternal

byte[] getBytesInternal(PreparedStatement pStmt,
 long pos,
 int length)
                 throws SQLException

Throws:

SQLException

free

public void free()
          throws SQLException

Specified by:

free in interface Blob

Throws:

SQLException

getBinaryStream

public InputStream getBinaryStream(long pos,
 long length)
                            throws SQLException

Specified by:

getBinaryStream in interface Blob

Throws:

SQLException