com.mysql.cj.jdbc

Class BlobFromLocator

java.lang.Object

com.mysql.cj.jdbc.BlobFromLocator

All Implemented Interfaces:

java.sql.Blob

public class BlobFromLocator
extends java.lang.Object
implements java.sql.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 and Description
(package private) class	BlobFromLocator.LocatorInputStream

Field Summary

Fields

Modifier and Type	Field and Description
private java.lang.String	blobColumnName
private ResultSetImpl	creatorResultSet The ResultSet that created this BLOB
private ExceptionInterceptor	exceptionInterceptor
private int	numColsInResultSet
private int	numPrimaryKeys
private java.util.List<java.lang.String>	primaryKeyColumns
private java.util.List<java.lang.String>	primaryKeyValues
private java.lang.String	quotedId
private java.lang.String	tableName

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
(package private) java.sql.PreparedStatement	createGetBytesStatement()
void	free()
java.io.InputStream	getBinaryStream()
java.io.InputStream	getBinaryStream(long pos, long length)
byte[]	getBytes(long pos, int length)
(package private) byte[]	getBytesInternal(java.sql.PreparedStatement pStmt, long pos, int length)
long	length()
private void	notEnoughInformationInQuery()
long	position(java.sql.Blob pattern, long start)
long	position(byte[] pattern, long start)
java.io.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 java.lang.Object

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

Field Detail

primaryKeyColumns

private java.util.List<java.lang.String> primaryKeyColumns

primaryKeyValues

private java.util.List<java.lang.String> primaryKeyValues

creatorResultSet

private ResultSetImpl creatorResultSet

The ResultSet that created this BLOB

blobColumnName

private java.lang.String blobColumnName

tableName

private java.lang.String tableName

numColsInResultSet

private int numColsInResultSet

numPrimaryKeys

private int numPrimaryKeys

quotedId

private java.lang.String quotedId

exceptionInterceptor

private ExceptionInterceptor exceptionInterceptor

Constructor Detail

BlobFromLocator

public BlobFromLocator(ResultSetImpl creatorResultSetToSet,
                       int blobColumnIndex,
                       ExceptionInterceptor exceptionInterceptor)
                throws java.sql.SQLException

Creates an updatable BLOB that can update in-place

Parameters:

creatorResultSetToSet - result set

blobColumnIndex - column index

exceptionInterceptor - exception interceptor

Throws:

java.sql.SQLException - if an error occurs

Method Detail

notEnoughInformationInQuery

private void notEnoughInformationInQuery()
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

setBinaryStream

public java.io.OutputStream setBinaryStream(long indexToWriteAt)
                                     throws java.sql.SQLException

Specified by:

setBinaryStream in interface java.sql.Blob

Throws:

java.sql.SQLException

getBinaryStream

public java.io.InputStream getBinaryStream()
                                    throws java.sql.SQLException

Specified by:

getBinaryStream in interface java.sql.Blob

Throws:

java.sql.SQLException

setBytes

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

Specified by:

setBytes in interface java.sql.Blob

Throws:

java.sql.SQLException

setBytes

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

Specified by:

setBytes in interface java.sql.Blob

Throws:

java.sql.SQLException

getBytes

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

Specified by:

getBytes in interface java.sql.Blob

Throws:

java.sql.SQLException

length

public long length()
            throws java.sql.SQLException

Specified by:

length in interface java.sql.Blob

Throws:

java.sql.SQLException

position

public long position(java.sql.Blob pattern,
                     long start)
              throws java.sql.SQLException

Specified by:

position in interface java.sql.Blob

Throws:

java.sql.SQLException

position

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

Specified by:

position in interface java.sql.Blob

Throws:

java.sql.SQLException

truncate

public void truncate(long length)
              throws java.sql.SQLException

Specified by:

truncate in interface java.sql.Blob

Throws:

java.sql.SQLException

createGetBytesStatement

java.sql.PreparedStatement createGetBytesStatement()
                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getBytesInternal

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

Throws:

java.sql.SQLException

free

public void free()
          throws java.sql.SQLException

Specified by:

free in interface java.sql.Blob

Throws:

java.sql.SQLException

getBinaryStream

public java.io.InputStream getBinaryStream(long pos,
                                           long length)
                                    throws java.sql.SQLException

Specified by:

getBinaryStream in interface java.sql.Blob

Throws:

java.sql.SQLException