public NamedSQLQueryDefinition(String query,
    String resultSetRef,
    List querySpaces,
    boolean cacheable,
    String cacheRegion,
    Integer timeout,
    Integer fetchSize,
    FlushMode flushMode,
    Map parameterTypes,
    boolean callable) 
{
		this(
				query,
				resultSetRef,
				querySpaces,
				cacheable,
				cacheRegion,
				timeout,
				fetchSize,
				flushMode,
				null,
				false,
				null,
				parameterTypes,
				callable
		);
}

This form used from annotations (?). Essentially the same as the above using a resultset-mapping reference, but without cacheMode, readOnly, and comment. FIXME: annotations do not use it, so it can be remove from my POV

Parameters:

query - The sql query string

resultSetRef - The result-set-mapping name

querySpaces - Any specified query spaces (used for auto-flushing)

cacheable - Whether the query results are cacheable

cacheRegion - If cacheable, the region into which to store the results

timeout - A JDBC-level timeout to be applied

fetchSize - A JDBC-level fetch-size to be applied

flushMode - The flush mode to use for this query

parameterTypes - parameter type map

callable - Does the query string represent a callable object (i.e., proc)

 public NamedSQLQueryDefinition(String query,
    NativeSQLQueryReturn[] queryReturns,
    List querySpaces,
    boolean cacheable,
    String cacheRegion,
    Integer timeout,
    Integer fetchSize,
    FlushMode flushMode,
    CacheMode cacheMode,
    boolean readOnly,
    String comment,
    Map parameterTypes,
    boolean callable) 
{
		super(
				query.trim(), /* trim done to workaround stupid oracle bug that cant handle whitespaces before a { in a sp */
				cacheable,
				cacheRegion,
				timeout,
				fetchSize,
				flushMode,
				cacheMode,
				readOnly,
				comment,
				parameterTypes
		);
		this.queryReturns = queryReturns;
		this.querySpaces = querySpaces;
		this.callable = callable;
}

This form used to construct a NamedSQLQueryDefinition from the binder code when a the result-set mapping information is explicitly provided in the query definition (i.e., no resultset-mapping used)

Parameters:

query - The sql query string

queryReturns - The in-lined query return definitions

querySpaces - Any specified query spaces (used for auto-flushing)

cacheable - Whether the query results are cacheable

cacheRegion - If cacheable, the region into which to store the results

timeout - A JDBC-level timeout to be applied

fetchSize - A JDBC-level fetch-size to be applied

flushMode - The flush mode to use for this query

cacheMode - The cache mode to use during execution and subsequent result loading

readOnly - Whether returned entities should be marked as read-only in the session

comment - Any sql comment to be applied to the query

parameterTypes - parameter type map

callable - Does the query string represent a callable object (i.e., proc)

 public NamedSQLQueryDefinition(String query,
    String resultSetRef,
    List querySpaces,
    boolean cacheable,
    String cacheRegion,
    Integer timeout,
    Integer fetchSize,
    FlushMode flushMode,
    CacheMode cacheMode,
    boolean readOnly,
    String comment,
    Map parameterTypes,
    boolean callable) 
{
		super(
				query.trim(), /* trim done to workaround stupid oracle bug that cant handle whitespaces before a { in a sp */
				cacheable,
				cacheRegion,
				timeout,
				fetchSize,
				flushMode,
				cacheMode,
				readOnly,
				comment,
				parameterTypes
		);
		this.resultSetRef = resultSetRef;
		this.querySpaces = querySpaces;
		this.callable = callable;
}

This form used to construct a NamedSQLQueryDefinition from the binder code when a resultset-mapping reference is used.

Parameters:

query - The sql query string

resultSetRef - The resultset-mapping name

querySpaces - Any specified query spaces (used for auto-flushing)

cacheable - Whether the query results are cacheable

cacheRegion - If cacheable, the region into which to store the results

timeout - A JDBC-level timeout to be applied

fetchSize - A JDBC-level fetch-size to be applied

flushMode - The flush mode to use for this query

cacheMode - The cache mode to use during execution and subsequent result loading

readOnly - Whether returned entities should be marked as read-only in the session

comment - Any sql comment to be applied to the query

parameterTypes - parameter type map

callable - Does the query string represent a callable object (i.e., proc)

 public NativeSQLQueryReturn[] getQueryReturns() 
{
		return queryReturns;
}

 public List getQuerySpaces() 
{
		return querySpaces;
}

 public String getResultSetRef() 
{
		return resultSetRef;
}

 public boolean isCallable() 
{
		return callable;
}