# com.bea.p13n.util.jdbc
WlsOracleJDriverDatabase Class

public class WlsOracleJDriverDatabase
extends `OracleDatabase`

Concrete implementation of OracleDatabase that provides support for reading/writing of BLOB/CLOB data. Designed to work with Weblogic JDriver for Oracle JDBC driver.

Related Topics

``OracleDatabase``

Hierarchy
  `Object`
  `GenericDatabase`
  `OracleDatabase`
  `WlsOracleJDriverDatabase`

All Implemented Interfaces
  `Database`

## Constructor Summary

WlsOracleJDriverDatabase(`Connection` connection)

## Method Summary

`public boolean` | `commitConnection`(`Connection` connection)
`public byte[]` | `getBlob`(`ResultSet` rs, int index) Retrieve Blob value and write to an InputStream from a ResultSet.
`public `OutputStream`` | `getBlobLocator`(`Connection` con, `String` tableName, `String` blobColumnName, `String` whereClause) Gets the BlobLocator object inside an Oracle database column.
`public `String`` | `getClob`(`ResultSet` rs, int index) Retrieve CLOB value as a String of Unicode characters.
`public `String`` | `getName`() The name of this GenericDatabase instance.
`public void` | `insertClob`(`ClobKey` key, `String` data) Inserts a CLOB into the database managed tables for CLOB persistence
`public `String`` | `readClob`(`ClobKey` key) Reads a CLOB into the database managed tables for CLOB persistence
`public void` | `removeClob`(`ClobKey` key) Removes a CLOB from the database managed tables for CLOB persistence
`public void` | `updateClob`(`ClobKey` key, `String` data) Updates a CLOB in the database managed tables for CLOB persistence
`public void` | `writeToClob`(`Clob` clob, `String` data) Writes the data from the String into the Clob.

Methods from `com.bea.p13n.util.jdbc.`OracleDatabase``
``getClobLocator`, `getEmptyBlobInitializer`, `getEmptyClobInitializer`, `setClob`, `trimClob`,`

Methods from `com.bea.p13n.util.jdbc.`GenericDatabase``
``accept`, `close`, `close`, `close`, `close`, `close`, `close`, `close`, `close`, `close`, `createPreparedStatement`, `endBlob`, `endClob`, `getApplicationName`, `getClobLocator`, `getClobTableName`, `getConnection`, `getEmptyBlobInitializer`, `getEmptyClobInitializer`, `getProperty`, `printSqlWarning`, `readFromClob`, `readFromClob`, `setClob`, `setClob`, `startBlob`, `startClob`, `writeToClob``

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

Methods from interface `com.bea.p13n.util.jdbc.`Database``
``accept`, `close`, `close`, `close`, `close`, `close`, `close`, `close`, `close`, `close`, `commitConnection`, `endBlob`, `endClob`, `getApplicationName`, `getBlob`, `getBlobLocator`, `getClob`, `getClobLocator`, `getConnection`, `getEmptyBlobInitializer`, `getEmptyClobInitializer`, `getName`, `readFromClob`, `setClob`, `setClob`, `startBlob`, `startClob`, `writeToClob``

## Constructor Detail

### WlsOracleJDriverDatabase

    public WlsOracleJDriverDatabase(Connection connection)

## Method Detail

### commitConnection(Connection) Method

    public boolean commitConnection(Connection connection)
         throws SQLException

Overrides
  `GenericDatabase.commitConnection(Connection)`

#### Exceptions

``SQLException``

### getBlob(ResultSet, int) Method

    public byte[] getBlob(ResultSet rs,
                        int index)
         throws SQLException

Retrieve Blob value and write to an InputStream from a ResultSet.

Overrides
  `GenericDatabase.getBlob(ResultSet, int)`

#### Parameters

rs
  The ResultSet containing the Blob.

index
  The position of the Blob in the ResultSet.

#### Returns

An InputStream containing the binary value of the Blob.

#### Exceptions

``SQLException``
  on an error

### getBlobLocator(Connection, String, String, String) Method

    public OutputStream getBlobLocator(Connection con,
                                       String tableName,
                                       String blobColumnName,
                                       String whereClause)
         throws SQLException

Gets the BlobLocator object inside an Oracle database column.

Overrides
  `GenericDatabase.getBlobLocator(Connection, String, String, String)`

#### Returns

OutputStream An OutputStream pointing to the BlobLocator.

#### Exceptions

``SQLException``
  on an error.

### getClob(ResultSet, int) Method

    public String getClob(ResultSet rs,
                          int index)
         throws SQLException

Retrieve CLOB value as a String of Unicode characters.

Overrides
  `GenericDatabase.getClob(ResultSet, int)`

#### Parameters

rs
  the resultset containing the clob

index
  the position of the clob in the resultset

#### Returns

the value of the CLOB as a String.

#### Exceptions

``SQLException``
  on an error

Related Topics

``WlsOracleJDriverDatabase.getClob(ResultSet, int)``

### getName() Method

    public String getName()

Description copied from `GenericDatabase.getName()`
The name of this GenericDatabase instance.

Overrides
  `GenericDatabase.getName()`

#### Returns

the name of the database

### insertClob(ClobKey, String) Method

    public void insertClob(ClobKey key,
                           String data)
         throws SQLException

Inserts a CLOB into the database managed tables for CLOB persistence

#### Exceptions

``SQLException``

### readClob(ClobKey) Method

    public String readClob(ClobKey key)
         throws SQLException

Reads a CLOB into the database managed tables for CLOB persistence

#### Exceptions

``SQLException``

### removeClob(ClobKey) Method

    public void removeClob(ClobKey key)
         throws SQLException

Removes a CLOB from the database managed tables for CLOB persistence

#### Exceptions

``SQLException``

### updateClob(ClobKey, String) Method

    public void updateClob(ClobKey key,
                           String data)
         throws SQLException

Updates a CLOB in the database managed tables for CLOB persistence

Overrides
  `OracleDatabase.updateClob(ClobKey, String)`

#### Exceptions

``SQLException``

### writeToClob(Clob, String) Method

    public void writeToClob(Clob clob,
                            String data)
         throws SQLException

Writes the data from the String into the Clob.

Overrides
  `GenericDatabase.writeToClob(Clob, String)`

#### Parameters

clob
  The target Clob object.

data
  The data to be converted to a Clob in the form of a String.

#### Exceptions

``SQLException``