public class ReportQuery extends ReadAllQuery
Attribute Types:
retrievePrimaryKeys()
,
If the values are wanted in the result array then they must be added as attributes. For primary keys which are not mapped directly
you can add them as DatabaseFields (see above).
,
Serialized FormDatabaseQuery.ParameterType
Modifier and Type | Field and Description |
---|---|
protected boolean |
addToConstructorItem
flag to allow items to be added to the last ConstructorReportItem
|
static int |
FIRST_PRIMARY_KEY |
static int |
FULL_PRIMARY_KEY
Specifies whether to retrieve primary keys, first primary key, or no primary key.
|
protected java.util.List<Expression> |
groupByExpressions
Expressions representing fields to be used in the GROUP BY clause.
|
protected Expression |
havingExpression
Expression representing the HAVING clause.
|
protected java.util.List<org.eclipse.persistence.internal.queries.ReportItem> |
items
Items to be selected, these could be attributes or aggregate functions.
|
protected java.util.List<java.lang.String> |
names
Collection of names for use by results.
|
static int |
NO_PRIMARY_KEY |
protected static java.lang.Boolean |
RESULT_IGNORED |
protected int |
returnChoice
Can be one of (ShouldReturnSingleResult, ShouldReturnSingleValue, ShouldReturnSingleAttribute)
Simplifies the result by only returning the first result, first value, or all attribute values
|
protected java.util.Set<java.lang.Object> |
returnedKeys |
protected int |
shouldRetrievePrimaryKeys
Flag indicating whether the primary key values should also be retrieved for the reference class.
|
static int |
ShouldReturnArray
For EJB 3 support returns results as an Object array.
|
static int |
ShouldReturnReportResult
Default, returns ReportQueryResult objects.
|
static int |
ShouldReturnSingleAttribute
Simplifies the result by only returning the single attribute(as opposed to wrapping in a
ReportQueryResult).
|
static int |
ShouldReturnSingleResult
Simplifies the result by only returning the first result.
|
static int |
ShouldReturnSingleValue
Simplifies the result by only returning one value.
|
static int |
ShouldReturnWithoutReportQueryResult
For EJB 3 support returns results without using the ReportQueryResult
|
static int |
ShouldSelectValue1
For example, ...
|
connectByExpression, containerPolicy, orderSiblingsByExpressions, startWithExpression
additionalFields, batchFetchPolicy, cacheUsage, CheckCacheByExactPrimaryKey, CheckCacheByPrimaryKey, CheckCacheOnly, CheckCacheThenDatabase, concreteSubclassCalls, concreteSubclassJoinedMappingIndexes, ConformResultsInUnitOfWork, defaultBuilder, distinctState, DoNotCheckCache, DONT_USE_DISTINCT, fetchGroup, fetchGroupName, inMemoryQueryIndirectionPolicy, isCachedExpressionQuery, isPrePrepared, isReadOnly, isReferenceClassLocked, isResultSetAccessOptimizedQuery, isResultSetAccessOptimizedQueryDefault, isResultSetOptimizedQuery, joinedAttributeManager, loadGroup, lockModeType, NONE, nonFetchJoinAttributeExpressions, OPTIMISTIC, OPTIMISTIC_FORCE_INCREMENT, orderByExpressions, partialAttributeExpressions, PESSIMISTIC_, PESSIMISTIC_FORCE_INCREMENT, PESSIMISTIC_READ, PESSIMISTIC_WRITE, READ, shouldExtendPessimisticLockScope, shouldIncludeData, shouldOuterJoinSubclasses, shouldUseDefaultFetchGroup, shouldUseSerializedObjectPolicy, shouldUseSerializedObjectPolicyDefault, UNCOMPUTED_DISTINCT, unionExpressions, USE_DISTINCT, UseDescriptorSetting, usesResultSetAccessOptimization, waitTimeout, WRITE
DEFAULT_LOCK_MODE, executionTime, isCacheCheckComplete, LOCK, LOCK_NOWAIT, LOCK_RESULT_PROPERTY, lockingClause, NO_LOCK, prefetchedCacheKeys, referenceClass, referenceClassName, requiresDeferredLocks, shouldBuildNullForNullPk, shouldRefreshIdentityMapResult, shouldRefreshRemoteIdentityMapResult, shouldRegisterResultsInUnitOfWork, shouldUseExclusiveConnection, wasDefaultLockMode
fetchSize, firstResult, maxResults, maxRows, queryId, queryResultCachingPolicy, temporaryCachedQueryResults
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, redirector, session, sessionName, shouldBindAllParameters, shouldCacheStatement, shouldCloneCall, shouldMaintainCache, shouldPrepare, shouldRetrieveBypassCache, shouldStoreBypassCache, shouldUseWrapperPolicy, shouldValidateUpdateCallCacheUse, sourceMapping, translationRow
Constructor and Description |
---|
ReportQuery()
INTERNAL:
The builder should be provided.
|
ReportQuery(java.lang.Class javaClass,
Expression expression) |
ReportQuery(java.lang.Class javaClass,
ExpressionBuilder builder)
PUBLIC:
The report query is require to be constructor with an expression builder.
|
ReportQuery(ExpressionBuilder builder)
PUBLIC:
The report query is require to be constructor with an expression builder.
|
Modifier and Type | Method and Description |
---|---|
void |
addAttribute(java.lang.String itemName)
PUBLIC:
Add the attribute from the reference class to be included in the result.
|
void |
addAttribute(java.lang.String itemName,
Expression attributeExpression)
PUBLIC:
Add the attribute to be included in the result.
|
void |
addAttribute(java.lang.String itemName,
Expression attributeExpression,
java.lang.Class type)
PUBLIC:
Add the attribute to be included in the result.
|
void |
addAverage(java.lang.String itemName)
PUBLIC:
Add the average value of the attribute to be included in the result.
|
void |
addAverage(java.lang.String itemName,
java.lang.Class resultType)
PUBLIC:
Add the average value of the attribute to be included in the result and
return it as the specified resultType.
|
void |
addAverage(java.lang.String itemName,
Expression attributeExpression)
PUBLIC:
Add the average value of the attribute to be included in the result.
|
void |
addAverage(java.lang.String itemName,
Expression attributeExpression,
java.lang.Class resultType)
PUBLIC:
Add the average value of the attribute to be included in the result and
return it as the specified resultType.
|
void |
addConstructorReportItem(ConstructorReportItem item)
PUBLIC:
Add a ConstructorReportItem to this query's set of return values.
|
void |
addCount()
PUBLIC:
Include the number of rows returned by the query in the result.
|
void |
addCount(java.lang.String attributeName)
PUBLIC:
Include the number of rows returned by the query in the result, where attributeExpression is not null.
|
void |
addCount(java.lang.String attributeName,
java.lang.Class resultType)
PUBLIC:
Include the number of rows returned by the query in the result, where attributeExpression is not null.
|
void |
addCount(java.lang.String itemName,
Expression attributeExpression)
PUBLIC:
Include the number of rows returned by the query in the result, where attributeExpression
is not null.
|
void |
addCount(java.lang.String itemName,
Expression attributeExpression,
java.lang.Class resultType)
PUBLIC:
Include the number of rows returned by the query in the result, where attributeExpression
is not null.
|
void |
addFunctionItem(java.lang.String itemName,
Expression attributeExpression,
java.lang.String functionName)
ADVANCED:
Add the function against the attribute expression to be included in the result.
|
void |
addGrouping(Expression expression)
PUBLIC:
Add the attribute expression to the group by expressions.
|
void |
addGrouping(java.lang.String attributeName)
PUBLIC:
Add the attribute to the group by expressions.
|
void |
addItem(java.lang.String itemName,
Expression attributeExpression)
ADVANCED:
Add the expression value to be included in the result.
|
protected void |
addItem(java.lang.String itemName,
Expression attributeExpression,
java.lang.Class resultType)
INTERNAL:
Add the expression value to be included in the result.
|
void |
addItem(java.lang.String itemName,
Expression attributeExpression,
java.util.List joinedExpressions)
ADVANCED:
Add the expression value to be included in the result.
|
void |
addMaximum(java.lang.String itemName)
PUBLIC:
Add the maximum value of the attribute to be included in the result.
|
void |
addMaximum(java.lang.String itemName,
Expression attributeExpression)
PUBLIC:
Add the maximum value of the attribute to be included in the result.
|
void |
addMinimum(java.lang.String itemName)
PUBLIC:
Add the minimum value of the attribute to be included in the result.
|
void |
addMinimum(java.lang.String itemName,
Expression attributeExpression)
PUBLIC:
Add the minimum value of the attribute to be included in the result.
|
void |
addStandardDeviation(java.lang.String itemName)
PUBLIC:
Add the standard deviation value of the attribute to be included in the result.
|
void |
addStandardDeviation(java.lang.String itemName,
Expression attributeExpression)
PUBLIC:
Add the standard deviation value of the attribute to be included in the result.
|
void |
addSum(java.lang.String itemName)
PUBLIC:
Add the sum value of the attribute to be included in the result.
|
void |
addSum(java.lang.String itemName,
java.lang.Class resultType)
PUBLIC:
Add the sum value of the attribute to be included in the result and
return it as the specified resultType.
|
void |
addSum(java.lang.String itemName,
Expression attributeExpression)
PUBLIC:
Add the sum value of the attribute to be included in the result.
|
void |
addSum(java.lang.String itemName,
Expression attributeExpression,
java.lang.Class resultType)
PUBLIC:
Add the sum value of the attribute to be included in the result and
return it as the specified resultType.
|
void |
addVariance(java.lang.String itemName)
PUBLIC:
Add the variance value of the attribute to be included in the result.
|
void |
addVariance(java.lang.String itemName,
Expression attributeExpression)
PUBLIC:
Add the variance value of the attribute to be included in the result.
|
ConstructorReportItem |
beginAddingConstructorArguments(java.lang.Class constructorClass)
PUBLIC: Call a constructor for the given class with the results of this query.
|
ConstructorReportItem |
beginAddingConstructorArguments(java.lang.Class constructorClass,
java.lang.Class[] constructorArgTypes)
PUBLIC: Call a constructor for the given class with the results of this query.
|
java.lang.Object |
buildObject(org.eclipse.persistence.internal.sessions.AbstractRecord row)
INTERNAL:
By default return the row.
|
java.lang.Object |
buildObject(org.eclipse.persistence.internal.sessions.AbstractRecord row,
java.util.Vector toManyJoinData)
INTERNAL:
Construct a result from a row.
|
java.lang.Object |
buildObjects(java.util.Vector rows)
INTERNAL:
Construct a container of ReportQueryResult from the rows.
|
protected java.lang.Object |
checkEarlyReturnLocal(org.eclipse.persistence.internal.sessions.AbstractSession session,
org.eclipse.persistence.internal.sessions.AbstractRecord translationRow)
INTERNAL:
The cache check is done before the prepare as a hit will not require the work to be done.
|
protected DatabaseQuery |
checkForCustomQuery(org.eclipse.persistence.internal.sessions.AbstractSession session,
org.eclipse.persistence.internal.sessions.AbstractRecord translationRow)
INTERNAL:
Check to see if a custom query should be used for this query.
|
void |
clearItems()
INTERNAL:
Clear the ReportQueryItems
|
java.lang.Object |
clone()
INTERNAL:
Clone the query.
|
void |
copyReportItems(java.util.Map alreadyDone)
INTERNAL: Required for a very special case of bug 2612185:
ReportItems from parallelExpressions, on a ReportQuery which is a subQuery,
which is being batch read.
|
void |
dontRetrievePrimaryKeys()
PUBLIC:
Set if the query results should contain the primary keys or each associated object.
|
void |
dontReturnSingleAttribute()
PUBLIC:
Don't simplify the result by returning the single attribute.
|
void |
dontReturnSingleResult()
PUBLIC:
Simplifies the result by only returning the first result.
|
void |
dontReturnSingleValue()
PUBLIC:
Simplifies the result by only returning a single value.
|
void |
dontReturnWithoutReportQueryResult()
PUBLIC:
Simplifies the result by only returning a single value.
|
void |
endAddingToConstructorItem()
PUBLIC:
Used in conjunction with beginAddingConstructorArguments to signal that expressions should no longer be
be added to the collection used in the constructor.
|
boolean |
equals(java.lang.Object object)
INTERNAL:
Return if the query is equal to the other.
|
java.lang.Object |
executeDatabaseQuery()
INTERNAL:
Execute the query.
|
java.lang.Object |
extractRemoteResult(org.eclipse.persistence.internal.sessions.remote.Transporter transporter)
INTERNAL:
Extract the correct query result from the transporter.
|
protected QueryRedirector |
getDefaultRedirector()
INTERNAL:
Returns the specific default redirector for this query type.
|
java.util.List<Expression> |
getGroupByExpressions()
INTERNAL:
Return the group bys.
|
Expression |
getHavingExpression()
INTERNAL:
Return the Having expression.
|
org.eclipse.persistence.internal.queries.ReportItem |
getItem(java.lang.String name)
INTERNAL:
|
java.util.List<org.eclipse.persistence.internal.queries.ReportItem> |
getItems()
INTERNAL:
|
java.util.List<java.lang.String> |
getNames()
INTERNAL:
Lazily initialize and return the names of the items requested for use in each result object.
|
java.util.Vector |
getQueryExpressions()
INTERNAL:
return a collection of expressions if PK's are used.
|
int |
getReturnType()
PUBLIC:
Return the return type.
|
boolean |
hasGroupByExpressions()
INTERNAL:
Return if any group bys exist, allow lazy initialization.
|
boolean |
isReportQuery()
PUBLIC:
Return if this is a report query.
|
protected void |
prepare()
INTERNAL:
Prepare the receiver for execution in a session.
|
void |
prepareFetchGroup()
INTERNAL:
ReportQuery doesn't support fetch groups.
|
void |
prepareFromQuery(DatabaseQuery query)
INTERNAL:
Prepare the query from the prepared query.
|
protected void |
prepareObjectAttributeCount(java.util.Map clonedExpressions)
INTERNAL:
Prepare a report query with a count defined on an object attribute.
|
protected void |
prepareSelectAllRows()
INTERNAL:
Prepare the mechanism.
|
void |
prepareSubSelect(org.eclipse.persistence.internal.sessions.AbstractSession session,
org.eclipse.persistence.internal.sessions.AbstractRecord translationRow,
java.util.Map clonedExpressions)
INTERNAL:
Prepare the receiver for being printed inside a subselect.
|
java.util.Map |
replaceValueHoldersIn(java.lang.Object object,
org.eclipse.persistence.internal.sessions.remote.RemoteSessionController controller)
INTERNAL:
replace the value holders in the specified result object(s)
|
void |
retrievePrimaryKeys()
PUBLIC:
Set if the query results should contain the primary keys or each associated object.
|
void |
returnSingleAttribute()
PUBLIC:
Simplify the result by returning a single attribute.
|
void |
returnSingleResult()
PUBLIC:
Simplifies the result by only returning the first result.
|
void |
returnSingleValue()
PUBLIC:
Simplifies the result by only returning a single value.
|
void |
returnWithoutReportQueryResult()
PUBLIC:
Simplifies the result by only returning a single value.
|
void |
selectValue1()
PUBLIC:
Simplifies the result by only returning a single value.
|
void |
setGroupByExpressions(java.util.List<Expression> groupByExpressions)
INTERNAL:
Set the group bys.
|
void |
setHavingExpression(Expression expression)
PUBLIC:
Add the expression to the query to be used in the HAVING clause.
|
void |
setItems(java.util.List<org.eclipse.persistence.internal.queries.ReportItem> items)
INTERNAL:
Set the ReportQueryItems defining the attributes to be read.
|
boolean |
setLockModeType(java.lang.String lockModeType,
org.eclipse.persistence.internal.sessions.AbstractSession session)
INTERNAL:
Sets a javax.persistence.LockModeType to used with this queries execution.
|
protected void |
setNames(java.util.List<java.lang.String> names)
INTERNAL:
Set the item names.
|
void |
setReturnType(int returnChoice)
PUBLIC:
Set the return type.
|
void |
setShouldRetrieveFirstPrimaryKey(boolean shouldRetrieveFirstPrimaryKey)
ADVANCED:
Sets if the query results should contain the first primary key of each associated object.
|
void |
setShouldRetrievePrimaryKeys(boolean shouldRetrievePrimaryKeys)
PUBLIC:
Set if the query results should contain the primary keys or each associated object.
|
void |
setShouldReturnSingleAttribute(boolean newChoice)
PUBLIC:
Simplifies the result by only returning the attribute (as opposed to wrapping in a ReportQueryResult).
|
void |
setShouldReturnSingleResult(boolean newChoice)
PUBLIC:
Simplifies the result by only returning the first result.
|
void |
setShouldReturnSingleValue(boolean newChoice)
PUBLIC:
Simplifies the result by only returning a single value.
|
void |
setShouldReturnWithoutReportQueryResult(boolean newChoice)
PUBLIC:
Simplifies the result by returning a nested list instead of the ReportQueryResult.
|
boolean |
shouldRetrieveFirstPrimaryKey()
PUBLIC:
Return if the query results should contain the first primary key of each associated object.
|
boolean |
shouldRetrievePrimaryKeys()
PUBLIC:
Return if the query results should contain the primary keys or each associated object.
|
boolean |
shouldReturnArray()
PUBLIC:
Returns true if results should be returned as an Object array.
|
boolean |
shouldReturnSingleAttribute()
PUBLIC:
Answer if we are only returning the attribute (as opposed to wrapping in a ReportQueryResult).
|
boolean |
shouldReturnSingleResult()
PUBLIC:
Simplifies the result by only returning the first result.
|
boolean |
shouldReturnSingleValue()
PUBLIC:
Simplifies the result by only returning a single value.
|
boolean |
shouldReturnWithoutReportQueryResult()
PUBLIC:
Simplifies the result by returning a nested list instead of the ReportQueryResult.
|
boolean |
shouldSelectValue1()
PUBLIC:
Returns true if results should be returned as an Object array.
|
addAscendingOrdering, cacheResult, conformResult, execute, executeObjectLevelReadQuery, executeObjectLevelReadQueryFromResultSet, getConnectByExpression, getContainerPolicy, getOrderSiblingsByExpressions, getStartWithExpression, hasHierarchicalExpressions, isDefaultPropertiesQuery, isReadAllQuery, prepareCustomQuery, prepareForExecution, registerResultInUnitOfWork, registerResultSetInUnitOfWork, remoteExecute, setContainerPolicy, setHierarchicalQueryClause, supportsResultSetAccessOptimizationOnExecute, supportsResultSetAccessOptimizationOnPrepare, useCollectionClass, useCursoredStream, useCursoredStream, useCursoredStream, useMapClass, useScrollableCursor, useScrollableCursor, useScrollableCursor
acquireLocks, acquireLocksWithoutWaiting, addAdditionalField, addAdditionalField, addBatchReadAttribute, addBatchReadAttribute, addDescendingOrdering, addJoinedAttribute, addJoinedAttribute, addJoinSelectionFields, addNonFetchJoin, addNonFetchJoinedAttribute, addNonFetchJoinedAttribute, addOrdering, addPartialAttribute, addPartialAttribute, addSelectionFieldsForJoinedExpression, addUnionExpression, changeDescriptor, checkCacheOnly, checkDescriptor, checkEarlyReturn, checkPrepare, checkPrePrepare, clearIsResultSetOptimizedQuery, clearUsesResultSetAccessOptimization, computeBatchReadMappingQueries, computeNestedQueriesForBatchReadExpressions, conformIndividualResult, conformResultsInUnitOfWork, copyFromQuery, deepClone, dontAcquireLocks, dontCheckCache, dontRefreshIdentityMapResult, dontRefreshRemoteIdentityMapResult, dontUseDistinct, except, executeInUnitOfWork, extendPessimisticLockScope, getAdditionalFields, getAsOfClause, getBatchFetchPolicy, getBatchObjects, getBatchReadAttributeExpressions, getCacheUsage, getConcreteSubclassCalls, getConcreteSubclassJoinedMappingIndexes, getDistinctState, getExampleObject, getExecutionFetchGroup, getExecutionFetchGroup, getExpressionBuilder, getFetchGroup, getFetchGroupName, getFetchGroupNonNestedFieldsSet, getFetchGroupNonNestedFieldsSet, getFetchGroupSelectionFields, getFetchGroupSelectionFields, getInMemoryQueryIndirectionPolicy, getInMemoryQueryIndirectionPolicyState, getJoinedAttributeExpressions, getJoinedAttributeManager, getLoadGroup, getLockingClause, getLockModeType, getNonFetchJoinAttributeExpressions, getOrderByExpressions, getPartialAttributeExpressions, getPartialAttributeSelectionFields, getQueryByExamplePolicy, getReferenceClass, getReferenceClassName, getSelectionFields, getUnionExpressions, getWaitTimeout, hasAdditionalFields, hasAsOfClause, hasBatchReadAttributes, hasDefaultBuilder, hasExecutionFetchGroup, hasFetchGroup, hashCode, hasJoining, hasNonFetchJoinedAttributeExpressions, hasOrderByExpressions, hasPartialAttributeExpressions, hasUnionExpressions, initializeDefaultBuilder, intersect, isAttributeBatchRead, isCachedExpressionQuery, isClonePessimisticLocked, isDefaultLock, isDistinctComputed, isLockQuery, isLockQuery, isObjectLevelReadQuery, isPartialAttribute, isPrePrepared, isPrimaryKeyQuery, isReadOnly, isReferenceClassLocked, isResultSetAccessOptimizedQuery, isResultSetOptimizedQuery, prepareForRemoteExecution, prepareFromCachedQuery, prepareOutsideUnitOfWork, prepareQuery, prepareResultSetAccessOptimization, prePrepare, recordCloneForPessimisticLocking, refreshIdentityMapResult, refreshRemoteIdentityMapResult, resetDistinct, setAdditionalFields, setAsOfClause, setBatchFetchPolicy, setBatchFetchSize, setBatchFetchType, setBatchObjects, setBatchReadAttributeExpressions, setCacheUsage, setDescriptor, setDistinctState, setEJBQLString, setExampleObject, setExpressionBuilder, setFetchGroup, setFetchGroupName, setInMemoryQueryIndirectionPolicy, setInMemoryQueryIndirectionPolicyState, setIsPrepared, setIsPreparedKeepingSubclassData, setIsPrePrepared, setIsReadOnly, setIsResultSetAccessOptimizedQuery, setIsResultSetOptimizedQuery, setJoinedAttributeExpressions, setJoinedAttributeManager, setLoadGroup, setLockingClause, setLockMode, setNonFetchJoinAttributeExpressions, setOrderByExpressions, setPartialAttributeExpressions, setQueryByExamplePolicy, setReferenceClass, setReferenceClassName, setSelectionCriteria, setShouldExtendPessimisticLockScope, setShouldFilterDuplicates, setShouldIncludeData, setShouldOuterJoinSubclasses, setShouldUseDefaultFetchGroup, setShouldUseSerializedObjectPolicy, setUnionExpressions, setWaitTimeout, shouldCheckCache, shouldCheckCacheOnly, shouldCheckDescriptorForCacheUsage, shouldConformResultsInUnitOfWork, shouldDistinctBeUsed, shouldExtendPessimisticLockScope, shouldFilterDuplicates, shouldIncludeData, shouldOuterJoinSubclasses, shouldReadAllMappings, shouldReadMapping, shouldUseDefaultFetchGroup, shouldUseSerializedObjectPolicy, toString, union, useDistinct, usesResultSetAccessOptimization
clonedQueryExecutionComplete, convertClassNamesToClasses, getDataResults, getExecutionTime, getLockMode, getPrefetchedCacheKeys, getQueryPrimaryKey, isAttributeJoined, isCacheCheckComplete, isObjectBuildingQuery, isRegisteringResults, postRegisterIndividualResult, registerIndividualResult, requiresDeferredLocks, setExecutionTime, setPrefetchedCacheKeys, setRequiresDeferredLocks, setShouldBuildNullForNullPk, setShouldRefreshIdentityMapResult, setShouldRefreshRemoteIdentityMapResult, setShouldRegisterResultsInUnitOfWork, setShouldUseExclusiveConnection, setWasDefaultLockMode, shouldBuildNullForNullPk, shouldRefreshIdentityMapResult, shouldRefreshRemoteIdentityMapResult, shouldRegisterResultsInUnitOfWork, shouldUseExclusiveConnection, wasDefaultLockMode
cacheQueryResults, clearQueryResults, doNotCacheQueryResults, getFetchSize, getFirstResult, getInternalMax, getMaxRows, getQueryId, getQueryResults, getQueryResults, getQueryResults, getQueryResultsCachePolicy, getTemporaryCachedQueryResults, isReadQuery, remoteExecute, setFetchSize, setFirstResult, setInternalMax, setMaxRows, setQueryId, setQueryResults, setQueryResultsCachePolicy, setTemporaryCachedQueryResults, shouldCacheQueryResults
addArgument, addArgument, addArgument, addArgument, addArgument, addArgument, addArgumentByTypeName, addArgumentValue, addArgumentValues, addCall, addStatement, bindAllParameters, buildArgumentFields, buildSelectionCriteria, cacheStatement, cascadeAllParts, cascadeByMapping, cascadeOnlyDependentParts, cascadePrivateParts, checkPrepare, dontBindAllParameters, dontCacheStatement, dontCascadeParts, dontMaintainCache, getAccessor, getAccessors, getArgumentParameterTypes, getArguments, getArgumentTypeNames, getArgumentTypes, getArgumentValues, getCall, getCascadePolicy, getDatasourceCall, getDatasourceCalls, getDescriptor, getDescriptors, getDomainClassNounName, getDoNotRedirect, getEJBQLString, getExecutionSession, getFlushOnExecute, getHintString, getJPQLString, getMonitorName, getName, getNullableArguments, getParameterDelimiter, getParameterDelimiterChar, getPartitioningPolicy, getProperties, getProperty, getQueryMechanism, getQueryNounName, getQueryTimeout, getRedirector, getRedirectorForQuery, 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, isObjectLevelModifyQuery, isPrepared, isReadObjectQuery, isResultSetMappingQuery, isSQLCallQuery, isUpdateAllQuery, isUpdateObjectQuery, isUserDefined, isUserDefinedSQLCall, isValueReadQuery, isWriteObjectQuery, maintainCache, prepareCall, prepareInternal, redirectQuery, removeProperty, resetMonitorName, retrieveBypassCache, rowFromArguments, setAccessor, setAccessors, setAllowNativeSQLQuery, setArguments, setArgumentTypeNames, setArgumentTypes, setArgumentValues, setCall, setCascadePolicy, setDatasourceCall, setDoNotRedirect, setExecutionSession, setFlushOnExecute, setHintString, setIsCustomQueryUsed, setIsExecutionClone, setIsNativeConnectionRequired, setIsUserDefined, setIsUserDefinedSQLCall, setJPQLString, setName, setNullableArguments, setParameterDelimiter, setPartitioningPolicy, setProperties, setProperty, setQueryMechanism, setQueryTimeout, setRedirector, setSession, setSessionName, setShouldBindAllParameters, setShouldBindAllParameters, setShouldCacheStatement, setShouldMaintainCache, setShouldPrepare, setShouldRetrieveBypassCache, setShouldStoreBypassCache, setShouldUseWrapperPolicy, setShouldValidateUpdateCallCacheUse, setSourceMapping, setSQLStatement, setSQLString, setTranslationRow, shouldAllowNativeSQLQuery, shouldBindAllParameters, shouldCacheStatement, shouldCascadeAllParts, shouldCascadeByMapping, shouldCascadeOnlyDependentParts, shouldCascadeParts, shouldCascadePrivateParts, shouldCloneCall, shouldIgnoreBindAllParameters, shouldIgnoreCacheStatement, shouldMaintainCache, shouldPrepare, shouldPrepare, shouldRetrieveBypassCache, shouldStoreBypassCache, shouldUseWrapperPolicy, shouldValidateUpdateCallCacheUse, storeBypassCache
public static final int ShouldReturnReportResult
public static final int ShouldReturnSingleResult
public static final int ShouldReturnSingleValue
public static final int ShouldReturnSingleAttribute
public static final int ShouldReturnWithoutReportQueryResult
public static final int ShouldReturnArray
public static final int ShouldSelectValue1
public static final int FULL_PRIMARY_KEY
public static final int FIRST_PRIMARY_KEY
public static final int NO_PRIMARY_KEY
protected static final java.lang.Boolean RESULT_IGNORED
protected int shouldRetrievePrimaryKeys
protected java.util.List<java.lang.String> names
protected java.util.List<org.eclipse.persistence.internal.queries.ReportItem> items
protected java.util.List<Expression> groupByExpressions
protected Expression havingExpression
protected int returnChoice
protected boolean addToConstructorItem
protected java.util.Set<java.lang.Object> returnedKeys
public ReportQuery()
public ReportQuery(java.lang.Class javaClass, Expression expression)
public ReportQuery(java.lang.Class javaClass, ExpressionBuilder builder)
public ReportQuery(ExpressionBuilder builder)
public void addAttribute(java.lang.String itemName)
public void addAttribute(java.lang.String itemName, Expression attributeExpression)
public void addAttribute(java.lang.String itemName, Expression attributeExpression, java.lang.Class type)
public void addAverage(java.lang.String itemName)
public void addAverage(java.lang.String itemName, java.lang.Class resultType)
public void addAverage(java.lang.String itemName, Expression attributeExpression)
public void addAverage(java.lang.String itemName, Expression attributeExpression, java.lang.Class resultType)
public void addConstructorReportItem(ConstructorReportItem item)
ConstructorReportItem
- - used to specify a class constructor and values to pass in from this queryConstructorReportItem
public void addCount()
addCount(java.lang.String)
public void addCount(java.lang.String attributeName)
Example:
TopLink: reportQuery.addCount("id"); SQL: SELECT COUNT (t0.EMP_ID) FROM EMPLOYEE t0, ...
attributeName
- the number of rows where attributeName is not null will be returned.addCount(java.lang.String, org.eclipse.persistence.expressions.Expression)
public void addCount(java.lang.String attributeName, java.lang.Class resultType)
Example:
TopLink: reportQuery.addCount("id", Long.class); SQL: SELECT COUNT (t0.EMP_ID) FROM EMPLOYEE t0, ...
attributeName
- the number of rows where attributeName is not null will be returned.addCount(java.lang.String, org.eclipse.persistence.expressions.Expression)
public void addCount(java.lang.String itemName, Expression attributeExpression)
Example:
TopLink: reportQuery.addCount("Count", getExpressionBuilder().get("id")); SQL: SELECT COUNT (t0.EMP_ID) FROM EMPLOYEE t0, ...
Example: counting only distinct values of an attribute.
objectAttributes can be specified also, even accross many to many mappings.TopLink: reportQuery.addCount("Count", getExpressionBuilder().get("address").distinct()); SQL: SELECT COUNT (DISTINCT t0.ADDR_ID) FROM EMPLOYEE t0, ...
addCount()
public void addCount(java.lang.String itemName, Expression attributeExpression, java.lang.Class resultType)
Example:
TopLink: reportQuery.addCount("Count", getExpressionBuilder().get("id"), Integer.class); SQL: SELECT COUNT (t0.EMP_ID) FROM EMPLOYEE t0, ...
Example: counting only distinct values of an attribute.
objectAttributes can be specified also, even accross many to many mappings.TopLink: reportQuery.addCount("Count", getExpressionBuilder().get("address").distinct()); SQL: SELECT COUNT (DISTINCT t0.ADDR_ID) FROM EMPLOYEE t0, ...
addCount()
public void addFunctionItem(java.lang.String itemName, Expression attributeExpression, java.lang.String functionName)
public void addGrouping(java.lang.String attributeName)
public void addGrouping(Expression expression)
public void setHavingExpression(Expression expression)
Example:
reportQuery.setHavingExpression(expBuilder.get("address").get("country").equal("Canada"))
public void addItem(java.lang.String itemName, Expression attributeExpression)
public void addItem(java.lang.String itemName, Expression attributeExpression, java.util.List joinedExpressions)
protected void addItem(java.lang.String itemName, Expression attributeExpression, java.lang.Class resultType)
public void addMaximum(java.lang.String itemName)
public void addMaximum(java.lang.String itemName, Expression attributeExpression)
public void addMinimum(java.lang.String itemName)
public void addMinimum(java.lang.String itemName, Expression attributeExpression)
public void addStandardDeviation(java.lang.String itemName)
public void addStandardDeviation(java.lang.String itemName, Expression attributeExpression)
public void addSum(java.lang.String itemName)
public void addSum(java.lang.String itemName, java.lang.Class resultType)
public void addSum(java.lang.String itemName, Expression attributeExpression)
public void addSum(java.lang.String itemName, Expression attributeExpression, java.lang.Class resultType)
public void addVariance(java.lang.String itemName)
public void addVariance(java.lang.String itemName, Expression attributeExpression)
public ConstructorReportItem beginAddingConstructorArguments(java.lang.Class constructorClass)
constructorClass
- public ConstructorReportItem beginAddingConstructorArguments(java.lang.Class constructorClass, java.lang.Class[] constructorArgTypes)
constructorClass
- constructorArgTypes
- - sets the argument types to be passed to the constructor.public java.lang.Object buildObject(org.eclipse.persistence.internal.sessions.AbstractRecord row)
buildObject
in class ObjectLevelReadQuery
public java.lang.Object buildObject(org.eclipse.persistence.internal.sessions.AbstractRecord row, java.util.Vector toManyJoinData)
public java.lang.Object buildObjects(java.util.Vector rows)
protected java.lang.Object checkEarlyReturnLocal(org.eclipse.persistence.internal.sessions.AbstractSession session, org.eclipse.persistence.internal.sessions.AbstractRecord translationRow)
checkEarlyReturnLocal
in class ReadAllQuery
protected DatabaseQuery checkForCustomQuery(org.eclipse.persistence.internal.sessions.AbstractSession session, org.eclipse.persistence.internal.sessions.AbstractRecord translationRow)
checkForCustomQuery
in class ReadAllQuery
public java.lang.Object clone()
clone
in class ReadAllQuery
public void copyReportItems(java.util.Map alreadyDone)
public void dontRetrievePrimaryKeys()
public void dontReturnSingleAttribute()
public void dontReturnSingleResult()
public void dontReturnSingleValue()
public void dontReturnWithoutReportQueryResult()
public void endAddingToConstructorItem()
public java.lang.Object executeDatabaseQuery() throws DatabaseException
executeDatabaseQuery
in class ObjectLevelReadQuery
DatabaseException
- - an error has occurred on the databasepublic java.lang.Object extractRemoteResult(org.eclipse.persistence.internal.sessions.remote.Transporter transporter)
extractRemoteResult
in class ReadAllQuery
public java.util.List<Expression> getGroupByExpressions()
public boolean hasGroupByExpressions()
public void setGroupByExpressions(java.util.List<Expression> groupByExpressions)
public Expression getHavingExpression()
public java.util.Vector getQueryExpressions()
protected QueryRedirector getDefaultRedirector()
getDefaultRedirector
in class ReadAllQuery
public java.util.List<org.eclipse.persistence.internal.queries.ReportItem> getItems()
public org.eclipse.persistence.internal.queries.ReportItem getItem(java.lang.String name)
public void setItems(java.util.List<org.eclipse.persistence.internal.queries.ReportItem> items)
public boolean setLockModeType(java.lang.String lockModeType, org.eclipse.persistence.internal.sessions.AbstractSession session)
setLockModeType
in class ObjectLevelReadQuery
public void clearItems()
public java.util.List<java.lang.String> getNames()
protected void setNames(java.util.List<java.lang.String> names)
public boolean isReportQuery()
isReportQuery
in class DatabaseQuery
protected void prepare() throws QueryException
prepare
in class ReadAllQuery
QueryException
public void prepareFetchGroup() throws QueryException
prepareFetchGroup
in class ObjectLevelReadQuery
QueryException
public void prepareFromQuery(DatabaseQuery query)
prepareFromQuery
in class ReadAllQuery
public boolean equals(java.lang.Object object)
equals
in class ReadAllQuery
protected void prepareObjectAttributeCount(java.util.Map clonedExpressions)
protected void prepareSelectAllRows()
prepareSelectAllRows
in class ReadAllQuery
public void prepareSubSelect(org.eclipse.persistence.internal.sessions.AbstractSession session, org.eclipse.persistence.internal.sessions.AbstractRecord translationRow, java.util.Map clonedExpressions) throws QueryException
QueryException
public java.util.Map replaceValueHoldersIn(java.lang.Object object, org.eclipse.persistence.internal.sessions.remote.RemoteSessionController controller)
replaceValueHoldersIn
in class ReadAllQuery
public void retrievePrimaryKeys()
public int getReturnType()
public void setReturnType(int returnChoice)
public void returnSingleAttribute()
public void returnSingleResult()
public void returnSingleValue()
public void returnWithoutReportQueryResult()
public void selectValue1()
public void setShouldRetrievePrimaryKeys(boolean shouldRetrievePrimaryKeys)
public void setShouldRetrieveFirstPrimaryKey(boolean shouldRetrieveFirstPrimaryKey)
public void setShouldReturnSingleAttribute(boolean newChoice)
public void setShouldReturnSingleResult(boolean newChoice)
public void setShouldReturnSingleValue(boolean newChoice)
public void setShouldReturnWithoutReportQueryResult(boolean newChoice)
public boolean shouldRetrievePrimaryKeys()
public boolean shouldRetrieveFirstPrimaryKey()
public boolean shouldReturnSingleAttribute()
public boolean shouldReturnSingleResult()
public boolean shouldReturnSingleValue()
public boolean shouldReturnWithoutReportQueryResult()
public boolean shouldReturnArray()
public boolean shouldSelectValue1()