hibernate的db2方言分页问题

最新推荐文章于 2023-10-10 11:22:41 发布

dknypxt

最新推荐文章于 2023-10-10 11:22:41 发布

阅读量2k

点赞数

文章标签： hibernate db2 jdbc string

本文链接：https://blog.csdn.net/dknypxt/article/details/5719908

版权

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. 这样就会没问题。