WlsOracleThinDatabase Class

com.bea.p13n.util.jdbc
WlsOracleThinDatabase Class

public class WlsOracleThinDatabase

    extends OracleDatabase

Concrete implementation of OracleDatabase that provides support for reading/writing of BLOB/CLOB data. Designed to work with Oracle Thin driver when running inside an application server context.

Related Topics

OracleDatabase


Hierarchy
Object
  GenericDatabase
    OracleDatabase
      WlsOracleThinDatabase
All Implemented Interfaces

Database

Constructor Summary

WlsOracleThinDatabase(Connection connection)

 

Method Summary

public boolean
accept(Connection connection)
Check to see if the connection URL matches the format defined in "accept.driver.url.regex".
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
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

WlsOracleThinDatabase

public WlsOracleThinDatabase(Connection connection)
 

Method Detail

accept(Connection) Method

public boolean accept(Connection connection)
Description copied from GenericDatabase.accept(Connection)
Check to see if the connection URL matches the format defined in "accept.driver.url.regex".

Overrides
GenericDatabase.accept(Connection)

Parameters

connection
The Connection object that contains the URL.

Returns

true if this Database can bind to the supplied connection. Typically the Database will examine the Connection MetaData to determine suitability.

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

WlsOracleThinDatabase.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