[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2681) Aggregate projection aliases should not be applied to where-clause

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2681?page=c... ] nhhockeyplayer commented on HHH-2681: ------------------------------------- Well it prevents us from operating our web app framework. We cannot perform simple inheritence Person--<>-----Officer Person.JAVA @PropertyDescriptor(summary = true, index = 4) @NotNull public String getLastName() { return lastName; } If this stuff is shutting down whole frameworks why doesn't someone increase the priority. ? You may continue by restarting the session. [ +/- ] Exception: could not initialize a collection: [org.trails.demo.Corporation.officers#1] org.apache.hivemind.ApplicationRuntimeException could not initialize a collection: [org.trails.demo.Corporation.officers#1] component: $HibernateEditPage_41@3c1[DefaultEdit] location: context:/WEB-INF/DefaultEdit.page, line 2, column 63 1 <!DOCTYPE page-specification PUBLIC "-//Apache Software Foundation//Tapestry Specification 4.0//EN" "http://jakarta.apache.org/tapestry/dtd/Tapestry_4_0.dtd"> 2 <page-specification class="org.trails.page.HibernateEditPage"> 3 <property name="model" persist="session"/> 4 <property name="nextPage"/> 5 6 <property name="delegator"/> 7 [ +/- ] Exception: could not initialize a collection: [org.trails.demo.Corporation.officers#1] org.hibernate.exception.SQLGrammarException could not initialize a collection: [org.trails.demo.Corporation.officers#1] SQL: select officers0_.officer_corporation_fk as officer26_2_, officers0_.id as id2_, officers0_.id as id2_1_, officers0_.accessed as accessed2_1_, officers0_.accountNonExpired as accountN4_2_1_, officers0_.accountNonLocked as accountN5_2_1_, officers0_.created as created2_1_, officers0_.credentialsNonExpired as credenti7_2_1_, officers0_.address as address2_1_, officers0_.cellPhone as cellPhone2_1_, officers0_.city as city2_1_, officers0_.country as country2_1_, officers0_.dayPhone as dayPhone2_1_, officers0_.state as state2_1_, officers0_.website as website2_1_, officers0_.zip as zip2_1_, officers0_.dob as dob2_1_, officers0_.emailAddress as emailAd17_2_1_, officers0_.enabled as enabled2_1_, officers0_.firstName as firstName2_1_, officers0_.lastName as lastName2_1_, officers0_.password as password2_1_, officers0_.photo_id as photo24_2_1_, officers0_.username as username2_1_, officers0_.officer_corporation_fk as officer26_2_1_, uploadable1_.id as id3_0_, uploadable1_.accessed as accessed3_0_, uploadable1_.bytes as bytes3_0_, uploadable1_.contentType as contentT4_3_0_, uploadable1_.created as created3_0_, uploadable1_.description as descript6_3_0_, uploadable1_.fileExtension as fileExte7_3_0_, uploadable1_.fileName as fileName3_0_, uploadable1_.filePath as filePath3_0_, uploadable1_.mediaType as mediaType3_0_, uploadable1_.name as name3_0_, uploadable1_.numBytes as numBytes3_0_ from Person officers0_ left outer join UploadableMedia uploadable1_ on officers0_.photo_id=uploadable1_.id where officers0_.officer_corporation_fk=? order by Person.lastName asc SQLState: 42S22 errorCode: 1054 messages: * could not initialize a collection: [org.trails.demo.Corporation.officers#1] * Unknown column 'Person.lastName' in 'order clause' throwableCount: 2 throwables: * org.hibernate.exception.SQLGrammarException: could not initialize a collection: [org.trails.demo.Corporation.officers#1] * com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'Person.lastName' in 'order clause' [ +/- ] Exception: Unknown column 'Person.lastName' in 'order clause' com.mysql.jdbc.exceptions.MySQLSyntaxErrorException Unknown column 'Person.lastName' in 'order clause' SQLState: 42S22 errorCode: 1054 Stack Trace: com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) com.mysql.jdbc.Connection.execSQL(Connection.java:3256) com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313) com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448) org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) org.hibernate.jdbc.AbstractBatcher.getResultSet(Abstrac -- 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