Spring Data JPA DB2分页问题 [英] Issue with Spring data jpa Db2 pagination

问题描述

我将Spring JPA与DB2一起使用，当我使用分页存储库并查询第二页时，它将引发错误。
这是生成的查询

I am using Spring JPA with DB2, when i use paging repository and queries for second page it throws error. This is the generated query

SELECT * 
FROM   (SELECT inner2_.*, 
               ROWNUMBER() 
                 OVER( 
                   ORDER BY ORDER OF inner2_) AS rownumber_ 
        FROM   (SELECT db2DATAa0_.c_type AS col_0_0_, 
                       db2DATAa0_.h_proc AS col_1_0_, 
                       db2DATAa0_.n_vin  AS col_2_0_, 
                       db2DATAa0_.i_cust AS col_3_0_ 
                FROM   dcu.v_rpt_data_hist db2DATAa0_ 
                WHERE  db2DATAa0_.reportid = '0H000488089' 
                       AND ( db2DATAa0_.c_type = 'S' 
                              OR db2DATAa0_.c_type = 'N' 
                              OR db2DATAa0_.c_type = 'A' 
                              OR db2DATAa0_.c_type = 'T' ) 
                ORDER  BY db2DATAa0_.h_proc desc 
                FETCH first 30 ROWS only) AS inner2_) AS inner1_ 
WHERE  rownumber_ > 15 
ORDER  BY rownumber_ 

错误：
2719372 [2016-10-21 16：29：02,040] [RxCachedThreadScheduler-13] WARN org.hibern
ate.engine.jdbc.spi.SqlExceptionHelper-SQL错误：-199，SQLState： 42601
2719379 [2016-10-21 16：29：02,047] [RxCachedThreadScheduler-13]错误org.hibern
ate.engine.jdbc.spi.SqlExceptionHelper-DB2 SQL错误：SQLCODE = -199， SQLSTATE =
42601，SQLERRMC = OF; ??（[DESC ASC NULLS RANGE CONCAT || / MICROSECONDS MICROSECO
ND，DRIVER = 3.57.82

有什么想法吗？

推荐答案

此问题可以解决通过更改方言
将配置文件或属性文件中的方言更改为DB2ZOSDialect

This issue can be resolve by change dialect. Change dialect in configuration or property file to DB2ZOSDialect

这篇关于Spring Data JPA DB2分页问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！