org.hibernate.criterion
Class SQLProjection

java.lang.Object
  extended by org.hibernate.criterion.SQLProjection
All Implemented Interfaces:
Serializable, Projection

public class SQLProjection
extends Object
implements Projection

A SQL fragment. The string {alias} will be replaced by the alias of the root entity.

See Also:
Serialized Form

Constructor Summary
protected SQLProjection(String sql, String[] columnAliases, Type[] types)
           
protected SQLProjection(String sql, String groupBy, String[] columnAliases, Type[] types)
           
 
Method Summary
 String[] getAliases()
          Get the criteria-level aliases for this projection (ie.
 String[] getColumnAliases(int loc)
          Get the SQL column aliases used by this projection for the columns it writes for inclusion into the SELECT clause (Projection.toSqlString(org.hibernate.Criteria, int, org.hibernate.criterion.CriteriaQuery).
 String[] getColumnAliases(String alias, int loc)
          Get the SQL column aliases used by this projection for the columns it writes for inclusion into the SELECT clause (Projection.toSqlString(org.hibernate.Criteria, int, org.hibernate.criterion.CriteriaQuery) for a particular criteria-level alias.
 Type[] getTypes(Criteria crit, CriteriaQuery criteriaQuery)
          Types returned by the rendered SQL fragment.
 Type[] getTypes(String alias, Criteria crit, CriteriaQuery criteriaQuery)
          Get the return types for a particular user-visible alias.
 boolean isGrouped()
          Is this projection fragment (SELECT clause) also part of the GROUP BY
 String toGroupSqlString(Criteria criteria, CriteriaQuery criteriaQuery)
          Render the SQL fragment to be used in the GROUP BY clause
 String toSqlString(Criteria criteria, int loc, CriteriaQuery criteriaQuery)
          Render the SQL fragment to be used in the SELECT clause.
 String toString()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

SQLProjection

protected SQLProjection(String sql,
                        String[] columnAliases,
                        Type[] types)

SQLProjection

protected SQLProjection(String sql,
                        String groupBy,
                        String[] columnAliases,
                        Type[] types)
Method Detail

toSqlString

public String toSqlString(Criteria criteria,
                          int loc,
                          CriteriaQuery criteriaQuery)
                   throws HibernateException
Description copied from interface: Projection
Render the SQL fragment to be used in the SELECT clause.

Specified by:
toSqlString in interface Projection
Parameters:
criteria - The local criteria to which this project is attached (for resolution).
loc - The number of columns rendered in the SELECT clause before this projection. Generally speaking this is useful to ensure uniqueness of the individual columns aliases.
criteriaQuery - The overall criteria query instance.
Returns:
The SQL fragment to plug into the SELECT
Throws:
HibernateException - Indicates a problem performing the rendering

toGroupSqlString

public String toGroupSqlString(Criteria criteria,
                               CriteriaQuery criteriaQuery)
                        throws HibernateException
Description copied from interface: Projection
Render the SQL fragment to be used in the GROUP BY clause

Specified by:
toGroupSqlString in interface Projection
Parameters:
criteria - The local criteria to which this project is attached (for resolution).
criteriaQuery - The overall criteria query instance.
Returns:
The SQL fragment to plug into the GROUP BY
Throws:
HibernateException - Indicates a problem performing the rendering

getTypes

public Type[] getTypes(Criteria crit,
                       CriteriaQuery criteriaQuery)
                throws HibernateException
Description copied from interface: Projection
Types returned by the rendered SQL fragment. In other words what are the types that would represent the values this projection asked to be pulled into the result set?

Specified by:
getTypes in interface Projection
Parameters:
crit - The local criteria to which this project is attached (for resolution).
criteriaQuery - The overall criteria query instance.
Returns:
The return types.
Throws:
HibernateException - Indicates a problem resolving the types

toString

public String toString()
Overrides:
toString in class Object

getAliases

public String[] getAliases()
Description copied from interface: Projection
Get the criteria-level aliases for this projection (ie. the ones that will be passed to the ResultTransformer)

Specified by:
getAliases in interface Projection
Returns:
The aliases

getColumnAliases

public String[] getColumnAliases(int loc)
Description copied from interface: Projection
Get the SQL column aliases used by this projection for the columns it writes for inclusion into the SELECT clause (Projection.toSqlString(org.hibernate.Criteria, int, org.hibernate.criterion.CriteriaQuery). Hibernate always uses column aliases to extract data from the JDBC ResultSet, so it is important that these be implemented correctly in order for Hibernate to be able to extract these val;ues correctly.

Specified by:
getColumnAliases in interface Projection
Parameters:
loc - Just as in Projection.toSqlString(org.hibernate.Criteria, int, org.hibernate.criterion.CriteriaQuery), represents the number of columns rendered prior to this projection.
Returns:
The columns aliases.

isGrouped

public boolean isGrouped()
Description copied from interface: Projection
Is this projection fragment (SELECT clause) also part of the GROUP BY

Specified by:
isGrouped in interface Projection
Returns:
True if the projection is also part of the GROUP BY; false otherwise.

getTypes

public Type[] getTypes(String alias,
                       Criteria crit,
                       CriteriaQuery criteriaQuery)
Description copied from interface: Projection
Get the return types for a particular user-visible alias.

Differs from Projection.getTypes(org.hibernate.Criteria, CriteriaQuery) in that here we are only interested in the types related to the given criteria-level alias.

Specified by:
getTypes in interface Projection
Parameters:
alias - The criteria-level alias for which to find types.
crit - The local criteria to which this project is attached (for resolution).
criteriaQuery - The overall criteria query instance.
Returns:
The return types; expected to return null if this projection does not understand this alias.

getColumnAliases

public String[] getColumnAliases(String alias,
                                 int loc)
Description copied from interface: Projection
Get the SQL column aliases used by this projection for the columns it writes for inclusion into the SELECT clause (Projection.toSqlString(org.hibernate.Criteria, int, org.hibernate.criterion.CriteriaQuery) for a particular criteria-level alias.

Specified by:
getColumnAliases in interface Projection
Parameters:
alias - The criteria-level alias
loc - Just as in Projection.toSqlString(org.hibernate.Criteria, int, org.hibernate.criterion.CriteriaQuery), represents the number of columns rendered prior to this projection.
Returns:
The columns aliases pertaining to a particular criteria-level alias; expected to return null if this projection does not understand this alias.


Copyright © 2001-2010 Red Hat, Inc. All Rights Reserved.