org.hibernate.impl

Class SQLQueryImpl

Implemented Interfaces:
Query, SQLQuery

public class SQLQueryImpl
extends AbstractQueryImpl
implements SQLQuery

Implements SQL query passthrough.
 
 
   SELECT {person}.NAME AS {person.name}, {person}.AGE AS {person.age}, {person}.SEX AS {person.sex}
   FROM PERSON {person} WHERE {person}.NAME LIKE 'Hiber%'
 
 
Author:
Max Andersen

Field Summary

Fields inherited from class org.hibernate.impl.AbstractQueryImpl

parameterMetadata, session

Method Summary

SQLQuery
addEntity(Class entityClass)
SQLQuery
addEntity(String entityName)
SQLQuery
addEntity(String alias, Class entityClass)
SQLQuery
addEntity(String alias, Class entityClass, LockMode lockMode)
SQLQuery
addEntity(String alias, String entityName)
SQLQuery
addEntity(String alias, String entityName, LockMode lockMode)
SQLQuery
addJoin(String alias, String path)
SQLQuery
addJoin(String alias, String path, LockMode lockMode)
SQLQuery
addScalar(String columnAlias)
SQLQuery
addScalar(String columnAlias, Type type)
SQLQuery
addSynchronizedEntityClass(Class entityClass)
SQLQuery
addSynchronizedEntityName(String entityName)
SQLQuery
addSynchronizedQuerySpace(String querySpace)
int
executeUpdate()
Execute the update or delete statement.
protected Map
getLockModes()
QueryParameters
getQueryParameters(Map namedParams)
String[]
getReturnAliases()
Return the HQL select clause aliases (if any)
Type[]
getReturnTypes()
Return the Hibernate types of the query result set.
Iterator
iterate()
Return the query results as an Iterator.
List
list()
Return the query results as a List.
ScrollableResults
scroll()
Return the query results as ScrollableResults.
ScrollableResults
scroll(ScrollMode scrollMode)
Return the query results as ScrollableResults.
Query
setLockMode(String alias, LockMode lockMode)
Set the lockmode for the objects idententified by the given alias that appears in the FROM clause.
SQLQuery
setResultSetMapping(String name)
protected void
verifyParameters()

Methods inherited from class org.hibernate.impl.AbstractQueryImpl

after, before, determineType, determineType, determineType, determineType, determineType, expandParameterLists, getLockModes, getNamedParameterLists, getNamedParameters, getNamedParams, getQueryParameters, getQueryString, getReturnAliases, getReturnTypes, getRowSelection, getSelection, getTypes, getValues, hasNamedParameters, isReadOnly, setBigDecimal, setBigDecimal, setBigInteger, setBigInteger, setBinary, setBinary, setBoolean, setBoolean, setByte, setByte, setCacheMode, setCacheRegion, setCacheable, setCalendar, setCalendar, setCalendarDate, setCalendarDate, setCharacter, setCharacter, setCollectionKey, setComment, setDate, setDate, setDouble, setDouble, setEntity, setEntity, setFetchSize, setFirstResult, setFloat, setFloat, setFlushMode, setInteger, setInteger, setLocale, setLocale, setLong, setLong, setMaxResults, setOptionalEntityName, setOptionalId, setOptionalObject, setParameter, setParameter, setParameter, setParameter, setParameterList, setParameterList, setParameterList, setParameterList, setParameters, setProperties, setProperties, setReadOnly, setResultTransformer, setSerializable, setSerializable, setShort, setShort, setString, setString, setText, setText, setTime, setTime, setTimeout, setTimestamp, setTimestamp, toString, typeArray, uniqueResult, valueArray, verifyParameters, verifyParameters

Method Details

addEntity

public SQLQuery addEntity(Class entityClass)
Specified by:
addEntity in interface SQLQuery

addEntity

public SQLQuery addEntity(String entityName)
Specified by:
addEntity in interface SQLQuery

addEntity

public SQLQuery addEntity(String alias,
                          Class entityClass)
Specified by:
addEntity in interface SQLQuery

addEntity

public SQLQuery addEntity(String alias,
                          Class entityClass,
                          LockMode lockMode)
Specified by:
addEntity in interface SQLQuery

addEntity

public SQLQuery addEntity(String alias,
                          String entityName)
Specified by:
addEntity in interface SQLQuery

addEntity

public SQLQuery addEntity(String alias,
                          String entityName,
                          LockMode lockMode)
Specified by:
addEntity in interface SQLQuery

addJoin

public SQLQuery addJoin(String alias,
                        String path)
Specified by:
addJoin in interface SQLQuery

addJoin

public SQLQuery addJoin(String alias,
                        String path,
                        LockMode lockMode)
Specified by:
addJoin in interface SQLQuery

addScalar

public SQLQuery addScalar(String columnAlias)
Specified by:
addScalar in interface SQLQuery

addScalar

public SQLQuery addScalar(String columnAlias,
                          Type type)
Specified by:
addScalar in interface SQLQuery

addSynchronizedEntityClass

public SQLQuery addSynchronizedEntityClass(Class entityClass)
Specified by:
addSynchronizedEntityClass in interface SQLQuery

addSynchronizedEntityName

public SQLQuery addSynchronizedEntityName(String entityName)
Specified by:
addSynchronizedEntityName in interface SQLQuery

addSynchronizedQuerySpace

public SQLQuery addSynchronizedQuerySpace(String querySpace)
Specified by:
addSynchronizedQuerySpace in interface SQLQuery

executeUpdate

public int executeUpdate()
            throws HibernateException
Execute the update or delete statement. The semantics are compliant with the ejb3 Query.executeUpdate() method.
Specified by:
executeUpdate in interface Query
Returns:
The number of entities updated or deleted.

getLockModes

protected Map getLockModes()
Overrides:
getLockModes in interface AbstractQueryImpl

getQueryParameters

public QueryParameters getQueryParameters(Map namedParams)
Overrides:
getQueryParameters in interface AbstractQueryImpl

getReturnAliases

public String[] getReturnAliases()
            throws HibernateException
Return the HQL select clause aliases (if any)
Specified by:
getReturnAliases in interface Query
Overrides:
getReturnAliases in interface AbstractQueryImpl
Returns:
an array of aliases as strings

getReturnTypes

public Type[] getReturnTypes()
            throws HibernateException
Return the Hibernate types of the query result set.
Specified by:
getReturnTypes in interface Query
Overrides:
getReturnTypes in interface AbstractQueryImpl
Returns:
an array of types

iterate

public Iterator iterate()
            throws HibernateException
Return the query results as an Iterator. If the query contains multiple results pre row, the results are returned in an instance of Object[].

Entities returned as results are initialized on demand. The first SQL query returns identifiers only.
Specified by:
iterate in interface Query
Returns:
the result iterator

list

public List list()
            throws HibernateException
Return the query results as a List. If the query contains multiple results pre row, the results are returned in an instance of Object[].
Specified by:
list in interface Query
Returns:
the result list

scroll

public ScrollableResults scroll()
            throws HibernateException
Return the query results as ScrollableResults. The scrollability of the returned results depends upon JDBC driver support for scrollable ResultSets.
Specified by:
scroll in interface Query
Returns:
the result iterator

scroll

public ScrollableResults scroll(ScrollMode scrollMode)
            throws HibernateException
Return the query results as ScrollableResults. The scrollability of the returned results depends upon JDBC driver support for scrollable ResultSets.
Specified by:
scroll in interface Query
Returns:
the result iterator

setLockMode

public Query setLockMode(String alias,
                         LockMode lockMode)
Set the lockmode for the objects idententified by the given alias that appears in the FROM clause.
Specified by:
setLockMode in interface Query
Parameters:
alias - a query alias, or this for a collection filter

setResultSetMapping

public SQLQuery setResultSetMapping(String name)
Specified by:
setResultSetMapping in interface SQLQuery

verifyParameters

protected void verifyParameters()
Overrides:
verifyParameters in interface AbstractQueryImpl