Hibernate: select distinct user0_.ID as ID10_, user0_.EMAIL as EMAIL10_, user0_.FIRSTNAME as FIRSTNAME10_, user0_.LASTNAME as LASTNAME10_,  user0_.ROLE as ROLE10_, user0_.USERNAME as USERNAME10_ from XY.XUSER user0_ where user0_.ROLE=? order by user0_.LASTNAME
2008-04-07 15:56:25,937 WARN  [http-8080-2] org.hibernate.util.JDBCExceptionReporter: SQL Error: -1, SQLState: 42879
2008-04-07 15:56:25,937 ERROR [http-8080-2] org.hibernate.util.JDBCExceptionReporter: The ORDER BY clause may not contain column 'LASTNAME', since the query specifies DISTINCT and that column does not appear in the query result.

String queryString = "select distinct o from User o where o.role = :role order by o.lastName";
Query query = em.createQuery(queryString);
query.setParameter("role", role);
return query.getResultList();