Package org.camunda.bpm.engine.impl
Class AbstractNativeQuery<T extends NativeQuery<?,?>,U>
java.lang.Object
org.camunda.bpm.engine.impl.AbstractNativeQuery<T,U>
- All Implemented Interfaces:
Serializable
,Command<Object>
,NativeQuery<T,
U>
- Direct Known Subclasses:
NativeExecutionQueryImpl
,NativeHistoricActivityInstanceQueryImpl
,NativeHistoricCaseActivityInstanceQueryImpl
,NativeHistoricCaseInstanceQueryImpl
,NativeHistoricProcessInstanceQueryImpl
,NativeHistoricTaskInstanceQueryImpl
,NativeHistoricVariableInstanceQueryImpl
,NativeHistoryDecisionInstanceQueryImpl
,NativeProcessInstanceQueryImpl
,NativeTaskQueryImpl
,NativeUserQueryImpl
public abstract class AbstractNativeQuery<T extends NativeQuery<?,?>,U>
extends Object
implements Command<Object>, NativeQuery<T,U>, Serializable
Abstract superclass for all native query types.
- Author:
- Bernd Ruecker (camunda)
- See Also:
-
Field Summary
Modifier and TypeFieldDescriptionprotected CommandContext
protected CommandExecutor
protected int
protected int
protected org.camunda.bpm.engine.impl.AbstractNativeQuery.ResultType
-
Constructor Summary
ModifierConstructorDescriptionAbstractNativeQuery
(CommandContext commandContext) protected
AbstractNativeQuery
(CommandExecutor commandExecutor) -
Method Summary
Modifier and TypeMethodDescriptionlong
count()
Executes the query and returns the number of resultsexecute
(CommandContext commandContext) abstract long
executeCount
(CommandContext commandContext, Map<String, Object> parameterMap) executeList
(CommandContext commandContext, Map<String, Object> parameterMap, int firstResult, int maxResults) Executes the actual query to retrieve the list of results.executeSingleResult
(CommandContext commandContext) list()
Executes the query and get a list of entities as the result.listPage
(int firstResult, int maxResults) Executes the query and get a list of entities as the result.Add parameter to be replaced in query for index, e.g.setCommandExecutor
(CommandExecutor commandExecutor) Executes the query and returns the resulting entity or null if no entity matches the query criteria.Hand in the SQL statement you want to execute.
-
Field Details
-
commandExecutor
-
commandContext
-
maxResults
protected int maxResults -
firstResult
protected int firstResult -
resultType
protected org.camunda.bpm.engine.impl.AbstractNativeQuery.ResultType resultType
-
-
Constructor Details
-
AbstractNativeQuery
-
AbstractNativeQuery
-
-
Method Details
-
setCommandExecutor
-
sql
Description copied from interface:NativeQuery
Hand in the SQL statement you want to execute. BEWARE: if you need a count you have to hand in a count() statement yourself, otherwise the result will be treated as lost of Activiti entities. If you need paging you have to insert the pagination code yourself. We skipped doing this for you as this is done really different on some databases (especially MS-SQL / DB2)- Specified by:
sql
in interfaceNativeQuery<T extends NativeQuery<?,
?>, U>
-
parameter
Description copied from interface:NativeQuery
Add parameter to be replaced in query for index, e.g. :param1, :myParam, ...- Specified by:
parameter
in interfaceNativeQuery<T extends NativeQuery<?,
?>, U>
-
singleResult
Description copied from interface:NativeQuery
Executes the query and returns the resulting entity or null if no entity matches the query criteria.- Specified by:
singleResult
in interfaceNativeQuery<T extends NativeQuery<?,
?>, U>
-
list
Description copied from interface:NativeQuery
Executes the query and get a list of entities as the result.- Specified by:
list
in interfaceNativeQuery<T extends NativeQuery<?,
?>, U>
-
listPage
Description copied from interface:NativeQuery
Executes the query and get a list of entities as the result.- Specified by:
listPage
in interfaceNativeQuery<T extends NativeQuery<?,
?>, U>
-
count
public long count()Description copied from interface:NativeQuery
Executes the query and returns the number of results- Specified by:
count
in interfaceNativeQuery<T extends NativeQuery<?,
?>, U>
-
execute
- Specified by:
execute
in interfaceCommand<T extends NativeQuery<?,
?>>
-
executeCount
-
executeList
public abstract List<U> executeList(CommandContext commandContext, Map<String, Object> parameterMap, int firstResult, int maxResults) Executes the actual query to retrieve the list of results.- Parameters:
maxResults
-firstResult
-page
- used if the results must be paged. If null, no paging will be applied.
-
executeSingleResult
-
getParameters
-