org.datanucleus.store.rdbms.mapping.datastore

Class OracleClobRDBMSMapping

java.lang.Object

org.datanucleus.store.rdbms.mapping.datastore.AbstractDatastoreMapping

org.datanucleus.store.rdbms.mapping.datastore.LongVarcharRDBMSMapping

org.datanucleus.store.rdbms.mapping.datastore.ClobRDBMSMapping

org.datanucleus.store.rdbms.mapping.datastore.OracleClobRDBMSMapping

All Implemented Interfaces:

DatastoreMapping

public class OracleClobRDBMSMapping
extends ClobRDBMSMapping

Mapping for Oracle CLOB type. Extends the standard JDBC handler so that we can insert an empty CLOB, and then update it (Oracle non-standard behaviour).

Field Summary

Fields inherited from class org.datanucleus.store.rdbms.mapping.datastore.AbstractDatastoreMapping

column, mapping, storeMgr

Constructor Summary

Constructors

Constructor and Description
OracleClobRDBMSMapping(JavaTypeMapping mapping, RDBMSStoreManager storeMgr, Column col)

Method Summary

Methods

Modifier and Type	Method and Description
String	getInsertionInputParameter() Accessor for the string to put in any retrieval datastore statement for this field.
Object	getObject(ResultSet rs, int param) Obtains a value from resultSet at position specified by exprIndex.
String	getString(ResultSet rs, int param) Obtains a value from resultSet at position specified by exprIndex.
SQLTypeInfo	getTypeInfo() Accessor for the type info for this datastore field
String	getUpdateInputParameter() Accessor for the string to put in any update datastore statements for this field.
boolean	includeInFetchStatement() Whether this mapping is included in the fetch statement.
boolean	insertValuesOnInsert() Accessor for whether this mapping requires values inserting on an INSERT.
static void	updateClobColumn(org.datanucleus.state.ObjectProvider op, Table table, DatastoreMapping mapping, String value) Convenience method to update the contents of a CLOB column.

Methods inherited from class org.datanucleus.store.rdbms.mapping.datastore.ClobRDBMSMapping

setObject, setString

Methods inherited from class org.datanucleus.store.rdbms.mapping.datastore.LongVarcharRDBMSMapping

isStringBased

Methods inherited from class org.datanucleus.store.rdbms.mapping.datastore.AbstractDatastoreMapping

equals, failureMessage, failureMessage, failureMessage, getBoolean, getByte, getChar, getColumn, getDatastoreAdapter, getDouble, getFloat, getInt, getJavaTypeMapping, getLong, getShort, hashCode, initTypeInfo, isBitBased, isBooleanBased, isDecimalBased, isIntegerBased, isNullable, setBoolean, setByte, setChar, setDouble, setFloat, setInt, setLong, setShort

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleClobRDBMSMapping

public OracleClobRDBMSMapping(JavaTypeMapping mapping,
                      RDBMSStoreManager storeMgr,
                      Column col)

Method Detail

getTypeInfo

public SQLTypeInfo getTypeInfo()

Description copied from class: ClobRDBMSMapping

Accessor for the type info for this datastore field

Overrides:

getTypeInfo in class ClobRDBMSMapping

Returns:

Type info for the datastore field

getInsertionInputParameter

public String getInsertionInputParameter()

Description copied from class: AbstractDatastoreMapping

Accessor for the string to put in any retrieval datastore statement for this field. In RDBMS, this is typically a ? to be used in JDBC statements.

Overrides:

getInsertionInputParameter in class AbstractDatastoreMapping

Returns:

The input parameter

includeInFetchStatement

public boolean includeInFetchStatement()

Description copied from class: AbstractDatastoreMapping

Whether this mapping is included in the fetch statement.

Overrides:

includeInFetchStatement in class AbstractDatastoreMapping

Returns:

Whether to include in fetch statement

getUpdateInputParameter

public String getUpdateInputParameter()

Description copied from class: AbstractDatastoreMapping

Accessor for the string to put in any update datastore statements for this field. In RDBMS, this is typically a ? to be used in JDBC statements.

Overrides:

getUpdateInputParameter in class AbstractDatastoreMapping

Returns:

The input parameter.

insertValuesOnInsert

public boolean insertValuesOnInsert()

Accessor for whether this mapping requires values inserting on an INSERT.

Overrides:

insertValuesOnInsert in class AbstractDatastoreMapping

Returns:

Whether values are to be inserted into this mapping on an INSERT

getString

public String getString(ResultSet rs,
               int param)

Description copied from interface: DatastoreMapping

Obtains a value from resultSet at position specified by exprIndex.

Specified by:

getString in interface DatastoreMapping

Overrides:

getString in class ClobRDBMSMapping

Parameters:

rs - ResultSet

param - the position of the value in the result

Returns:

the value

getObject

public Object getObject(ResultSet rs,
               int param)

Description copied from interface: DatastoreMapping

Obtains a value from resultSet at position specified by exprIndex.

Specified by:

getObject in interface DatastoreMapping

Overrides:

getObject in class ClobRDBMSMapping

Parameters:

rs - ResultSet

param - the position of the value in the result

Returns:

the value

updateClobColumn

public static void updateClobColumn(org.datanucleus.state.ObjectProvider op,
                    Table table,
                    DatastoreMapping mapping,
                    String value)

Convenience method to update the contents of a CLOB column. Oracle requires that a CLOB is initialised with EMPTY_CLOB() and then you retrieve the column and update its CLOB value. Performs a statement

 SELECT {clobColumn} FROM TABLE WHERE ID=? FOR UPDATE
 

and then updates the Clob value returned.

Parameters:

op - ObjectProvider of the object

table - Table storing the CLOB column

mapping - Datastore mapping for the CLOB column

value - The value to store in the CLOB

Throws:

org.datanucleus.exceptions.NucleusObjectNotFoundException - Thrown if an object is not found

org.datanucleus.exceptions.NucleusDataStoreException - Thrown if an error occurs in datastore communication