[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2381) Criteria API : Order by Native SQL

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2381?page=c... ] Sami Dalouche commented on HHH-2381: ------------------------------------ OK, Here is a sample implementation of the Order class that can be used to produce Native SQL ORDER BY Clauses : public class NativeSQLOrder extends Order { private static final long serialVersionUID = 1L; private final static String PROPERTY_NAME = "uselessAnyways"; private boolean ascending; private String sql; protected NativeSQLOrder(String sql, boolean ascending) { super(PROPERTY_NAME, ascending); this.sql = sql; this.ascending = ascending; } @Override public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { StringBuilder fragment = new StringBuilder(); fragment.append("("); fragment.append(sql); fragment.append(")"); fragment.append(ascending ? " asc" : " desc"); return StringHelper.replace(fragment.toString(), "{alias}", criteriaQuery.getSQLAlias(criteria)); } } criteria.addOrder(new Order("whatever SQL using {alias}", true)); Regards, Sami Dalouche -- 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