org.postgresql.jdbc

Class PgBlob

java.lang.Object

org.postgresql.jdbc.AbstractBlobClob

org.postgresql.jdbc.PgBlob

All Implemented Interfaces:

Blob

public class PgBlob
extends AbstractBlobClob
implements Blob

Field Summary

Fields inherited from class org.postgresql.jdbc.AbstractBlobClob

conn

Constructor Summary

Constructors

Constructor and Description
PgBlob(BaseConnection conn, long oid)

Method Summary

Methods

Modifier and Type	Method and Description
InputStream	getBinaryStream(long pos, long length) Returns an InputStream object that contains a partial Blob value, starting with the byte specified by pos, which is length bytes in length.
int	setBytes(long pos, byte[] bytes) Writes the given array of bytes to the BLOB value that this Blob object represents, starting at position pos, and returns the number of bytes written.
int	setBytes(long pos, byte[] bytes, int offset, int len) Writes all or part of the given byte array to the BLOB value that this Blob object represents and returns the number of bytes written.

Methods inherited from class org.postgresql.jdbc.AbstractBlobClob

addSubLO, assertPosition, assertPosition, checkFreed, free, getBinaryStream, getBytes, getLo, length, position, position, setBinaryStream, truncate

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.sql.Blob

free, getBinaryStream, getBytes, length, position, position, setBinaryStream, truncate

Constructor Detail

PgBlob

public PgBlob(BaseConnection conn,
      long oid)
       throws SQLException

Throws:

SQLException

Method Detail

getBinaryStream

public InputStream getBinaryStream(long pos,
                          long length)
                            throws SQLException

Description copied from interface: java.sql.Blob

Returns an InputStream object that contains a partial Blob value, starting with the byte specified by pos, which is length bytes in length.

Specified by:

getBinaryStream in interface Blob

Parameters:

pos - the offset to the first byte of the partial value to be retrieved. The first byte in the Blob is at position 1

length - the length in bytes of the partial value to be retrieved

Returns:

InputStream through which the partial Blob value can be read.

Throws:

SQLException - if pos is less than 1 or if pos is greater than the number of bytes in the Blob or if pos + length is greater than the number of bytes in the Blob

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

setBytes

public int setBytes(long pos,
           byte[] bytes)
             throws SQLException

Description copied from interface: java.sql.Blob

Writes the given array of bytes to the BLOB value that this Blob object represents, starting at position pos, and returns the number of bytes written. The array of bytes will overwrite the existing bytes in the Blob object starting at the position pos. If the end of the Blob value is reached while writing the array of bytes, then the length of the Blob value will be increased to accomodate the extra bytes.

Note: If the value specified for pos is greater then the length+1 of the BLOB value then the behavior is undefined. Some JDBC drivers may throw a SQLException while other drivers may support this operation.

Specified by:

setBytes in interface Blob

Parameters:

pos - the position in the BLOB object at which to start writing; the first position is 1

bytes - the array of bytes to be written to the BLOB value that this Blob object represents

Returns:

the number of bytes written

Throws:

SQLException - if there is an error accessing the BLOB value or if pos is less than 1

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

See Also:

Blob.getBytes(long, int)

setBytes

public int setBytes(long pos,
           byte[] bytes,
           int offset,
           int len)
             throws SQLException

Description copied from interface: java.sql.Blob

Writes all or part of the given byte array to the BLOB value that this Blob object represents and returns the number of bytes written. Writing starts at position pos in the BLOB value; len bytes from the given byte array are written. The array of bytes will overwrite the existing bytes in the Blob object starting at the position pos. If the end of the Blob value is reached while writing the array of bytes, then the length of the Blob value will be increased to accomodate the extra bytes.

Note: If the value specified for pos is greater then the length+1 of the BLOB value then the behavior is undefined. Some JDBC drivers may throw a SQLException while other drivers may support this operation.

Specified by:

setBytes in interface Blob

Parameters:

pos - the position in the BLOB object at which to start writing; the first position is 1

bytes - the array of bytes to be written to this BLOB object

offset - the offset into the array bytes at which to start reading the bytes to be set

len - the number of bytes to be written to the BLOB value from the array of bytes bytes

Returns:

the number of bytes written

Throws:

SQLException - if there is an error accessing the BLOB value or if pos is less than 1

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

See Also:

Blob.getBytes(long, int)