hibernate的db2方言分页问题

hibernate的db2方言分页.比如 from InsurDocument t where 1=1 order by createTime desc 会解析成:

select * from ( select rownumber() over(order by createTime desc) as rownumber_, t.* from InsurDocument t where 1=1  order by createTime desc ) as temp_ where rownumber_ between ?+1 and ?

 

另外如果是jdbc时，它地枚举支持不太好，需要手工将其转成string型,还有如果通过select * from InsurDocument t访问时会报错，因为它解析成:

select * from ( select rownumber() over(order by createTime desc) as rownumber_, * from InsurDocument  where 1=1  order by createTime desc ) as temp_ where rownumber_ between ?+1 and ?

*前需加一个表名如t. 这样就会没问题。