当前使用版本(必填,否则不予处理)
3.5.3.1
该问题是如何引起的?(确定最新版也有问题再提!!!)
升级3.5.3.1,springboot3,java17
重现步骤(如果有就写完整)
报错信息
org.springframework.jdbc.BadSqlGrammarException:
Error querying database. Cause: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: FORECAST_RESULT_B in statement [SELECT id,range FROM forecast_result_b]
The error may exist in org/hrc/swj/models/mapper/ForecastResultBMapper.java (best guess)
The error may involve org.hrc.swj.models.mapper.ForecastResultBMapper.selectList
The error occurred while executing a query
SQL: SELECT id,range FROM forecast_result_b
Cause: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: FORECAST_RESULT_B in statement [SELECT id,range FROM forecast_result_b]
; bad SQL grammar [] at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:101) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at jdk.proxy2/jdk.proxy2.$Proxy77.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 jdk.proxy2/jdk.proxy2.$Proxy107.selectList(Unknown Source) at org.hrc.swj.models.GridxajApplicationTests.test(GridxajApplicationTests.java:19) at java.base/java.util.ArrayList.forEach(Unknown Source) at java.base/java.util.ArrayList.forEach(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: FORECAST_RESULT_B in statement [SELECT id,range FROM forecast_result_b] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
Comment From: miemieYaho
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)?
Comment From: dirac921
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)?
用了动态数据源,也要更新版本,现在可以了