SQLServer异常
0
org.springframework.jdbc.UncategorizedSQLException:
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'.
### The error may exist in file [****Mapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT TOP ? site.ConfSiteId as SiteId, conf.Name, conf.ConfGuid, conf.ConfType, state.StartTime, state.EndFactTime as EndTime, state.ConfTimeSpan as TimeSpan, conf.CreatUser as CreateUser, site.Name as DeviceName, device.Guid as DeviceGuid, joinTime.SiteName, joinTime.Duration, joinTime.JoinTime, joinTime.LeaveTime FROM ScheConf conf LEFT JOIN ScheConfState state ON conf.ConfId = state.ConfId LEFT JOIN ScheConfSite site ON conf.ConfId = site.ConfId LEFT JOIN Device device ON site.Name = device.Name LEFT JOIN ScheConfSiteJoinTime joinTime ON site.ConfSiteId = joinTime.SiteId WHERE conf.IsDel = 0 AND site.IsDel = 0 AND device.IsDel = 0 AND site.ConfSiteId > ? ORDER BY site.ConfSiteId DESC
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'.
; uncategorized SQLException; SQL state [S0001]; error code [102]; Incorrect syntax near '@P0'.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'.
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy170.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at com.sun.proxy.$Proxy207.selectMeeting(Unknown Source)
SQLServer
错误:
SELECT TOP #{size}
改为:
SELECT TOP (#{size})