BLOB (Oracle Database JDBC Java API Reference)

java.lang.Object
- oracle.sql.Datum
- - oracle.sql.DatumWithConnection
  - - oracle.sql.BLOB

All Implemented Interfaces:

java.io.Serializable, java.sql.Blob, oracle.jdbc.internal.ACProxyable, oracle.jdbc.internal.OracleConcreteProxy, oracle.jdbc.internal.OracleDatumWithConnection, oracle.jdbc.internal.OracleLargeObject<byte[]>, OracleBlob

Deprecated.
Use java.sql.Blob interface for declaration instead of using concrete class oracle.sql.BLOB.
```
public class BLOB
extends DatumWithConnection
implements oracle.jdbc.internal.OracleBlob, oracle.jdbc.internal.OracleConcreteProxy
```
This class implements the java.sql.Blob interface in JDBC 2.0. It provides the native implementation of the Blob methods. Use Blob interface for declaration instead of using concrete class oracle.sql.BLOB. java.sql.Blob has methods declared for all opertions. For Oracle specific methods use the interface OracleBlob.
Obtaining Blob from ResultSet
java.sql.Blob blob = resultSet.getBlob(...);
Creating temporary Blob from factory method, java.sql.Connection#crateBlob()
java.sql.Blob blob = connection.createBlob();

See Also:

Blob, OracleBlob, Connection.createBlob(), Serialized Form

Nested Class Summary
- Nested classes/interfaces inherited from interface oracle.jdbc.internal.OracleLargeObject
  oracle.jdbc.internal.OracleLargeObject.ArrayPrefetchData<T>, oracle.jdbc.internal.OracleLargeObject.PrefetchData<T>

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`DURATION_CALL` Deprecated.
`static int`	`DURATION_INVALID` Deprecated.
`static int`	`DURATION_SESSION` Deprecated.
`static int`	`MAX_CHUNK_SIZE` Deprecated. 1907584: Changed MAX_CHUNK_SIZE from 32512 to 32768.
`static int`	`MODE_READONLY` Deprecated.
`static int`	`MODE_READWRITE` Deprecated.
`static int`	`OLD_WRONG_DURATION_CALL` Deprecated.
`static int`	`OLD_WRONG_DURATION_SESSION` Deprecated.
`protected oracle.jdbc.driver.OracleBlob`	`target` Deprecated.

Fields inherited from class oracle.sql.DatumWithConnection
targetDatumWithConnection

Fields inherited from class oracle.sql.Datum
ojiOracleDatumWithConnection, targetDatum

Constructor Summary

Constructors
Modifier Constructor and Description

protected BLOB()
Deprecated.

protected BLOB(oracle.jdbc.driver.OracleBlob b)
Deprecated.

Call from empty lob static method

Constructors
Modifier	Constructor and Description
`protected`	`BLOB()` Deprecated.
`protected`	`BLOB(oracle.jdbc.driver.OracleBlob b)` Deprecated. Call from empty lob static method

Method Summary

All Methods Static Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`boolean`	`canReadBasicLobDataInLocator()` Deprecated. Can the lob data be read directly from the locator?
`void`	`closeLob()` Deprecated. Close a previously opened BLOB.
`static BLOB`	`createTemporary(java.sql.Connection conn, boolean cache, int _duration)` Deprecated. Create a temporary blob.
`static BLOB`	`empty_lob()` Deprecated. use getEmptyBLOB instead
`void`	`free()` Deprecated. Free the resources the blob holds.
`void`	`freeLOB()` Deprecated.
`void`	`freeTemporary()` Deprecated. Free the contents and the locator of the temporary blob.
`static void`	`freeTemporary(BLOB temp_lob)` Deprecated. Free the contents and the locator of the temporary blob.
`java.io.OutputStream`	`getBinaryOutputStream()` Deprecated. This method is deprecated. Use setBinaryStream(1L).
`java.io.OutputStream`	`getBinaryOutputStream(long pos)` Deprecated. This method is deprecated -- use setBinaryStream
`java.io.InputStream`	`getBinaryStream()` Deprecated. Implements the Blob interface function.
`java.io.InputStream`	`getBinaryStream(boolean isInternal)` Deprecated. Implements the Blob interface function.
`java.io.InputStream`	`getBinaryStream(long pos)` Deprecated. Read from the BLOB as a stream at the requested position.
`java.io.InputStream`	`getBinaryStream(long pos, long length)` Deprecated. Return a binary stream beginning at the specified position and ofthe specified length.
`int`	`getBufferSize()` Deprecated. Oracle extension.
`byte[]`	`getBytes(long pos, int length)` Deprecated. Implements the Blob interface function.
`int`	`getBytes(long pos, int length, byte[] buf)` Deprecated. Oracle extension.
`int`	`getChunkSize()` Deprecated. Oracle extension.
`short`	`getDuration()` Deprecated. return the duration of a temporary LOB
`static short`	`getDuration(BLOB lob)` Deprecated. return the duration of a temporary LOB
`static BLOB`	`getEmptyBLOB()` Deprecated. Return a empty lob.
`java.sql.Connection`	`getJavaSqlConnection()` Deprecated. Oracle extension Return the java.sql.Connection associated with the receiver.
`oracle.jdbc.internal.OracleLargeObject.PrefetchData<byte[]>`	`getPrefetchData()` Deprecated.
`int`	`getPrefetchedDataSize()` Deprecated.
`oracle.jdbc.driver.OracleBlob`	`getTarget()` Deprecated.
`boolean`	`isConvertibleTo(java.lang.Class<?> jClass)` Deprecated. Oracle extension.
`boolean`	`isEmptyLob()` Deprecated. Return true if the lob locator points to a empty blob.
`boolean`	`isFree()` Deprecated.
`boolean`	`isOpenLob()` Deprecated. Check whether the BLOB is opened.
`boolean`	`isSecureFile()` Deprecated. Returns `true` if this is a SecureFile (LOBs with the STORE AS SECUREFILE option, which were introduced in Oracle Database 11g Release 1).
`boolean`	`isTemporary()` Deprecated. Return true if the lob locator points to a temporary blob.
`static boolean`	`isTemporary(BLOB lob)` Deprecated. Return true if the lob locator points to a temporary blob.
`long`	`length()` Deprecated. Implements the Blob interface function.
`void`	`open(int mode)` Deprecated. The name of this method is anticipated to conflict with a future version of the JDBC Specification. This method will be removed in a future version of the Oracle JDBC Driver. Any calls to this method should be replaced with a call to `openLob(int)`, which provides the exact same behavior.
`void`	`openLob(int mode)` Deprecated. Open a BLOB in the indicated mode.
`void`	`openLob(LargeObjectAccessMode mode)` Deprecated. Public method using enum instead of int
`long`	`position(java.sql.Blob pattern, long start)` Deprecated. Implements the Blob interface function.
`long`	`position(byte[] pattern, long start)` Deprecated. Implements the Blob interface function.
`int`	`putBytes(long pos, byte[] bytes)` Deprecated. This method is deprecated -- use setBytes
`int`	`putBytes(long pos, byte[] bytes, int length)` Deprecated. This method is deprecated -- use setBytes
`java.io.OutputStream`	`setBinaryStream(long pos)` Deprecated. JDBC 3.0 Retrieves a stream that can be used to write to the `BLOB` value that this `Blob` object represents.
`void`	`setBytes(byte[] locator)` Deprecated. Sets datum value using a byte array.
`int`	`setBytes(long pos, byte[] bytes)` Deprecated. JDBC 3.0 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)` Deprecated. JDBC 3.0 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.
`void`	`setPrefetchData(oracle.jdbc.internal.OracleLargeObject.PrefetchData<byte[]> prefetchData)` Deprecated.
`java.lang.Object`	`toJdbc()` Deprecated. Oracle extension.
`java.sql.SQLXML`	`toSQLXML()` Deprecated. Returns an object which impements java.sql.SQLXML with content take from this Clob.
`java.sql.SQLXML`	`toSQLXML(int csid)` Deprecated. Returns an object which impements java.sql.SQLXML with content taken from this Blob.
`void`	`trim(long newlen)` Deprecated. This method id deprecated -- use truncate
`void`	`truncate(long len)` Deprecated. JDBC 3.0 Truncates the `BLOB` value that this `Blob` object represents to be `len` bytes in length.

Methods inherited from class oracle.sql.DatumWithConnection
assertNotNull, assertNotNull, getConnection, getConnectionDuringExceptionHandling, getOracleConnection

Methods inherited from class oracle.sql.Datum
bigDecimalValue, booleanValue, bytesEqual, bytesHashCode, byteValue, compareBytes, dateValue, doubleValue, equals, floatValue, getBytes, getLength, getStream, intValue, isNull, longValue, setShareBytes, shareBytes, stringValue, stringValue, timestampValue, timestampValue, timeValue, timeValue, toClass

Methods inherited from class java.lang.Object
clone, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface oracle.jdbc.internal.OracleDatumWithConnection
bigDecimalValue, booleanValue, byteValue, dateValue, doubleValue, floatValue, getBytes, getConnection, getInternalConnection, getLength, getOracleConnection, getStream, intValue, longValue, setPhysicalConnectionOf, setShareBytes, shareBytes, stringValue, stringValue, timestampValue, timestampValue, timeValue, timeValue

Methods inherited from interface oracle.jdbc.OracleBlob
close, isOpen, open

- Field Detail
  - MAX_CHUNK_SIZE
```
public static final int MAX_CHUNK_SIZE
```
    Deprecated.
    
    1907584: Changed MAX_CHUNK_SIZE from 32512 to 32768. This was done to accommodate larger DB_BLOCK_SIZEs. Using 32512 would cause getBufferSize() to return 32512 for DB_BLOCK_SIZEs from 8192-32768. For these block sizes getBufferSize() should return getChunkSize(); not 32512. By using 32768 as the MAX_CHUNK_SIZE, getBufferSize() returns the correct chunk size. Please see bug for details.
    
    See Also:
    
    Constant Field Values
  - DURATION_INVALID
```
public static final int DURATION_INVALID
```
    Deprecated.
    
    See Also:
    
    Constant Field Values
  - DURATION_SESSION
```
public static final int DURATION_SESSION
```
    Deprecated.
    
    See Also:
    
    Constant Field Values
  - DURATION_CALL
```
public static final int DURATION_CALL
```
    Deprecated.
    
    See Also:
    
    Constant Field Values
  - OLD_WRONG_DURATION_SESSION
```
public static final int OLD_WRONG_DURATION_SESSION
```
    Deprecated.
    
    See Also:
    
    Constant Field Values
  - OLD_WRONG_DURATION_CALL
```
public static final int OLD_WRONG_DURATION_CALL
```
    Deprecated.
    
    See Also:
    
    Constant Field Values
  - MODE_READONLY
```
public static final int MODE_READONLY
```
    Deprecated.
    
    See Also:
    
    Constant Field Values
  - MODE_READWRITE
```
public static final int MODE_READWRITE
```
    Deprecated.
    
    See Also:
    
    Constant Field Values
  - target
```
protected oracle.jdbc.driver.OracleBlob target
```
    Deprecated.
- Constructor Detail
  - BLOB
```
protected BLOB()
```
    Deprecated.
  - BLOB
```
protected BLOB(oracle.jdbc.driver.OracleBlob b)
```
    Deprecated.
    
    Call from empty lob static method
- Method Detail
  - getTarget
```
public oracle.jdbc.driver.OracleBlob getTarget()
```
    Deprecated.
  - length
```
public long length()
            throws java.sql.SQLException
```
    Deprecated.
    
    Implements the Blob interface function. Return the length of the Binary Large OBject in bytes.
    
    Specified by:
    
    length in interface java.sql.Blob
    
    Returns:
    
    length of the BLOB in bytes
    
    Throws:
    
    java.sql.SQLException
  - getBytes
```
public byte[] getBytes(long pos,
                       int length)
                throws java.sql.SQLException
```
    Deprecated.
    
    Implements the Blob interface function. Return a copy of the contents of the BLOB at the requested position.
    
    Specified by:
    
    getBytes in interface java.sql.Blob
    
    Parameters:
    
    pos - is the first byte of the blob to be extracted.
    
    length - is the number of consecutive bytes to be copied.
    
    Returns:
    
    a byte array containing a portion of the BLOB If the pos argument is larger than the length of the data the result is null. If the pos argument is less than the length of the data, but the sum of pos argument and the length is greater than the length of the data, the result will be smaller than the length requested. If the length is zero return and empty array
    
    Throws:
    
    java.sql.SQLException
  - getBinaryStream
```
public java.io.InputStream getBinaryStream()
                                    throws java.sql.SQLException
```
    Deprecated.
    
    Implements the Blob interface function. Retrieve the entire BLOB as a stream.
    
    Specified by:
    
    getBinaryStream in interface java.sql.Blob
    
    Returns:
    
    a stream containing the BLOB data
    
    Throws:
    
    java.sql.SQLException
  - getBinaryStream
```
public java.io.InputStream getBinaryStream(boolean isInternal)
                                    throws java.sql.SQLException
```
    Deprecated.
    
    Implements the Blob interface function. Retrieve the entire BLOB as a stream.
    
    Returns:
    
    a stream containing the BLOB data
    
    Throws:
    
    java.sql.SQLException
  - position
```
public long position(byte[] pattern,
                     long start)
              throws java.sql.SQLException
```
    Deprecated.
    
    Implements the Blob interface function. Determine the byte position at which the given byte pattern
    
    Specified by:
    
    position in interface java.sql.Blob
    
    Parameters:
    
    pattern - is the pattern to search for.
    
    start - is the position at which to begin searching.
    
    Returns:
    
    the position at which the pattern appears, else -1.
    
    Throws:
    
    java.sql.SQLException
  - position
```
public long position(java.sql.Blob pattern,
                     long start)
              throws java.sql.SQLException
```
    Deprecated.
    
    Implements the Blob interface function. Determine the byte position at which the given pattern
    
    Specified by:
    
    position in interface java.sql.Blob
    
    Parameters:
    
    pattern - is the pattern to search for.
    
    start - is the position at which to begin searching.
    
    Returns:
    
    the position at which the pattern appears, else -1.
    
    Throws:
    
    java.sql.SQLException
  - getBytes
```
public int getBytes(long pos,
                    int length,
                    byte[] buf)
             throws java.sql.SQLException
```
    Deprecated.
    
    Oracle extension. Copy the contents of the BLOB at the requested position to suppied buffer.
    
    Specified by:
    
    getBytes in interface OracleBlob
    
    Parameters:
    
    pos - is the first byte of the blob to be extracted.
    
    length - is the number of consecutive bytes to be copied.
    
    buf - is the buffer to had the extracted bytes.
    
    Returns:
    
    a byte array containing a portion of the BLOB
    
    Throws:
    
    java.sql.SQLException
  - putBytes
```
public int putBytes(long pos,
                    byte[] bytes)
             throws java.sql.SQLException
```
    Deprecated. This method is deprecated -- use setBytes
    
    Oracle extension. Put data to the BLOB at the requested position.
    
    Parameters:
    
    pos - is the position data to be put.
    
    bytes - is the data to be written into BLOB.
    
    Returns:
    
    the number of bytes actually written.
    
    Throws:
    
    java.sql.SQLException
  - putBytes
```
public int putBytes(long pos,
                    byte[] bytes,
                    int length)
             throws java.sql.SQLException
```
    Deprecated. This method is deprecated -- use setBytes
    
    Oracle extension. Put data to the BLOB at the requested position.
    
    Parameters:
    
    pos - is the position data to be put.
    
    bytes - is the data to be written into BLOB.
    
    length - is the length of the data to be written into BLOB.
    
    Returns:
    
    the number of bytes actually written.
    
    Throws:
    
    java.sql.SQLException
  - getBinaryOutputStream
```
public java.io.OutputStream getBinaryOutputStream()
                                           throws java.sql.SQLException
```
    Deprecated. This method is deprecated. Use setBinaryStream(1L).
    
    Oracle extension. Write to the BLOB from a stream.
    
    Returns:
    
    a output stream to write data to the BLOB
    
    Throws:
    
    java.sql.SQLException
  - getChunkSize
```
public int getChunkSize()
                 throws java.sql.SQLException
```
    Deprecated.
    
    Oracle extension. Get database LOB storage chunk size in database.
    
    Returns:
    
    size in bytes
    
    Throws:
    
    java.sql.SQLException
  - getBufferSize
```
public int getBufferSize()
                  throws java.sql.SQLException
```
    Deprecated.
    
    Oracle extension. Get ideal LOB db access buffer size.
    
    Returns:
    
    size in bytes
    
    Throws:
    
    java.sql.SQLException
  - empty_lob
```
public static BLOB empty_lob()
                      throws java.sql.SQLException
```
    Deprecated. use getEmptyBLOB instead
    
    Return a empty lob. An empty lob is used initialize a LOB column/attribute. Note: an empty lob can not be read or written
    
    Returns:
    
    a empty lob
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    8.1.7
  - getEmptyBLOB
```
public static BLOB getEmptyBLOB()
                         throws java.sql.SQLException
```
    Deprecated.
    
    Return a empty lob. An empty lob is used initialize a BLOB column/attribute. Note: an empty lob can not be read or written
    
    Returns:
    
    a empty lob
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    10.2
  - isEmptyLob
```
public boolean isEmptyLob()
                   throws java.sql.SQLException
```
    Deprecated.
    
    Return true if the lob locator points to a empty blob. False if it does not. This method supports only Blobs that are not returned from the database. For Blobs returned from the database, use length(), i.e. check for zero length.
    
    Specified by:
    
    isEmptyLob in interface OracleBlob
    
    Returns:
    
    true if the lob locator points to a empty blob. False if it does not.
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    8.1.7
  - isSecureFile
```
public boolean isSecureFile()
                     throws java.sql.SQLException
```
    Deprecated.
    
    Returns true if this is a SecureFile (LOBs with the STORE AS SECUREFILE option, which were introduced in Oracle Database 11g Release 1).
    
    Specified by:
    
    isSecureFile in interface OracleBlob
    
    Returns:
    
    true if this is a SecureFile and false otherwise.
    
    Throws:
    
    java.sql.SQLException
  - getBinaryOutputStream
```
public java.io.OutputStream getBinaryOutputStream(long pos)
                                           throws java.sql.SQLException
```
    Deprecated. This method is deprecated -- use setBinaryStream
    
    Write to the BLOB from a stream at the requested position.
    
    Parameters:
    
    pos - is the position data to be put.
    
    Returns:
    
    a output stream to write data to the BLOB
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    8.2.0
  - getBinaryStream
```
public java.io.InputStream getBinaryStream(long pos)
                                    throws java.sql.SQLException
```
    Deprecated.
    
    Read from the BLOB as a stream at the requested position.
    
    Specified by:
    
    getBinaryStream in interface OracleBlob
    
    Parameters:
    
    pos - is the position data to be read, should be greater than 0.
    
    Returns:
    
    a input stream to read data from the BLOB
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    8.2.0
  - trim
```
public void trim(long newlen)
          throws java.sql.SQLException
```
    Deprecated. This method id deprecated -- use truncate
    
    Trim the value of the BLOB to the length you specify in the newlen parameter.
    
    Parameters:
    
    newlen - the new length of the BLOB.
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    8.2.0
  - createTemporary
```
public static BLOB createTemporary(java.sql.Connection conn,
                                   boolean cache,
                                   int _duration)
                            throws java.sql.SQLException
```
    Deprecated.
    
    Create a temporary blob.
    
    Parameters:
    
    cache - Specifies if LOB should be read into buffer cache or not.
    
    _duration - The duration of the temporary LOB. The following are valid values: DURATION_SESSION, DURATION_CALL.
    
    Returns:
    
    A temporary blob.
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    8.2.0
  - freeTemporary
```
public static void freeTemporary(BLOB temp_lob)
                          throws java.sql.SQLException
```
    Deprecated.
    
    Free the contents and the locator of the temporary blob.
    
    Parameters:
    
    temp_lob - A temporary blob to be freeed.
    
    Throws:
    
    java.sql.SQLException - if temp_lob is a permanent lob or temp_lob has already been freed.
    
    Since:
    
    8.2.0
  - isTemporary
```
public static boolean isTemporary(BLOB lob)
                           throws java.sql.SQLException
```
    Deprecated.
    
    Return true if the lob locator points to a temporary blob. False if it does not.
    
    Parameters:
    
    lob - the blob to test.
    
    Returns:
    
    true if the lob locator points to a temporary blob. False if it does not.
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    8.2.0
  - getDuration
```
public static short getDuration(BLOB lob)
                         throws java.sql.SQLException
```
    Deprecated.
    
    return the duration of a temporary LOB
    
    Returns:
    
    the duration of a temporary LOB
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    18.1
  - freeTemporary
```
public void freeTemporary()
                   throws java.sql.SQLException
```
    Deprecated.
    
    Free the contents and the locator of the temporary blob.
    
    Specified by:
    
    freeTemporary in interface oracle.jdbc.internal.OracleLargeObject<byte[]>
    
    Throws:
    
    java.sql.SQLException - if self is a permanent lob or self has already been freed.
    
    Since:
    
    8.2.0
  - isTemporary
```
public boolean isTemporary()
                    throws java.sql.SQLException
```
    Deprecated.
    
    Return true if the lob locator points to a temporary blob. False if it does not.
    
    Specified by:
    
    isTemporary in interface oracle.jdbc.internal.OracleLargeObject<byte[]>
    
    Specified by:
    
    isTemporary in interface OracleBlob
    
    Returns:
    
    true if the lob locator points to a temporary blob. False if it does not.
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    8.2.0
  - getDuration
```
public short getDuration()
                  throws java.sql.SQLException
```
    Deprecated.
    
    return the duration of a temporary LOB
    
    Specified by:
    
    getDuration in interface oracle.jdbc.internal.OracleLargeObject<byte[]>
    
    Returns:
    
    the duration of a temporary LOB
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    18.1
  - openLob
```
public void openLob(LargeObjectAccessMode mode)
             throws java.sql.SQLException
```
    Deprecated.
    
    Public method using enum instead of int
    
    Specified by:
    
    openLob in interface OracleBlob
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    23.5
  - open
```
@Deprecated
public void open(int mode)
                      throws java.sql.SQLException
```
    Deprecated. The name of this method is anticipated to conflict with a future version of the JDBC Specification. This method will be removed in a future version of the Oracle JDBC Driver. Any calls to this method should be replaced with a call to openLob(int), which provides the exact same behavior.
    
    Open a BLOB in the indicated mode. Valid modes include MODE_READONLY, and MODE_READWRITE. It is an error to open the same LOB twice.
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    8.2.0
  - openLob
```
public void openLob(int mode)
             throws java.sql.SQLException
```
    Deprecated.
    
    Open a BLOB in the indicated mode. Valid modes include MODE_READONLY, and MODE_READWRITE. It is an error to open the same LOB twice.
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    23.5
  - closeLob
```
public void closeLob()
              throws java.sql.SQLException
```
    Deprecated.
    
    Close a previously opened BLOB.
    
    Specified by:
    
    closeLob in interface OracleBlob
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    23.5
  - isOpenLob
```
public boolean isOpenLob()
                  throws java.sql.SQLException
```
    Deprecated.
    
    Check whether the BLOB is opened.
    
    Specified by:
    
    isOpenLob in interface OracleBlob
    
    Returns:
    
    true if the LOB is opened.
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    23.5
  - setBytes
```
public int setBytes(long pos,
                    byte[] bytes)
             throws java.sql.SQLException
```
    Deprecated.
    
    JDBC 3.0 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.
    
    Specified by:
    
    setBytes in interface java.sql.Blob
    
    Parameters:
    
    pos - the position in the BLOB object at which to start writing
    
    bytes - the array of bytes to be written to the BLOB value that this Blob object represents
    
    Returns:
    
    the number of bytes written
    
    Throws:
    
    java.sql.SQLException - if there is an error accessing the BLOB value
    
    Since:
    
    9.0.2
  - setBytes
```
public int setBytes(long pos,
                    byte[] bytes,
                    int offset,
                    int len)
             throws java.sql.SQLException
```
    Deprecated.
    
    JDBC 3.0 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.
    
    Specified by:
    
    setBytes in interface java.sql.Blob
    
    Parameters:
    
    pos - the position in the BLOB object at which to start writing
    
    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:
    
    java.sql.SQLException - if there is an error accessing the BLOB value
    
    Since:
    
    9.0.2
  - setBinaryStream
```
public java.io.OutputStream setBinaryStream(long pos)
                                     throws java.sql.SQLException
```
    Deprecated.
    
    JDBC 3.0 Retrieves a stream that can be used to write to the BLOB value that this Blob object represents. The stream begins at position pos.
    
    Specified by:
    
    setBinaryStream in interface java.sql.Blob
    
    Parameters:
    
    pos - the position in the BLOB value at which to start writing
    
    Returns:
    
    a java.io.OutputStream object to which data can be written
    
    Throws:
    
    java.sql.SQLException - if there is an error accessing the BLOB value
    
    Since:
    
    9.0.2
    
    See Also:
    
    getBinaryStream()
  - truncate
```
public void truncate(long len)
              throws java.sql.SQLException
```
    Deprecated.
    
    JDBC 3.0 Truncates the BLOB value that this Blob object represents to be len bytes in length.
    
    Specified by:
    
    truncate in interface java.sql.Blob
    
    Parameters:
    
    len - the length, in bytes, to which the BLOB value that this Blob object represents should be truncated
    
    Throws:
    
    java.sql.SQLException - if there is an error accessing the BLOB value
    
    Since:
    
    9.0.2
  - toJdbc
```
public java.lang.Object toJdbc()
                        throws java.sql.SQLException
```
    Deprecated.
    
    Oracle extension. Convert this data object into its default Java object type.
    
    Specified by:
    
    toJdbc in interface oracle.jdbc.internal.OracleDatumWithConnection
    
    Specified by:
    
    toJdbc in class Datum
    
    Returns:
    
    this object.
    
    Throws:
    
    java.sql.SQLException - if any of the lower layer code throws an exception.
  - isConvertibleTo
```
public boolean isConvertibleTo(java.lang.Class<?> jClass)
```
    Deprecated.
    
    Oracle extension. Test whether this data object can be converted to the specified Java data type.
    
    Specified by:
    
    isConvertibleTo in interface oracle.jdbc.internal.OracleDatumWithConnection
    
    Specified by:
    
    isConvertibleTo in class Datum
    
    Parameters:
    
    jClass - specifies the Java data type to test against.
    
    Returns:
    
    true if this data object is convertible to the specified Java class, and a corresponding xxxValue() method is available; otherwise, a false is returned.
  - getJavaSqlConnection
```
public java.sql.Connection getJavaSqlConnection()
                                         throws java.sql.SQLException
```
    Deprecated.
    
    Description copied from class: DatumWithConnection
    
    Oracle extension Return the java.sql.Connection associated with the receiver. Since 9.0.0 not all Oracle JDBC connection objects are assignment compatible with oracle.jdbc.driver.OracleConnection. If the connection is wrapped, return the outermost wrapper.
    
    Specified by:
    
    getJavaSqlConnection in interface oracle.jdbc.internal.OracleDatumWithConnection
    
    Overrides:
    
    getJavaSqlConnection in class DatumWithConnection
    
    Returns:
    
    the connection
    
    Throws:
    
    java.sql.SQLException - if an error occurs
  - setPrefetchData
```
public final void setPrefetchData(oracle.jdbc.internal.OracleLargeObject.PrefetchData<byte[]> prefetchData)
```
    Deprecated.
    
    Specified by:
    
    setPrefetchData in interface oracle.jdbc.internal.OracleLargeObject<byte[]>
  - getPrefetchData
```
public final oracle.jdbc.internal.OracleLargeObject.PrefetchData<byte[]> getPrefetchData()
```
    Deprecated.
    
    Specified by:
    
    getPrefetchData in interface oracle.jdbc.internal.OracleLargeObject<byte[]>
  - getPrefetchedDataSize
```
public final int getPrefetchedDataSize()
```
    Deprecated.
  - canReadBasicLobDataInLocator
```
public boolean canReadBasicLobDataInLocator()
                                     throws java.sql.SQLException
```
    Deprecated.
    
    Can the lob data be read directly from the locator?
    
    Returns:
    
    True if we can; false otherwise.
    
    Throws:
    
    java.sql.SQLException
  - freeLOB
```
public void freeLOB()
             throws java.sql.SQLException
```
    Deprecated.
    
    Specified by:
    
    freeLOB in interface oracle.jdbc.internal.OracleLargeObject<byte[]>
    
    Throws:
    
    java.sql.SQLException
  - free
```
public void free()
          throws java.sql.SQLException
```
    Deprecated.
    
    Free the resources the blob holds.
    
    Specified by:
    
    free in interface java.sql.Blob
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    11.0
  - getBinaryStream
```
public java.io.InputStream getBinaryStream(long pos,
                                           long length)
                                    throws java.sql.SQLException
```
    Deprecated.
    
    Return a binary stream beginning at the specified position and ofthe specified length.
    
    Specified by:
    
    getBinaryStream in interface java.sql.Blob
    
    Parameters:
    
    pos - start position
    
    length - number of bytes in the result
    
    Throws:
    
    java.sql.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.
    
    Since:
    
    11.0
  - setBytes
```
public void setBytes(byte[] locator)
```
    Deprecated.
    
    Description copied from class: Datum
    
    Sets datum value using a byte array. The byte array is copied.
    
    Specified by:
    
    setBytes in interface oracle.jdbc.internal.OracleDatumWithConnection
    
    Overrides:
    
    setBytes in class Datum
    
    Parameters:
    
    locator - byte array used to set the datum value
  - toSQLXML
```
public java.sql.SQLXML toSQLXML()
                         throws java.sql.SQLException
```
    Deprecated.
    
    Returns an object which impements java.sql.SQLXML with content take from this Clob.
    
    Specified by:
    
    toSQLXML in interface OracleBlob
    
    Returns:
    
    the new SQLXML object
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    12.2
  - toSQLXML
```
public java.sql.SQLXML toSQLXML(int csid)
                         throws java.sql.SQLException
```
    Deprecated.
    
    Returns an object which impements java.sql.SQLXML with content taken from this Blob.
    
    Specified by:
    
    toSQLXML in interface OracleBlob
    
    Returns:
    
    the new SQLXML object
    
    Throws:
    
    java.sql.SQLException
    
    Since:
    
    12.2
  - isFree
```
public final boolean isFree()
```
    Deprecated.
    
    Specified by:
    
    isFree in interface oracle.jdbc.internal.OracleLargeObject<byte[]>

Class BLOB

Nested Class Summary

Nested classes/interfaces inherited from interface oracle.jdbc.internal.OracleLargeObject

Field Summary

Fields inherited from class oracle.sql.DatumWithConnection

Fields inherited from class oracle.sql.Datum

Constructor Summary

Method Summary

Methods inherited from class oracle.sql.DatumWithConnection

Methods inherited from class oracle.sql.Datum

Methods inherited from class java.lang.Object

Methods inherited from interface oracle.jdbc.internal.OracleDatumWithConnection

Methods inherited from interface oracle.jdbc.OracleBlob

Field Detail

MAX_CHUNK_SIZE

DURATION_INVALID

DURATION_SESSION

DURATION_CALL

OLD_WRONG_DURATION_SESSION

OLD_WRONG_DURATION_CALL

MODE_READONLY

MODE_READWRITE

target

Constructor Detail

BLOB

BLOB

Method Detail

getTarget

length

getBytes

getBinaryStream

getBinaryStream

position

position

getBytes

putBytes

putBytes

getBinaryOutputStream

getChunkSize

getBufferSize

empty_lob

getEmptyBLOB

isEmptyLob

isSecureFile

getBinaryOutputStream

getBinaryStream

trim

createTemporary

freeTemporary

isTemporary

getDuration

freeTemporary

isTemporary

getDuration

openLob

open

openLob

closeLob

isOpenLob

setBytes

setBytes

setBinaryStream

truncate

toJdbc

isConvertibleTo

getJavaSqlConnection

setPrefetchData

getPrefetchData

getPrefetchedDataSize

canReadBasicLobDataInLocator

freeLOB

free

getBinaryStream

setBytes

toSQLXML

toSQLXML

isFree