<select id="getProvince" resultType="java.util.Map">
select provinceid,province
from provinces
order by convert(province using gbk)
</select>以上sql数据库执行正常,在程序里mybatis-plus执行报错,错误信息如下:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, please exclude the tableName or statementId.
Error SQL: select provinceid,province,CONVERT(province USING gbk) as a
from provinces
order by a
### The error may exist in file [E:\CITC\zxgd_back\blade-service\blade-user\target\classes\org\springblade\system\user\mapper\UserMapper.xml]
### The error may involve org.springblade.system.user.mapper.UserMapper.getProvince
### The error occurred while executing a query
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, please exclude the tableName or statementId.
Error SQL: select provinceid,province,CONVERT(province USING gbk) as a
from provinces
order by a
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy168.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:158)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:76)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62)
at com.sun.proxy.$Proxy169.getProvince(Unknown Source)
select provinceid,province
from provinces
order by convert(province using gbk)
</select>以上sql数据库执行正常,在程序里mybatis-plus执行报错,错误信息如下:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, please exclude the tableName or statementId.
Error SQL: select provinceid,province,CONVERT(province USING gbk) as a
from provinces
order by a
### The error may exist in file [E:\CITC\zxgd_back\blade-service\blade-user\target\classes\org\springblade\system\user\mapper\UserMapper.xml]
### The error may involve org.springblade.system.user.mapper.UserMapper.getProvince
### The error occurred while executing a query
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, please exclude the tableName or statementId.
Error SQL: select provinceid,province,CONVERT(province USING gbk) as a
from provinces
order by a
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy168.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:158)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:76)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62)
at com.sun.proxy.$Proxy169.getProvince(Unknown Source)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货