WlsOracleJDriverDatabase Class

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