Package org.flowable.common.engine.impl.query

Class BaseNativeQuery<T extends NativeQuery<?,?>,U>

java.lang.Object

org.flowable.common.engine.impl.query.BaseNativeQuery<T,U>

All Implemented Interfaces:

Serializable, NativeQuery<T,U>

Direct Known Subclasses:

AbstractNativeQuery

public abstract class BaseNativeQuery<T extends NativeQuery<?,?>,U>
extends Object
implements NativeQuery<T,U>, Serializable

See Also:

• Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
protected static enum	BaseNativeQuery.ResultType

Field Summary

Fields

Modifier and Type	Field	Description
protected int	firstResult
protected int	maxResults
protected Map<String,Object>	parameters
protected BaseNativeQuery.ResultType	resultType
protected String	sqlStatement

Constructor Summary

Constructors

Constructor	Description
BaseNativeQuery()

Method Summary

Modifier and Type	Method	Description
protected Map<String,Object>	generateParameterMap()
Map<String,Object>	getParameters()
T	parameter(String name, Object value)	Add parameter to be replaced in query for index, e.g.
T	sql(String sqlStatement)	Hand in the SQL statement you want to execute.

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.flowable.common.engine.api.query.NativeQuery

count, list, listPage, singleResult

Field Details

maxResults

protected int maxResults

firstResult

protected int firstResult

resultType

protected BaseNativeQuery.ResultType resultType

parameters

protected Map<String,Object> parameters

sqlStatement

protected String sqlStatement

Constructor Details

BaseNativeQuery

public BaseNativeQuery()

Method Details

sql

public T sql(String sqlStatement)

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 Flowable 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 interface NativeQuery<T extends NativeQuery<?,?>,U>

parameter

public T parameter(String name,
 Object value)

Description copied from interface: NativeQuery

Add parameter to be replaced in query for index, e.g. :param1, :myParam, ...

Specified by:

parameter in interface NativeQuery<T extends NativeQuery<?,?>,U>

generateParameterMap

protected Map<String,Object> generateParameterMap()

getParameters

public Map<String,Object> getParameters()