Hi,

When you use order + projection that create a SQL error :

Criteria criteria = session.createCriteria(A.class, "a");
criteria.createAlias("a.b", "b", JoinType.LEFT_OUTER_JOIN);
criteria.addOrder(Order.asc("b.code"));
criteria.setProjection(Projections.distinct(Projections.property("b")));

criteria.list();

Caused by: org.h2.jdbc.JdbcSQLException: Order by expression "B1_.CODE" must be in the result list in this case; SQL statement:
select distinct this_.b_id as y0_ from A this_ left outer join B b1_ on this_.b_id=b1_.id order by b1_.code asc [90068-190]

Note that works with mysql.

Regards,
Alexis GAYTE