org.datanucleus.store.rdbms.mapping.datastore

Class OracleBlobRDBMSMapping

java.lang.Object

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

org.datanucleus.store.rdbms.mapping.datastore.OracleBlobRDBMSMapping

All Implemented Interfaces:

DatastoreMapping

public class OracleBlobRDBMSMapping
extends AbstractDatastoreMapping

Maps a Field to an Oracle BLOB. Extends the standard JDBC handler so that we can insert an empty BLOB, 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

Modifier	Constructor and Description
	OracleBlobRDBMSMapping(JavaTypeMapping mapping, RDBMSStoreManager storeMgr, Column col) Constructor.
protected	OracleBlobRDBMSMapping(RDBMSStoreManager storeMgr, JavaTypeMapping mapping) Creates a OracleBlobRDBMSMapping

Method Summary

Modifier and Type	Method and Description
String	getInsertionInputParameter() Accessor for the string to put in any retrieval datastore statement for this field.
int	getJDBCType() Method to return the java.sql.Types type that this relates to.
Object	getObject(ResultSet rs, int param) Returns the object to be loaded from the Orale BLOB.
String	getString(ResultSet resultSet, int exprIndex) Obtains a value from resultSet at position specified by exprIndex.
String	getUpdateInputParameter() Accessor for the string to put in any update datastore statements for this field.
boolean	includeInSQLFetchStatement() Whether to include this mapping in a fetch statement.
boolean	insertValuesOnInsert() Accessor for whether this mapping requires values inserting on an INSERT.
static void	updateBlobColumn(org.datanucleus.state.ObjectProvider sm, Table table, DatastoreMapping mapping, byte[] bytes) Convenience method to update the contents of a BLOB column.

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, getTypeInfo, hashCode, includeInFetchStatement, initTypeInfo, isBitBased, isBooleanBased, isDecimalBased, isIntegerBased, isNullable, isStringBased, setBoolean, setByte, setChar, setDouble, setFloat, setInt, setLong, setObject, setShort, setString

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleBlobRDBMSMapping

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

Constructor.

Parameters:

mapping - The Java mapping

storeMgr - Store Manager in use

col - Column

OracleBlobRDBMSMapping

protected OracleBlobRDBMSMapping(RDBMSStoreManager storeMgr,
                                 JavaTypeMapping mapping)

Creates a OracleBlobRDBMSMapping

Parameters:

storeMgr - Store Manager

mapping - The Java mapping

Method Detail

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

See Also:

AbstractDatastoreMapping.getInsertionInputParameter()

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

getObject

public Object getObject(ResultSet rs,
                        int param)

Returns the object to be loaded from the Orale BLOB.

Specified by:

getObject in interface DatastoreMapping

Overrides:

getObject in class AbstractDatastoreMapping

Parameters:

rs - the ResultSet from the query

param - the index in the query

Returns:

the object loaded as a byte[]

Throws:

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

getString

public String getString(ResultSet resultSet,
                        int exprIndex)

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 AbstractDatastoreMapping

Parameters:

resultSet - ResultSet

exprIndex - the position of the value in the result

Returns:

the value

See Also:

AbstractDatastoreMapping.getString(ResultSet, int)

getJDBCType

public int getJDBCType()

Description copied from class: AbstractDatastoreMapping

Method to return the java.sql.Types type that this relates to.

Specified by:

getJDBCType in class AbstractDatastoreMapping

Returns:

The JDBC "type"

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.

See Also:

AbstractDatastoreMapping.getUpdateInputParameter()

includeInSQLFetchStatement

public boolean includeInSQLFetchStatement()

Whether to include this mapping in a fetch statement.

Returns:

Whether to include it when fetching the object

updateBlobColumn

public static void updateBlobColumn(org.datanucleus.state.ObjectProvider sm,
                                    Table table,
                                    DatastoreMapping mapping,
                                    byte[] bytes)

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

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

and then updates the Blob value returned.

Parameters:

sm - ObjectProvider of the object

table - Table storing the BLOB column

mapping - Datastore mapping for the BLOB column

bytes - The bytes to store in the BLOB

Throws:

org.datanucleus.exceptions.NucleusObjectNotFoundException - thrown if an object isnt found

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