解决hibernate order by bug_hibernate xml配置添加orderby-CSDN博客

1.在hibernate.cfg.xml添加配置如下：

<property name="hibernate.dialect">
com.xxx.common.MyOracle10gDialect
</property>

2.代码：

package com.kangsi.common;

import org.hibernate.dialect.Oracle10gDialect;

public class MyOracle10gDialect extends Oracle10gDialect {

public String getLimitString(String sql, boolean hasOffset) {
   sql = sql.trim();
   boolean isForUpdate = false;
   if ( sql.toLowerCase().endsWith(" for update") ) {
    sql = sql.substring( 0, sql.length()-11 );
    isForUpdate = true;
   }

   StringBuffer pagingSelect = new StringBuffer( sql.length()+100 );
   if (hasOffset) {
    pagingSelect.append("select * from ( select row_.*, rownum rownum_ from ( ");
   }
   else {
    pagingSelect.append("select * from ( select row_.*, rownum rownum_ from ( ");
   }
   pagingSelect.append(sql);
   if (hasOffset) {
    pagingSelect.append(" ) row_) where rownum_<=? and rownum_ > ?");
   }
   else {
    pagingSelect.append(" ) row_) where rownum_<=? ");
   }

   if ( isForUpdate ) {
    pagingSelect.append( " for update" );
   }

return pagingSelect.toString();
}
}