1
14
15 package com.liferay.portal.dao.orm.hibernate;
16
17 import com.liferay.portal.kernel.util.StringBundler;
18
19
25 public class DB2Dialect extends org.hibernate.dialect.DB2Dialect {
26
27 public String getLimitString(String sql, boolean hasOffset) {
28 if (!sql.startsWith("(")) {
29 return super.getLimitString(sql, hasOffset);
30 }
31
32 StringBundler sb = new StringBundler(5);
33
34 sb.append("select cursor1.* from (");
35 sb.append("select rownumber() over() as rownumber_, cursor2.* from (");
36 sb.append(sql);
37 sb.append(") as cursor2) as cursor1 where rownumber_");
38
39 if (hasOffset) {
40 sb.append(" between ? + 1 and ?");
41 }
42 else {
43 sb.append(" <= ?");
44 }
45
46 return sb.toString();
47 }
48
49 }