|
|||||||||
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)
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) 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
java.sql.SQLException
public java.io.InputStream getBinaryStream(long pos, long length) throws java.sql.SQLException
java.sql.SQLException
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |