tanyp588 opened a new issue, #28991:
URL: https://github.com/apache/shardingsphere/issues/28991
Error querying database. Cause: java.sql.SQLException: Table 't_dict'
doesn't exist
### The error may exist in com/dongguo/shardingjdbc/mapper/DictMapper.java
(best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,dict_type FROM t_dict
### Cause: java.sql.SQLException: Table 't_dict' doesn't exist
; bad SQL grammar []; nested exception is java.sql.SQLException: Table
't_dict' doesn't exist
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLException: Table 't_dict'
doesn't exist
### The error may exist in com/dongguo/shardingjdbc/mapper/DictMapper.java
(best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,dict_type FROM t_dict
### Cause: java.sql.SQLException: Table 't_dict' doesn't exist
; bad SQL grammar []; nested exception is java.sql.SQLException: Table
't_dict' doesn't exist
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
~[spring-jdbc-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
~[spring-jdbc-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)
~[mybatis-spring-2.0.3.jar:2.0.3]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
~[mybatis-spring-2.0.3.jar:2.0.3]
at com.sun.proxy.$Proxy62.selectList(Unknown Source) ~[na:na]
at
org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)
~[mybatis-spring-2.0.3.jar:2.0.3]
at
com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177)
~[mybatis-plus-core-3.3.1.jar:3.3.1]
at
com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)
~[mybatis-plus-core-3.3.1.jar:3.3.1]
at
com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)
~[mybatis-plus-core-3.3.1.jar:3.3.1]
at com.sun.proxy.$Proxy69.selectList(Unknown Source) ~[na:na]
at
com.dongguo.shardingjdbc.controller.TestController.initData(TestController.java:42)
~[classes/:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
~[na:na]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:564) ~[na:na]
at
org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389)
~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333)
~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157)
~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:415)
~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1791)
~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594)
~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324)
~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897)
~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879)
~[spring-context-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551)
~[spring-context-5.2.15.RELEASE.jar:5.2.15.RELEASE]
at
org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143)
~[spring-boot-2.3.12.RELEASE.jar:2.3.12.RELEASE]
at
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:755)
~[spring-boot-2.3.12.RELEASE.jar:2.3.12.RELEASE]
at
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747)
~[spring-boot-2.3.12.RELEASE.jar:2.3.12.RELEASE]
at
org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:402)
~[spring-boot-2.3.12.RELEASE.jar:2.3.12.RELEASE]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:312)
~[spring-boot-2.3.12.RELEASE.jar:2.3.12.RELEASE]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1247)
~[spring-boot-2.3.12.RELEASE.jar:2.3.12.RELEASE]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1236)
~[spring-boot-2.3.12.RELEASE.jar:2.3.12.RELEASE]
at
com.dongguo.shardingjdbc.ShardingJdbcDemoApplication.main(ShardingJdbcDemoApplication.java:10)
~[classes/:na]
Caused by: java.sql.SQLException: Table 't_dict' doesn't exist
at
org.apache.shardingsphere.dialect.mysql.mapper.MySQLDialectExceptionMapper.toSQLException(MySQLDialectExceptionMapper.java:120)
~[shardingsphere-mysql-dialect-exception-5.4.0.jar:5.4.0]
at
org.apache.shardingsphere.dialect.mysql.mapper.MySQLDialectExceptionMapper.convert(MySQLDialectExceptionMapper.java:72)
~[shardingsphere-mysql-dialect-exception-5.4.0.jar:5.4.0]
at
org.apache.shardingsphere.dialect.SQLExceptionTransformEngine.toSQLException(SQLExceptionTransformEngine.java:59)
~[shardingsphere-dialect-exception-core-5.4.0.jar:5.4.0]
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.execute(ShardingSpherePreparedStatement.java:416)
~[shardingsphere-jdbc-core-5.4.0.jar:5.4.0]
at
com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
~[HikariCP-3.4.5.jar:na]
at
com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
~[HikariCP-3.4.5.jar:na]
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
~[mybatis-3.5.3.jar:3.5.3]
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
~[mybatis-3.5.3.jar:3.5.3]
at
com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:67)
~[mybatis-plus-core-3.3.1.jar:3.3.1]
at
org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
~[mybatis-3.5.3.jar:3.5.3]
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
~[mybatis-3.5.3.jar:3.5.3]
at
com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:163)
~[mybatis-plus-core-3.3.1.jar:3.3.1]
at
com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:90)
~[mybatis-plus-core-3.3.1.jar:3.3.1]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
~[mybatis-3.5.3.jar:3.5.3]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
~[mybatis-3.5.3.jar:3.5.3]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
~[na:na]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:564) ~[na:na]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
~[mybatis-spring-2.0.3.jar:2.0.3]
... 33 common frames omitted
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
