Package org.eclipse.persistence.internal.queries

Class DatasourceCallQueryMechanism

java.lang.Object

org.eclipse.persistence.internal.queries.DatabaseQueryMechanism

org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism

All Implemented Interfaces:

Serializable, Cloneable

Direct Known Subclasses:

CallQueryMechanism

public class DatasourceCallQueryMechanism
extends DatabaseQueryMechanism

Purpose: Mechanism used for call queries.

Responsibilities: Executes the appropriate call.

Since:

OracleAS TopLink 10g (10.0.3)

Author:

James Sutherland

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
protected DatasourceCall	call
protected Vector	calls	Normally only a single call is used, however multiple table may require multiple calls on write.

Fields inherited from class org.eclipse.persistence.internal.queries.DatabaseQueryMechanism

query

Constructor Summary

Constructors

Constructor	Description
DatasourceCallQueryMechanism()
DatasourceCallQueryMechanism(DatabaseQuery query)	Initialize the state of the query
DatasourceCallQueryMechanism(DatabaseQuery query, DatasourceCall call)	Initialize the state of the query

Method Summary

Modifier and Type	Method	Description
void	addCall(DatasourceCall call)	Add the call.
DatabaseQueryMechanism	clone(DatabaseQuery queryClone)	Clone the DatasourceCall and Vector<DatasourceCall>.
protected int	computeAndSetItemOffset(ReportQuery query, List<ReportItem> items, int itemOffset)	calculate indexes for given items, given the current Offset
DatabaseCall	cursorSelectAllRows()	Read all rows from the database using a cursored stream.
Integer	deleteAll()	INTERNAL: Delete a collection of objects.
Integer	deleteAllUsingTempTables()	Execute deleteAll using temp tables
Integer	deleteObject()	INTERNAL: Delete an object.
Object	execute()	INTERNAL: Execute a call.
protected Object	executeCall()	Execute the call.
protected Object	executeCall(DatasourceCall databaseCall)	Execute the call.
void	executeDeferredCall(DatasourceCall call)	Execute the call that was deferred to the commit manager.
Object	executeNoSelect()	Execute a non selecting call.
Integer	executeNoSelectCall()	Execute a non selecting call.
Vector	executeSelect()	INTERNAL: Execute a selecting call.
Vector	executeSelectCall()	INTERNAL: Execute a selecting call.
DatabaseCall	generateKeysExecuteNoSelect()	Execute a non selecting call.
DatasourceCall	getCall()	Return the call.
Vector	getCalls()	Normally only a single call is used, however multiple table may require multiple calls on write.
boolean	hasMultipleCalls()	Normally only a single call is used, however multiple table may require multiple calls on write.
void	insertObject()	Insert the object.
boolean	isCallQueryMechanism()	Return true if this is a call query mechanism
void	prepare()	INTERNAL: This is different from 'prepareForExecution' in that this is called on the original query, and the other is called on the copy of the query.
void	prepareCall()	INTERNAL: This is different from 'prepareForExecution' in that this is called on the original query, and the other is called on the copy of the query.
void	prepareCursorSelectAllRows()	Pre-build configure the call.
void	prepareDeleteAll()	Pre-build configure the call.
void	prepareDeleteObject()	Pre-build configure the call.
void	prepareDoesExist(DatabaseField field)	Pre-build configure the call.
void	prepareExecute()	Pre-build configure the call.
void	prepareExecuteNoSelect()	Pre-build configure the call.
void	prepareExecuteSelect()	Pre-build configure the call.
void	prepareInsertObject()	Pre-build configure the call.
protected void	prepareReportQueryItems()	Prepare the report items.
void	prepareReportQuerySelectAllRows()	Pre-build configure the call.
void	prepareReportQuerySubSelect()	Prepare for a sub select using a call.
void	prepareSelectAllRows()	Pre-build configure the call.
void	prepareSelectOneRow()	Pre-build configure the call.
void	prepareUpdateAll()	Pre-build configure the call.
void	prepareUpdateObject()	Pre-build configure the call.
Vector	selectAllReportQueryRows()	Read all rows from the database.
Vector	selectAllRows()	Read all rows from the database.
AbstractRecord	selectOneRow()	Read a single row from the database.
DatabaseCall	selectResultSet()	Read all rows from the database, return ResultSet
AbstractRecord	selectRowForDoesExist(DatabaseField field)	Perform a does exist check
void	setCall(DatasourceCall call)	Set the call.
protected void	setCalls(Vector calls)	Normally only a single call is used, however multiple table may require multiple calls on write.
Integer	updateAll()	Update the rows on the database.
Integer	updateAllUsingTempTables()	Execute updateAll using temp tables
protected void	updateForeignKeyFieldAfterInsert(WriteObjectQuery writeQuery)	Update the foreign key fields when resolving a bi-directional reference in a UOW.
Integer	updateObject()	Update the object.

Methods inherited from class org.eclipse.persistence.internal.queries.DatabaseQueryMechanism

addWriteLockFieldForInsert, buildSelectionCriteria, checkCacheForObject, clone, executeWrite, executeWriteWithChangeSet, getDescriptor, getExecutionSession, getModifyRow, getQuery, getReadObjectQuery, getSelectionCriteria, getSession, getTranslationRow, getWriteObjectQuery, insertObject, insertObjectForWrite, isExpressionQueryMechanism, isJPQLCallQueryMechanism, isQueryByExampleMechanism, isStatementQueryMechanism, performUserDefinedInsert, performUserDefinedUpdate, performUserDefinedWrite, registerObjectInIdentityMap, setQuery, shallowInsertObjectForWrite, unprepare, updateForeignKeyFieldAfterInsert, updateForeignKeyFieldBeforeDelete, updateObjectAndRowWithReturnRow, updateObjectAndRowWithSequenceNumber, updateObjectAndRowWithSequenceNumber, updateObjectForWrite, updateObjectForWriteWithChangeSet

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

call

protected DatasourceCall call

calls

protected Vector calls

Normally only a single call is used, however multiple table may require multiple calls on write.

Constructor Detail

DatasourceCallQueryMechanism

public DatasourceCallQueryMechanism()

DatasourceCallQueryMechanism

public DatasourceCallQueryMechanism(DatabaseQuery query)

Initialize the state of the query

Parameters:

query - - owner of mechanism

DatasourceCallQueryMechanism

public DatasourceCallQueryMechanism(DatabaseQuery query,
                                    DatasourceCall call)

Initialize the state of the query

Parameters:

query - - owner of mechanism

Method Detail

addCall

public void addCall(DatasourceCall call)

Add the call.

clone

public DatabaseQueryMechanism clone(DatabaseQuery queryClone)

Clone the DatasourceCall and Vector<DatasourceCall>.

Overrides:

clone in class DatabaseQueryMechanism

cursorSelectAllRows

public DatabaseCall cursorSelectAllRows()
                                 throws DatabaseException

Read all rows from the database using a cursored stream.

Specified by:

cursorSelectAllRows in class DatabaseQueryMechanism

Throws:

DatabaseException - - an error has occurred on the database

selectResultSet

public DatabaseCall selectResultSet()
                             throws DatabaseException

Read all rows from the database, return ResultSet

Throws:

DatabaseException - - an error has occurred on the database

deleteAll

public Integer deleteAll()
                  throws DatabaseException

INTERNAL: Delete a collection of objects. Assume call is correct.

Specified by:

deleteAll in class DatabaseQueryMechanism

Throws:

DatabaseException - - an error has occurred on the database

deleteAllUsingTempTables

public Integer deleteAllUsingTempTables()
                                 throws DatabaseException

Execute deleteAll using temp tables

Returns:

the row count.

Throws:

DatabaseException - - an error has occurred on the database.

deleteObject

public Integer deleteObject()
                     throws DatabaseException

INTERNAL: Delete an object. Assume call is correct

Specified by:

deleteObject in class DatabaseQueryMechanism

Returns:

the row count.

Throws:

DatabaseException - - an error has occurred on the database

execute

public Object execute()
               throws DatabaseException

INTERNAL: Execute a call.

Specified by:

execute in class DatabaseQueryMechanism

Returns:

true if the first result is a result set and false if it is an update count or there are no results other than through INOUT and OUT parameterts, if any.

Throws:

DatabaseException - - an error has occurred on the database

executeCall

protected Object executeCall()
                      throws DatabaseException

Execute the call. It is assumed the call has been fully prepared.

Throws:

DatabaseException - - an error has occurred on the database.

executeCall

protected Object executeCall(DatasourceCall databaseCall)
                      throws DatabaseException

Execute the call. It is assumed the call has been fully prepared.

Throws:

DatabaseException - - an error has occurred on the database.

executeNoSelect

public Object executeNoSelect()
                       throws DatabaseException

Execute a non selecting call.

Specified by:

executeNoSelect in class DatabaseQueryMechanism

Returns:

Returns either a DatabaseCall or Integer value, depending on if this INSERT call needs to return generated keys

Throws:

DatabaseException - - an error has occurred on the database.

generateKeysExecuteNoSelect

public DatabaseCall generateKeysExecuteNoSelect()
                                         throws DatabaseException

Execute a non selecting call.

Specified by:

generateKeysExecuteNoSelect in class DatabaseQueryMechanism

Returns:

the row count.

Throws:

DatabaseException - - an error has occurred on the database.

executeNoSelectCall

public Integer executeNoSelectCall()
                            throws DatabaseException

Execute a non selecting call.

Returns:

the row count.

Throws:

DatabaseException - - an error has occurred on the database.

executeSelect

public Vector executeSelect()
                     throws DatabaseException

INTERNAL: Execute a selecting call.

Specified by:

executeSelect in class DatabaseQueryMechanism

Throws:

DatabaseException - - an error has occurred on the database

executeSelectCall

public Vector executeSelectCall()
                         throws DatabaseException

INTERNAL: Execute a selecting call.

Throws:

DatabaseException - - an error has occurred on the database

getCall

public DatasourceCall getCall()

Return the call.

getCalls

public Vector getCalls()

Normally only a single call is used, however multiple table may require multiple calls on write. This is lazy initialised to conserve space.

hasMultipleCalls

public boolean hasMultipleCalls()

Normally only a single call is used, however multiple table may require multiple calls on write. This is lazy initialised to conserve space.

insertObject

public void insertObject()
                  throws DatabaseException

Insert the object. Assume the call is correct.

Specified by:

insertObject in class DatabaseQueryMechanism

Throws:

DatabaseException - - an error has occurred on the database

executeDeferredCall

public void executeDeferredCall(DatasourceCall call)

Execute the call that was deferred to the commit manager. This is used to allow multiple table batching and deadlock avoidance.

Overrides:

executeDeferredCall in class DatabaseQueryMechanism

isCallQueryMechanism

public boolean isCallQueryMechanism()

Return true if this is a call query mechanism

Overrides:

isCallQueryMechanism in class DatabaseQueryMechanism

prepare

public void prepare()

INTERNAL: This is different from 'prepareForExecution' in that this is called on the original query, and the other is called on the copy of the query. This query is copied for concurrency so this prepare can only setup things that will apply to any future execution of this query.

Overrides:

prepare in class DatabaseQueryMechanism

prepareCall

public void prepareCall()
                 throws QueryException

INTERNAL: This is different from 'prepareForExecution' in that this is called on the original query, and the other is called on the copy of the query. This query is copied for concurrency so this prepare can only setup things that will apply to any future execution of this query.

Throws:

QueryException

prepareCursorSelectAllRows

public void prepareCursorSelectAllRows()
                                throws QueryException

Pre-build configure the call.

Specified by:

prepareCursorSelectAllRows in class DatabaseQueryMechanism

Throws:

QueryException

prepareDeleteAll

public void prepareDeleteAll()

Pre-build configure the call.

Specified by:

prepareDeleteAll in class DatabaseQueryMechanism

prepareDeleteObject

public void prepareDeleteObject()

Pre-build configure the call.

Specified by:

prepareDeleteObject in class DatabaseQueryMechanism

prepareDoesExist

public void prepareDoesExist(DatabaseField field)

Pre-build configure the call.

Specified by:

prepareDoesExist in class DatabaseQueryMechanism

prepareExecuteNoSelect

public void prepareExecuteNoSelect()

Pre-build configure the call.

Specified by:

prepareExecuteNoSelect in class DatabaseQueryMechanism

prepareExecute

public void prepareExecute()

Pre-build configure the call. This method assumes the query was built using a stored procedure query which is a single call. The return type on the call will already be set and

Specified by:

prepareExecute in class DatabaseQueryMechanism

prepareExecuteSelect

public void prepareExecuteSelect()

Pre-build configure the call.

Specified by:

prepareExecuteSelect in class DatabaseQueryMechanism

prepareInsertObject

public void prepareInsertObject()

Pre-build configure the call.

Specified by:

prepareInsertObject in class DatabaseQueryMechanism

prepareReportQueryItems

protected void prepareReportQueryItems()

Prepare the report items. Indexes of results need to be calculated.

computeAndSetItemOffset

protected int computeAndSetItemOffset(ReportQuery query,
                                      List<ReportItem> items,
                                      int itemOffset)

calculate indexes for given items, given the current Offset

prepareReportQuerySelectAllRows

public void prepareReportQuerySelectAllRows()

Pre-build configure the call.

Specified by:

prepareReportQuerySelectAllRows in class DatabaseQueryMechanism

prepareReportQuerySubSelect

public void prepareReportQuerySubSelect()

Prepare for a sub select using a call.

Specified by:

prepareReportQuerySubSelect in class DatabaseQueryMechanism

prepareSelectAllRows

public void prepareSelectAllRows()

Pre-build configure the call.

Specified by:

prepareSelectAllRows in class DatabaseQueryMechanism

prepareSelectOneRow

public void prepareSelectOneRow()

Pre-build configure the call.

Specified by:

prepareSelectOneRow in class DatabaseQueryMechanism

prepareUpdateObject

public void prepareUpdateObject()

Pre-build configure the call.

Specified by:

prepareUpdateObject in class DatabaseQueryMechanism

prepareUpdateAll

public void prepareUpdateAll()

Pre-build configure the call.

Specified by:

prepareUpdateAll in class DatabaseQueryMechanism

selectAllReportQueryRows

public Vector selectAllReportQueryRows()
                                throws DatabaseException

Read all rows from the database. Assume call is correct returns the required fields.

Specified by:

selectAllReportQueryRows in class DatabaseQueryMechanism

Returns:

Vector containing the database rows

Throws:

DatabaseException - - an error has occurred on the database

selectAllRows

public Vector selectAllRows()
                     throws DatabaseException

Read all rows from the database. Assume call is correct returns the required fields.

Specified by:

selectAllRows in class DatabaseQueryMechanism

Returns:

Vector containing the database rows

Throws:

DatabaseException - - an error has occurred on the database

selectOneRow

public AbstractRecord selectOneRow()
                            throws DatabaseException

Read a single row from the database. Assume call is correct.

Specified by:

selectOneRow in class DatabaseQueryMechanism

Returns:

row containing data

Throws:

DatabaseException - - an error has occurred on the database

selectRowForDoesExist

public AbstractRecord selectRowForDoesExist(DatabaseField field)
                                     throws DatabaseException

Perform a does exist check

Specified by:

selectRowForDoesExist in class DatabaseQueryMechanism

Parameters:

field - - the field used for does exist check

Returns:

the associated row from the database

Throws:

DatabaseException - - an error has occurred on the database

setCall

public void setCall(DatasourceCall call)

Set the call.

setCalls

protected void setCalls(Vector calls)

Normally only a single call is used, however multiple table may require multiple calls on write. This is lazy initialised to conserve space.

updateObject

public Integer updateObject()
                     throws DatabaseException

Update the object. Assume the call is correct.

Specified by:

updateObject in class DatabaseQueryMechanism

Returns:

the row count.

Throws:

DatabaseException - - an error has occurred on the database.

updateAll

public Integer updateAll()
                  throws DatabaseException

Update the rows on the database. Assume the call is correct.

Specified by:

updateAll in class DatabaseQueryMechanism

Throws:

DatabaseException - - an error has occurred on the database.

updateAllUsingTempTables

public Integer updateAllUsingTempTables()
                                 throws DatabaseException

Execute updateAll using temp tables

Returns:

the row count.

Throws:

DatabaseException - - an error has occurred on the database.

updateForeignKeyFieldAfterInsert

protected void updateForeignKeyFieldAfterInsert(WriteObjectQuery writeQuery)

Update the foreign key fields when resolving a bi-directional reference in a UOW. This is rare to occur for non-relational, however if it does each of the calls must be re-executed.

Specified by:

updateForeignKeyFieldAfterInsert in class DatabaseQueryMechanism