|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.mysql.jdbc.BlobFromLocator
public class BlobFromLocator
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 | |
---|---|
(package private) class |
BlobFromLocator.LocatorInputStream
|
Constructor Summary | |
---|---|
BlobFromLocator(ResultSetImpl creatorResultSetToSet,
int blobColumnIndex,
ExceptionInterceptor exceptionInterceptor)
Creates an updatable BLOB that can update in-place |
Method Summary | |
---|---|
(package private) java.sql.PreparedStatement |
createGetBytesStatement()
|
void |
free()
|
java.io.InputStream |
getBinaryStream()
Retrieves the BLOB designated by this Blob instance as a stream. |
java.io.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(java.sql.PreparedStatement pStmt,
long pos,
int length)
|
long |
length()
Returns the number of bytes in the BLOB value designated by this Blob object. |
long |
position(java.sql.Blob pattern,
long start)
Finds the position of the given pattern in this BLOB. |
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 |
Constructor Detail |
---|
BlobFromLocator(ResultSetImpl creatorResultSetToSet, int blobColumnIndex, ExceptionInterceptor exceptionInterceptor) throws java.sql.SQLException
java.sql.SQLException
Method Detail |
---|
public java.io.OutputStream setBinaryStream(long indexToWriteAt) throws java.sql.SQLException
setBinaryStream
in interface java.sql.Blob
java.sql.SQLException
Blob.setBinaryStream(long)
public java.io.InputStream getBinaryStream() throws java.sql.SQLException
getBinaryStream
in interface java.sql.Blob
java.sql.SQLException
- if a database error occurspublic int setBytes(long writeAt, byte[] bytes, int offset, int length) throws java.sql.SQLException
setBytes
in interface java.sql.Blob
java.sql.SQLException
Blob.setBytes(long, byte[], int, int)
public int setBytes(long writeAt, byte[] bytes) throws java.sql.SQLException
setBytes
in interface java.sql.Blob
java.sql.SQLException
Blob.setBytes(long, byte[])
public byte[] getBytes(long pos, int length) throws java.sql.SQLException
getBytes
in interface java.sql.Blob
pos
- where to start the part of the BLOBlength
- the length of the part of the BLOB you want returned.
pos
and having a length of length
.
java.sql.SQLException
- if a database error occurspublic long length() throws java.sql.SQLException
length
in interface java.sql.Blob
java.sql.SQLException
- if a database error occurspublic long position(java.sql.Blob pattern, long start) throws java.sql.SQLException
position
in interface java.sql.Blob
pattern
- the pattern to findstart
- where to start finding the pattern
java.sql.SQLException
- if a database error occurspublic long position(byte[] pattern, long start) throws java.sql.SQLException
position
in interface java.sql.Blob
java.sql.SQLException
Blob.position(byte[], long)
public void truncate(long length) throws java.sql.SQLException
truncate
in interface java.sql.Blob
java.sql.SQLException
Blob.truncate(long)
java.sql.PreparedStatement createGetBytesStatement() throws java.sql.SQLException
java.sql.SQLException
byte[] getBytesInternal(java.sql.PreparedStatement pStmt, long pos, int length) throws java.sql.SQLException
java.sql.SQLException
public void free() throws java.sql.SQLException
free
in interface java.sql.Blob
java.sql.SQLException
public java.io.InputStream getBinaryStream(long pos, long length) throws java.sql.SQLException
getBinaryStream
in interface java.sql.Blob
java.sql.SQLException
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |