[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1088?page=c... ] Michael Grünewald commented on HHH-1088: ---------------------------------------- Hi, I have the same problem. Hibernate just creates wrong SQl like this: "select this_.comment as y0_this_.name as y1_this_.type as y2_this_.year as y3_ from CountryModel this_" It recognizes that their is an compund key but don't use the right syntax. Cause: "select this_.comment as y0_, this_.name as y1_, this_.type as y2_, this_.year as y3_ from CountryModel this_" would be correct, just a separating comma and space are missing if more than one identifier is used. According to the source code from IdentifierProjection: public String toSqlString(Criteria criteria, int position, CriteriaQuery criteriaQuery) throws HibernateException { StringBuffer buf = new StringBuffer(); String[] cols = criteriaQuery.getIdentifierColumns(criteria); for ( int i=0; i<cols.length; i++ ) { buf.append( cols[i] ) .append(" as y") .append(position + i) .append('_'); } return buf.toString(); adding a simple if -statement should fix it : public String toSqlString(final Criteria criteria, final int position, CriteriaQuery criteriaQuery) throws HibernateException { final StringBuffer buf = new StringBuffer(); final String[] cols = criteriaQuery.getIdentifierColumns(criteria); for (int i = 0, n = cols.length; i < n; i++) { buf.append(cols[i]).append(" as y").append(position + i).append('_'); if (i < n - 1) { buf.append(", "); } } return buf.toString(); } } IMHO projections to compound keys makes sense, to avoid manual SQL-Queries especially with eager realations, if you need all key attributes to provide a dialog which the user can choose from. So if someone can please change the code. Thanks a lot. Greetings Michael -- 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