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})