|
Thanks for suggestions and input.
We can created DB2ZOSDialect with following code and its working fine for pagination queries
public class DB2ZOSDialect extends DB2Dialect {
public String getSequenceNextValString(String sequenceName) { return "SELECT NEXT VALUE FOR " + sequenceName + " FROM SYSIBM.SYSDUMMY1"; }
public String getLimitString(String sql, int offset, int limit) {
if ( offset == 0 ) { return sql + " fetch first " + limit + " rows only"; }
//nest the main query in an outer select
return "select * from ( select inner2_.*, rownumber() over() as rownumber_ from ( " + sql + " fetch first " + limit + " rows only ) as inner2_ ) as inner1_ where rownumber_ > " + offset + " order by rownumber_";
}}
|
