[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-817) using projections is causing SQL query error on oracle (ORA-00904 error)

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-817?page=co... ] Chris Federowicz commented on HHH-817: -------------------------------------- I have a workaround that has worked for me in basic examples. Basically i'm using projections and the alias to bean transformer fo only load selected properties of an entity. // Set up selected columns to load of the entity ProjectionList projectionList = Projections.projectionList(); projectionList.add(new CustomPropertyAliasProjection("property1", "property1")); projectionList.add(new CustomPropertyAliasProjection("property2", "property2")); criteria.setProjection(projectionList); criteria.setResultTransformer(new PrefixAliasToBeanResultTransformer(entityClass)); // Now I can use this without getting the ORA-00904 error criteria.add(Restrictions.eq("property1", new Integer(1))); Here's the class I wrote to override AliasedProjection. I can't guarantee it works in all cases. It would be great if someone from the Hibernate team can take a quick look and see if there are any potential problems that I've overlooked. /** * Customized projection to map a property with an alias that is intended to work-around HHH-817. * This works in a basic situation that I've tried, but I can't guarantee it works in complex queries. * * This causes the alias to be bypassed in the where clause so the original column name is used. * Some DB's don't support aliases in the where clause. * * http://opensource.atlassian.com/projects/hibernate/browse/HHH-817 * * @author Chris Federowicz */ public class CustomPropertyAliasProjection extends AliasedProjection { /** Stores the property name being aliased. */ private String propertyName; /** Stores the column name for the property in the PropertyProjection. */ private String propertyColumn; /** * @param propertyName the property name * @param alias alias of the property */ public CustomPropertyAliasProjection(String propertyName, String alias) { super(Projections.property(propertyName), alias); this.propertyName = propertyName; } /** Default serialization ID. */ private static final long serialVersionUID = 1L; /** * @see org.hibernate.criterion.AliasedProjection#toSqlString(org.hibernate.Criteria, int, org.hibernate.criterion.CriteriaQuery) */ public String toSqlString(Criteria criteria, int position, CriteriaQuery criteriaQuery) throws HibernateException { String ret = super.toSqlString(criteria, position, criteriaQuery); // Store the property's real column for use in getColumnAliases propertyColumn = criteriaQuery.getColumn(criteria, propertyName); return ret; } /** * Override to use the property's column if we have it (which we should). * Hack alert: This assumes that toSqlString gets called beforehand, which seems to be the case. * * @see org.hibernate.criterion.AliasedProjection#getColumnAliases(java.lang.String, int) */ public String[] getColumnAliases(String alias, int loc) { return propertyColumn != null ? new String[] {propertyColumn} : super.getColumnAliases(alias, loc); } } -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira