How to use

translateOrderBy

method

in

org.hibernate.sql.Template

public static String renderOrderByStringTemplate(
    String orderByFragment,
    final ColumnMapper columnMapper,
    final SessionFactoryImplementor sessionFactory,
    final Dialect dialect,
    final SQLFunctionRegistry functionRegistry) {
  return translateOrderBy(
      orderByFragment,
      columnMapper,
      sessionFactory,
      dialect,
      functionRegistry
  ).injectAliases( LEGACY_ORDER_BY_ALIAS_RESOLVER );
}

while( fragmentIterator.hasNext() ) {
  final Pair<String, String> fragment = fragmentIterator.next();
  final OrderByTranslation orderByFragmentTranslation = Template.translateOrderBy(
      fragment.getSecond(),
      new ColumnMapper() {

if ( hasOrder ) {
  LOG.debugf( "Translating order-by fragment [%s] for collection role : %s",  collectionBinding.getOrderBy(), getRole() );
  orderByTranslation = Template.translateOrderBy(
      collectionBinding.getOrderBy(),
      new ColumnMapperImpl(),
if ( hasManyToManyOrder ) {
  LOG.debugf( "Translating many-to-many order-by fragment [%s] for collection role : %s",  collectionBinding.getOrderBy(), getRole() );
  manyToManyOrderByTranslation = Template.translateOrderBy(
      collectionBinding.getManyToManyOrdering(),
      new ColumnMapperImpl(),