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();

  } }