|
MySQL Connector/J size='-1'>5.0.8 | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.mysql.jdbc.Blob
public class 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.
Method Summary | |
---|---|
java.io.InputStream |
getBinaryStream()
Retrieves the BLOB designated by this Blob instance as a stream. |
byte[] |
getBytes(long pos,
int length)
Returns as an array of bytes, part or all of the BLOB value that this Blob object designates. |
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 |
streamClosed(byte[] byteData)
|
void |
streamClosed(com.mysql.jdbc.WatchableOutputStream out)
Called when the OutputStream being watched has .close() called |
void |
truncate(long arg0)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public java.io.InputStream getBinaryStream() throws java.sql.SQLException
getBinaryStream
in interface java.sql.Blob
java.sql.SQLException
- if a database error occurspublic 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(byte[] pattern, long start) throws java.sql.SQLException
position
in interface java.sql.Blob
java.sql.SQLException
Blob.position(byte[], long)
public 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 java.io.OutputStream setBinaryStream(long indexToWriteAt) throws java.sql.SQLException
setBinaryStream
in interface java.sql.Blob
java.sql.SQLException
setBinaryStream(long)
public int setBytes(long writeAt, byte[] bytes) throws java.sql.SQLException
setBytes
in interface java.sql.Blob
java.sql.SQLException
setBytes(long, byte[])
public int setBytes(long writeAt, byte[] bytes, int offset, int length) throws java.sql.SQLException
setBytes
in interface java.sql.Blob
java.sql.SQLException
setBytes(long, byte[], int, int)
public void streamClosed(byte[] byteData)
com.mysql.jdbc.OutputStreamWatcher#streamClosed(byte[])
public void streamClosed(com.mysql.jdbc.WatchableOutputStream out)
com.mysql.jdbc.OutputStreamWatcher#streamClosed(byte[])
public void truncate(long arg0) throws java.sql.SQLException
truncate
in interface java.sql.Blob
java.sql.SQLException
truncate(long)
|
MySQL Connector/J size='-1'>5.0.8 | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |