|
JavaTM 2 Platform Std. Ed. v1.3 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
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 | |
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(Blob pattern,
long start)
Determines the byte position in the BLOB value
designated by this Blob object at which
pattern begins. |
long |
position(byte[] pattern,
long start)
Determines the byte position at which the specified byte pattern begins within the BLOB
value that this Blob object represents. |
Method Detail |
public long length() throws SQLException
BLOB
value
designated by this Blob
object.BLOB
in bytesSQLException
- if there is an error accessing the
length of the BLOB
public byte[] getBytes(long pos, int length) throws SQLException
BLOB
value that this Blob
object designates. The byte
array contains up to length
consecutive bytes
starting at position pos
.pos
- the ordinal position of the first byte in the
BLOB
value to be extracted; the first byte is at
position 1length
- the number of consecutive bytes to be copiedlength
consecutive bytes from the BLOB
value designated
by this Blob
object, starting with the
byte at position pos
SQLException
- if there is an error accessing the
BLOB
public InputStream getBinaryStream() throws SQLException
BLOB
designated by this
Blob
instance as a stream.BLOB
dataSQLException
- if there is an error accessing the
BLOB
public long position(byte[] pattern, long start) throws SQLException
pattern
begins within the BLOB
value that this Blob
object represents. The
search for pattern
begins at position
start
.pattern
- the byte array for which to searchstart
- the position at which to begin searching; the
first position is 1SQLException
- if there is an error accessing the
BLOB
public long position(Blob pattern, long start) throws SQLException
BLOB
value
designated by this Blob
object at which
pattern
begins. The search begins at position
start
.pattern
- the Blob
object designating
the BLOB
value for which to searchstart
- the position in the BLOB
value
at which to begin searching; the first position is 1SQLException
- if there is an error accessing the
BLOB
|
JavaTM 2 Platform Std. Ed. v1.3 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Java, Java 2D, and JDBC are trademarks or registered trademarks of Sun Microsystems, Inc. in the US and other countries.
Copyright 1993-2000 Sun Microsystems, Inc. 901 San Antonio Road
Palo Alto, California, 94303, U.S.A. All Rights Reserved.