一般的排序代码是这样的
Sort sort = new Sort(Direction.ASC, "seq");
PageRequest pageRequest = PageRequest.of(Integer.valueOf(pageNumber) - 1, Integer.valueOf(pageSize), sort);
page = questionTypeService.findAll(pageRequest);
但是会报以下的错误
Hibernate: select questionty0_.questionTypeId as question1_3_, questionty0_.remark as remark2_3_, questionty0_.seq as seq3_3_, questionty0_.type as type4_3_, questionty0_.version as version5_3_ from question_type questionty0_ order by questionty0_.seq asc offset 0 rows fetch next ? rows only
2020-03-10 16:20:36.402 WARN 12036 --- [io-8080-exec-10] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 102, SQLState: S0001
2020-03-10 16:20:36.403 ERROR 12036 --- [io-8080-exec-10] o.h.engine.jdbc.spi.SqlExceptionHelper : Incorrect syntax near 'offset'.
看到报错语句中有offset 0 rows fetch next ? rows only这几个单词,嗯,很明显是因为不支持导致,在网上查了,说是SQLServer2012才支持的语法,因此,想必JPA的团队也会考虑到支持SQLServer2012以下的情形,继续往上找答案,最终是需要改配置文件,正确如下:
spring:
jpa:
# database: SQLSERVER
database-platform: org.hibernate.dialect.SQLServer2008Dialect