SpringBoot和JPA使用SQLServer2008数据库搭建后台的时候排序报错

一般的排序代码是这样的

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