使用sqlserver数据库时关于查询语法OFFSET的错误

Blade 已结

关注举报

 1  197

pjf 剑童 2025-03-10 15:32

一、该问题的重现步骤是什么？

1.使用的数据库类型的sqlserver

2. 启动后点击点击前端的通知通告等多个页面时会报错，具体错误看堆栈信息

二、你期待的结果是什么？实际看到的又是什么？

如果避免查询语句OFFSET的错误，是需要修改配置还是针对每一个使用的OFFSET的查询语句进行修改

三、你正在使用的是什么产品，什么版本？在什么操作系统上？

使用的是bladex-boot

4.4.0.RELEASE

在window11系统上

四、请提供详细的错误堆栈信息，这很重要。

org.springframework.jdbc.UncategorizedSQLException:

### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “OFFSET”附近有语法错误。

### The error may exist in org/springblade/modules/desk/mapper/NoticeMapper.java (best guess)

### The error may involve defaultParameterMap

### The error occurred while setting parameters

### SQL: SELECT id, title, category, release_time, content, tenant_id, create_user, create_dept, create_time, update_user, update_time, status, is_deleted FROM blade_notice WHERE is_deleted = 0 OFFSET ? ROWS FETCH NEXT ? ROWS ONLY

### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “OFFSET”附近有语法错误。

; uncategorized SQLException; SQL state [S0001]; error code [102]; “OFFSET”附近有语法错误。

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:94)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:347)

at jdk.proxy2/jdk.proxy2.$Proxy143.selectList(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:194)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:164)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)

at jdk.proxy2/jdk.proxy2.$Proxy162.selectList(Unknown Source)

at com.baomidou.mybatisplus.core.mapper.BaseMapper.selectPage(BaseMapper.java:458)

at java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:732)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:166)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)

at jdk.proxy2/jdk.proxy2.$Proxy162.selectPage(Unknown Source)

at com.baomidou.mybatisplus.extension.service.IService.page(IService.java:449)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:569)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)

at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:174)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)

at org.springblade.modules.desk.service.impl.NoticeServiceImpl$$SpringCGLIB$$0.page(<generated>)

at org.springblade.modules.desk.controller.NoticeController.list(NoticeController.java:92)