wgijja opened a new issue, #25954:
URL: https://github.com/apache/shardingsphere/issues/25954
### yml.comfig
spring:
shardingsphere:
mode:
type: standalone
repository:
type: JDBC
# 指定 YAML 配置文件
dataSources:
ds_3312:
type: com.alibaba.druid.pool.DruidDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbcUrl: jdbc:mysql://192.168.188.128:3312/db_order
username: root
password: 123456
rules:
mySharding:
tables: # 数据分片规则配置
t_order: # 逻辑表名称
actualDataNodes: ds_3312.t_order$->{0..11}
tableStrategy: # 分表策略，同分库策略
standard: # 用于单分片键的标准分片场景
shardingColumn: order_no # 分片列名称
shardingAlgorithmName: t_order_inline # 分片算法名称
keyGenerateStrategy: # 分布式序列策略
column: id
keyGeneratorName: snowflake
# 分片算法配置
shardingAlgorithms:
t_order_inline: # 分片算法名称
type: INLINE # 分片算法类型
props: # 分片算法属性配置
algorithm-expression: t_order$->{order_no % 12} # ...
# 分布式序列算法配置
keyGenerators:
snowflake: # 分布式序列算法名称
type: SNOWFLAKE # 分布式序列算法类型
# ...
props:
sql-show: true
## SQL
@Select({"select * from t_order"})
List<Order> selectOrder();
### console print
2023-05-31 11:47:38.963 INFO 14564 --- [nio-9999-exec-1]
o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring
DispatcherServlet 'dispatcherServlet'
2023-05-31 11:47:38.963 INFO 14564 --- [nio-9999-exec-1]
o.s.web.servlet.DispatcherServlet : Initializing Servlet
'dispatcherServlet'
2023-05-31 11:47:38.963 INFO 14564 --- [nio-9999-exec-1]
o.s.web.servlet.DispatcherServlet : Completed initialization in 0 ms
2023-05-31 11:47:39.257 ERROR 14564 --- [nio-9999-exec-1]
o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet
[dispatcherServlet] in context with path [] threw exception [Request processing
failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause:
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "T_ORDER" not found (this
database is empty); SQL statement:
select * from t_order [42104-214]
### The error may exist in
com/leslie/shardingjdbcdemo/mapper/OrderMapper.java (best guess)
### The error may involve
com.leslie.shardingjdbcdemo.mapper.OrderMapper.selectOrder
### The error occurred while executing a query
### SQL: select * from t_order
### Cause: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "T_ORDER" not
found (this database is empty); SQL statement:
select * from t_order [42104-214]
; bad SQL grammar []; nested exception is
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "T_ORDER" not found (this
database is empty); SQL statement:
select * from t_order [42104-214]] with root cause
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "T_ORDER" not found (this
database is empty); SQL statement:
select * from t_order [42104-214]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
~[h2-2.1.214.jar:2.1.214]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
~[h2-2.1.214.jar:2.1.214]
at org.h2.message.DbException.get(DbException.java:223)
~[h2-2.1.214.jar:2.1.214]
at org.h2.message.DbException.get(DbException.java:199)
~[h2-2.1.214.jar:2.1.214]
at
org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8385)
~[h2-2.1.214.jar:2.1.214]
at
org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8369)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.readTableOrView(Parser.java:8358)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.readTablePrimary(Parser.java:1863)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.readTableReference(Parser.java:2334)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.parseSelectFromPart(Parser.java:2772)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.parseSelect(Parser.java:2878)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.parseQueryPrimary(Parser.java:2762)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.parseQueryTerm(Parser.java:2633)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.parseQueryExpressionBody(Parser.java:2612)
~[h2-2.1.214.jar:2.1.214]
at
org.h2.command.Parser.parseQueryExpressionBodyAndEndOfQuery(Parser.java:2605)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.parseQueryExpression(Parser.java:2598)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.parseQuery(Parser.java:2567)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.parsePrepared(Parser.java:724)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.parse(Parser.java:689)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.parse(Parser.java:661)
~[h2-2.1.214.jar:2.1.214]
at org.h2.command.Parser.prepareCommand(Parser.java:569)
~[h2-2.1.214.jar:2.1.214]
at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
~[h2-2.1.214.jar:2.1.214]
at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
~[h2-2.1.214.jar:2.1.214]
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
~[h2-2.1.214.jar:2.1.214]
at
org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92)
~[h2-2.1.214.jar:2.1.214]
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288)
~[h2-2.1.214.jar:2.1.214]
at
com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:362)
~[druid-1.2.16.jar:na]
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86)
~[mybatis-3.5.3.jar:3.5.3]
at
org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
~[mybatis-3.5.3.jar:3.5.3]
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
~[mybatis-3.5.3.jar:3.5.3]
at
com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:92)
~[mybatis-plus-core-3.3.1.jar:3.3.1]
at
com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:66)
~[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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_291]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_291]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_291]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_291]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
~[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.$Proxy71.selectOrder(Unknown Source) ~[na:na]
at
com.leslie.shardingjdbcdemo.controller.config.TestController.justOrderList(TestController.java:40)
~[classes/:na]
at
com.leslie.shardingjdbcdemo.controller.config.TestController$$FastClassBySpringCGLIB$$936ffb21.invoke(<generated>)
~[classes/:na]
at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
~[spring-core-5.3.23.jar:5.3.23]
at
org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
~[spring-aop-5.3.23.jar:5.3.23]
at
org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
~[spring-aop-5.3.23.jar:5.3.23]
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704)
~[spring-aop-5.3.23.jar:5.3.23]
at
com.leslie.shardingjdbcdemo.controller.config.TestController$$EnhancerBySpringCGLIB$$456b5f1c.justOrderList(<generated>)
~[classes/:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_291]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_291]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_291]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_291]
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
~[spring-web-5.3.23.jar:5.3.23]
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
~[spring-web-5.3.23.jar:5.3.23]
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
~[spring-webmvc-5.3.23.jar:5.3.23]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
~[spring-webmvc-5.3.23.jar:5.3.23]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
~[spring-webmvc-5.3.23.jar:5.3.23]
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
~[spring-webmvc-5.3.23.jar:5.3.23]
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071)
~[spring-webmvc-5.3.23.jar:5.3.23]
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)
~[spring-webmvc-5.3.23.jar:5.3.23]
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
~[spring-webmvc-5.3.23.jar:5.3.23]
at
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
~[spring-webmvc-5.3.23.jar:5.3.23]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:670)
~[tomcat-embed-core-9.0.68.jar:4.0.FR]
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
~[spring-webmvc-5.3.23.jar:5.3.23]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
~[tomcat-embed-core-9.0.68.jar:4.0.FR]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
~[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
~[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
~[tomcat-embed-websocket-9.0.68.jar:9.0.68]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
~[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
~[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
~[spring-web-5.3.23.jar:5.3.23]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
~[spring-web-5.3.23.jar:5.3.23]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
~[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
~[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
~[spring-web-5.3.23.jar:5.3.23]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
~[spring-web-5.3.23.jar:5.3.23]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
~[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
~[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
~[spring-web-5.3.23.jar:5.3.23]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
~[spring-web-5.3.23.jar:5.3.23]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
~[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
~[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
~[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
[tomcat-embed-core-9.0.68.jar:9.0.68]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_291]
--
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]
