- All Implemented Interfaces:
Serializable
,Cloneable
- Direct Known Subclasses:
DataReadQuery
,ObjectBuildingQuery
Purpose: Abstract class for all read queries.
Responsibilities:
- Caches result of query if flag is set.
- Since:
- TOPLink/Java 1.0
- See Also:
-
Nested Class Summary
Nested classes/interfaces inherited from class org.eclipse.persistence.queries.DatabaseQuery
DatabaseQuery.ParameterType
-
Field Summary
Modifier and TypeFieldDescriptionprotected boolean
Flag that allows query result cache validation or not.protected int
Used to set statement fetch sizeprotected int
Used to start query results at a specific resultprotected int
Stores the JPA maxResult settings for a NamedQueryprotected int
Used for retrieve limited rows through the query.protected long
protected QueryResultsCachePolicy
Used to specify how query results are cachedprotected Object
Optimization: temporarily stores cached query results while they are being built in a cloned queryFields inherited from class org.eclipse.persistence.queries.DatabaseQuery
accessors, allowNativeSQLQuery, argumentFields, argumentParameterTypes, arguments, argumentTypeNames, argumentTypes, argumentValues, BATCH_FETCH_PROPERTY, CascadeAggregateDelete, CascadeAllParts, CascadeByMapping, CascadeDependentParts, cascadePolicy, CascadePrivateParts, descriptor, descriptors, doNotRedirect, executionSession, flushOnExecute, hintString, isCustomQueryUsed, isExecutionClone, isNativeConnectionRequired, isPrepared, isUserDefined, isUserDefinedSQLCall, monitorName, name, NoCascading, nullableArguments, parameterDelimiter, partitioningPolicy, properties, queryMechanism, queryTimeout, queryTimeoutUnit, redirector, session, sessionName, shouldBindAllParameters, shouldCacheStatement, shouldCloneCall, shouldMaintainCache, shouldPrepare, shouldRetrieveBypassCache, shouldReturnGeneratedKeys, shouldStoreBypassCache, shouldUseWrapperPolicy, shouldValidateUpdateCallCacheUse, sourceMapping, translationRow
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionINTERNAL: By default return the row.void
ADVANCED:abstract void
cacheResult
(Object object) INTERNAL:void
clearQueryResults
(AbstractSession session) PUBLIC: Clears the current cached results, the next execution with read from the database.protected void
clonedQueryExecutionComplete
(DatabaseQuery query, AbstractSession session) INTERNAL Used to give the subclasses opportunity to copy aspects of the cloned query to the original query.void
copyFromQuery
(DatabaseQuery query) INTERNAL: Copy all setting from the query.void
ADVANCED:int
PUBLIC: Return the fetchSize setting that this query will set on the JDBC Statement NB - a value of zero means that no call to statement.setFetchSize() will be made.int
PUBLIC: Return the value that will be set for the firstResult in the returned result setint
INTERNAL: returns the JPA max results that may have been set on a NamedQueryint
PUBLIC: Return the limit for the maximum number of rows that any ResultSet can contain to the given number.long
INTERNAL: This method is used to get the time in millis that this query is being executed at.protected Object
getQueryResults
(AbstractSession session) INTERNAL: To any user of this object with some knowledge of what the query's results may contain.protected Object
getQueryResults
(AbstractSession session, boolean checkExpiry) INTERNAL: To any user of this object with some knowledge of what the query's results may contain.protected Object
getQueryResults
(AbstractSession session, AbstractRecord row, boolean checkExpiry) INTERNAL: To any user of this object with some knowledge of what the query's results may contain.PUBLIC: Return the QueryResultsCachePolicy for this query.INTERNAL: Get results from the remporary cache.boolean
INTERNAL: Return true if the query uses default properties.boolean
PUBLIC: Return if this is a read query.protected 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
INTERNAL: Prepare the receiver for execution in a session.remoteExecute
(AbstractSession session) INTERNAL: Return if this is a read query.void
setAllowQueryResultsCacheValidation
(boolean allowQueryResultsCacheValidation) void
setFetchSize
(int fetchSize) PUBLIC: Set the fetchSize setting that this query will set on the JDBC Statement NB - a value of zero means that no call to statement.setFetchSize() will be made.void
setFirstResult
(int firstResult) PUBLIC: Used to set the first result in any result set that is returned for this query.void
setInternalMax
(int max) INTERNAL: sets the JPA max results that may have been set on a NamedQueryvoid
setMaxRows
(int maxRows) PUBLIC: Used to set the limit for the maximum number of rows that any ResultSet can contain to the given number.void
setQueryId
(long id) INTERNAL: This method is used to set the current system time in millis that this query is being executed at.protected void
setQueryResults
(Object resultFromQuery, AbstractRecord row, AbstractSession session) INTERNAL: Set the cached results of the query.void
Set the QueryResultsCachePolicy.void
setTemporaryCachedQueryResults
(Object queryResults) INTERNAL: Put results in the temporary cache.boolean
boolean
PUBLIC: Return if the query should cache the results of the next execution or not.Methods inherited from class org.eclipse.persistence.queries.DatabaseQuery
addArgument, addArgument, addArgument, addArgument, addArgument, addArgument, addArgumentByTypeName, addArgumentValue, addArgumentValues, addCall, addStatement, bindAllParameters, buildArgumentFields, buildSelectionCriteria, cacheStatement, cascadeAllParts, cascadeByMapping, cascadeOnlyDependentParts, cascadePrivateParts, checkDescriptor, checkEarlyReturn, checkForCustomQuery, checkPrepare, checkPrepare, clone, convertClassNamesToClasses, dontBindAllParameters, dontCacheStatement, dontCascadeParts, dontMaintainCache, execute, executeDatabaseQuery, executeInUnitOfWork, extractRemoteResult, getAccessor, getAccessors, getArgumentParameterTypes, getArguments, getArgumentTypeNames, getArgumentTypes, getArgumentValues, getBatchObjects, getCall, getCascadePolicy, getDatasourceCall, getDatasourceCalls, getDefaultRedirector, getDescriptor, getDescriptors, getDomainClassNounName, getDoNotRedirect, getEJBQLString, getExecutionSession, getFlushOnExecute, getHintString, getJPQLString, getMonitorName, getName, getNullableArguments, getParameterDelimiter, getParameterDelimiterChar, getPartitioningPolicy, getProperties, getProperty, getQueryMechanism, getQueryNounName, getQueryTimeout, getQueryTimeoutUnit, getRedirector, getRedirectorForQuery, getReferenceClass, getReferenceClassName, getSelectionCriteria, getSensorName, getSession, getSessionName, getShouldBindAllParameters, getSourceMapping, getSQLStatement, getSQLString, getSQLStrings, getTranslatedSQLString, getTranslatedSQLStrings, getTranslationRow, hasAccessor, hasArguments, hasNullableArguments, hasProperties, hasQueryMechanism, hasSessionName, ignoreBindAllParameters, ignoreCacheStatement, isCallQuery, isCascadeOfAggregateDelete, isCustomQueryUsed, isCustomSelectionQuery, isDataModifyQuery, isDataReadQuery, isDeleteAllQuery, isDeleteObjectQuery, isDirectReadQuery, isExecutionClone, isExpressionQuery, isInsertObjectQuery, isJPQLCallQuery, isModifyAllQuery, isModifyQuery, isNativeConnectionRequired, isObjectBuildingQuery, isObjectLevelModifyQuery, isObjectLevelReadQuery, isPrepared, isReadAllQuery, isReadObjectQuery, isReportQuery, isResultSetMappingQuery, isSQLCallQuery, isUpdateAllQuery, isUpdateObjectQuery, isUserDefined, isUserDefinedSQLCall, isValueReadQuery, isWriteObjectQuery, maintainCache, prepareCall, prepareCustomQuery, prepareForRemoteExecution, prepareFromQuery, prepareInternal, redirectQuery, remoteExecute, removeProperty, replaceValueHoldersIn, resetMonitorName, retrieveBypassCache, rowFromArguments, setAccessor, setAccessors, setAllowNativeSQLQuery, setArguments, setArgumentTypeNames, setArgumentTypes, setArgumentValues, setBatchObjects, setCall, setCascadePolicy, setDatasourceCall, setDescriptor, setDoNotRedirect, setEJBQLString, setExecutionSession, setFlushOnExecute, setHintString, setIsCustomQueryUsed, setIsExecutionClone, setIsNativeConnectionRequired, setIsPrepared, setIsUserDefined, setIsUserDefinedSQLCall, setJPQLString, setName, setNullableArguments, setParameterDelimiter, setPartitioningPolicy, setProperties, setProperty, setQueryMechanism, setQueryTimeout, setQueryTimeoutUnit, setRedirector, setSelectionCriteria, setSession, setSessionName, setShouldBindAllParameters, setShouldBindAllParameters, setShouldCacheStatement, setShouldMaintainCache, setShouldPrepare, setShouldRetrieveBypassCache, setShouldReturnGeneratedKeys, setShouldStoreBypassCache, setShouldUseWrapperPolicy, setShouldValidateUpdateCallCacheUse, setSourceMapping, setSQLStatement, setSQLString, setTranslationRow, shouldAllowNativeSQLQuery, shouldBindAllParameters, shouldCacheStatement, shouldCascadeAllParts, shouldCascadeByMapping, shouldCascadeOnlyDependentParts, shouldCascadeParts, shouldCascadePrivateParts, shouldCloneCall, shouldIgnoreBindAllParameters, shouldIgnoreCacheStatement, shouldMaintainCache, shouldPrepare, shouldPrepare, shouldRetrieveBypassCache, shouldReturnGeneratedKeys, shouldStoreBypassCache, shouldUseWrapperPolicy, shouldValidateUpdateCallCacheUse, storeBypassCache, toString
-
Field Details
-
maxRows
protected int maxRowsUsed for retrieve limited rows through the query. -
firstResult
protected int firstResultUsed to start query results at a specific result -
queryId
protected long queryId -
fetchSize
protected int fetchSizeUsed to set statement fetch size -
queryResultCachingPolicy
Used to specify how query results are cached -
temporaryCachedQueryResults
Optimization: temporarily stores cached query results while they are being built in a cloned query -
maxResults
protected int maxResultsStores the JPA maxResult settings for a NamedQuery -
allowQueryResultsCacheValidation
protected boolean allowQueryResultsCacheValidationFlag that allows query result cache validation or not.
-
-
Constructor Details
-
ReadQuery
protected ReadQuery()PUBLIC: Initialize the state of the query
-
-
Method Details
-
buildObject
INTERNAL: By default return the row. Used by cursored stream. -
cacheQueryResults
public void cacheQueryResults()ADVANCED:This method will instruct the query to cache the results returned by its next execution. All subsequent executions of this query will return this cached result set even if new query parameters are specified. This method provides a performance enhancement for queries known to always return the same result set. Oracle recommends that you use this method only for such queries.
To disable this behavior, call
doNotCacheQueryResults()
orsetQueryResultsCachePolicy(org.eclipse.persistence.queries.QueryResultsCachePolicy)
passing in null. -
cacheResult
INTERNAL:This method is called by the object builder when building an original. It will cause the original to be cached in the query results if the query is set to do so.
-
clonedQueryExecutionComplete
INTERNAL Used to give the subclasses opportunity to copy aspects of the cloned query to the original query.- Overrides:
clonedQueryExecutionComplete
in classDatabaseQuery
-
clearQueryResults
PUBLIC: Clears the current cached results, the next execution with read from the database. -
doNotCacheQueryResults
public void doNotCacheQueryResults()ADVANCED:This method will instruct the query not to cache results. All subsequent executions return result sets according to the current configuration of query parameters. After calling this method, any previously cached result set will be discarded the next time the query is executed.
To enable this behavior, call
Note: If this method is called on a query that initially cached query results, clearQueryResults(Session) should also be called. Otherwise, the results of this query will remain in the cache and cause extra memory usecacheQueryResults()
orsetQueryResultsCachePolicy(org.eclipse.persistence.queries.QueryResultsCachePolicy)
passing in a valid QueryResultsCachePolicy. -
getQueryResultsCachePolicy
PUBLIC: Return the QueryResultsCachePolicy for this query.- See Also:
-
getFirstResult
public int getFirstResult()PUBLIC: Return the value that will be set for the firstResult in the returned result set -
getQueryId
public long getQueryId()INTERNAL: This method is used to get the time in millis that this query is being executed at. it is set just prior to executing the SQL and will be used to determine which objects should be refreshed. CR #4365 CR #2698903 ... instead of using millis we will now use id's instead. Method renamed appropriately. -
getInternalMax
public int getInternalMax()INTERNAL: returns the JPA max results that may have been set on a NamedQuery- Returns:
- the maxResults
-
getMaxRows
public int getMaxRows()PUBLIC: Return the limit for the maximum number of rows that any ResultSet can contain to the given number. -
getFetchSize
public int getFetchSize()PUBLIC: Return the fetchSize setting that this query will set on the JDBC Statement NB - a value of zero means that no call to statement.setFetchSize() will be made. -
getQueryResults
INTERNAL: To any user of this object with some knowledge of what the query's results may contain. Return the results of the query. If the query has never been executed, or does not cache results, the results will be null. -
getQueryResults
INTERNAL: To any user of this object with some knowledge of what the query's results may contain. Return the results of the query. If the query has never been executed, or does not cache results, the results will be null. -
getQueryResults
INTERNAL: To any user of this object with some knowledge of what the query's results may contain. Return the results of the query. If the query has never been executed, or does not cache results, the results will be null. -
getTemporaryCachedQueryResults
INTERNAL: Get results from the remporary cache. Used when caching query results on a clone so they can be copied to the original query -
isDefaultPropertiesQuery
public boolean isDefaultPropertiesQuery()INTERNAL: Return true if the query uses default properties. This is used to determine if this query is cacheable. i.e. does not use any properties that may conflict with another query with the same EJBQL or selection criteria.- Overrides:
isDefaultPropertiesQuery
in classDatabaseQuery
-
isReadQuery
public boolean isReadQuery()PUBLIC: Return if this is a read query.- Overrides:
isReadQuery
in classDatabaseQuery
-
copyFromQuery
INTERNAL: Copy all setting from the query. This is used to morph queries from one type to the other. By default this calls prepareFromQuery, but additional properties may be required to be copied as prepareFromQuery only copies properties that affect the SQL.- Overrides:
copyFromQuery
in classDatabaseQuery
-
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. Clear the query cache when a query is prepared.- Overrides:
prepare
in classDatabaseQuery
- Throws:
QueryException
-
prepareForExecution
INTERNAL: Prepare the receiver for execution in a session.- Overrides:
prepareForExecution
in classDatabaseQuery
- Throws:
QueryException
-
remoteExecute
INTERNAL: Return if this is a read query.- Overrides:
remoteExecute
in classDatabaseQuery
- Throws:
DatabaseException
-
setQueryResultsCachePolicy
Set the QueryResultsCachePolicy.- See Also:
-
setFirstResult
public void setFirstResult(int firstResult) PUBLIC: Used to set the first result in any result set that is returned for this query. On supported database platforms this will cause the query to issue specific SQL that avoids selecting the firstResult number of rows. Otherwise by it will use the JDBC absolute to skip the firstResult number of rows. -
setQueryId
public void setQueryId(long id) INTERNAL: This method is used to set the current system time in millis that this query is being executed at. it is set just prior to executing the SQL and will be used to determine which objects should be refreshed. CR #4365 CR #2698903 ... instead of using millis we will now use id's instead. Method renamed appropriately. -
setInternalMax
public void setInternalMax(int max) INTERNAL: sets the JPA max results that may have been set on a NamedQuery -
setMaxRows
public void setMaxRows(int maxRows) PUBLIC: Used to set the limit for the maximum number of rows that any ResultSet can contain to the given number. This method should only be set once per query. To change the max rows use another query. This method limits the number of candidate results returned to TopLink that can be used to build objects -
setFetchSize
public void setFetchSize(int fetchSize) PUBLIC: Set the fetchSize setting that this query will set on the JDBC Statement NB - a value of zero means that no call to statement.setFetchSize() will be made. -
setQueryResults
INTERNAL: Set the cached results of the query. This will only be set if the query caches results. -
shouldCacheQueryResults
public boolean shouldCacheQueryResults()PUBLIC: Return if the query should cache the results of the next execution or not. -
setTemporaryCachedQueryResults
INTERNAL: Put results in the temporary cache. Used when caching query results on a clone so they can be copied to the original query -
shouldAllowQueryResultsCacheValidation
public boolean shouldAllowQueryResultsCacheValidation() -
setAllowQueryResultsCacheValidation
public void setAllowQueryResultsCacheValidation(boolean allowQueryResultsCacheValidation)
-