search

apache / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
19.87k stars 6.73k forks source link

Is anything wrong with my confgiguration?Please help me! #25954

Closed wgijja closed 1 year ago

wgijja commented 1 year ago

env:

shardingsphere-jdcb version:5.2.0 、srpingboot、mysql、druid

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 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.(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() ~[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() ~[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]

RaigorJiang commented 1 year ago

@wgijja Please change mySharding to sharding, it is a key word.

rules:
      mySharding:
wgijja commented 1 year ago

@RaigorJiang Hello,I have already changed mySharding to sharding ,but it can't start with a new problem, can you help me ?

spring:
  sharding-sphere:
    mode:
      type: Standalone
      repository:
        type: JDBC
    # 指定 YAML 配置文件
    dataSources:
      ds_3312:
        dataSourceClassName: com.zaxxer.hikari.HikariDataSource
        driverClassName: com.mysql.cj.jdbc.Driver
        jdbcUrl: jdbc:mysql://192.168.188.128:3312/db_order
        username: root
        password: 123456

    rules:
      sharding:
        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

print

D:\WorkSoftwareInstall\JDK8\bin\java.exe -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:4345,suspend=y,server=n -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -javaagent:C:\Users\范剑虹\AppData\Local\JetBrains\IntelliJIdea2022.2\captureAgent\debugger-agent.jar=file:/C:/Users/%E8%8C%83%E5%89%91%E8%99%B9/AppData/Local/Temp/capture.props -Dfile.encoding=UTF-8 -classpath "D:\WorkSoftwareInstall\JDK8\jre\lib\charsets.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\deploy.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\ext\access-bridge-64.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\ext\cldrdata.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\ext\dnsns.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\ext\jaccess.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\ext\jfxrt.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\ext\localedata.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\ext\nashorn.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\ext\sunec.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\ext\sunjce_provider.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\ext\sunmscapi.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\ext\sunpkcs11.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\ext\zipfs.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\javaws.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\jce.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\jfr.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\jfxswt.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\jsse.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\management-agent.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\plugin.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\resources.jar;D:\WorkSoftwareInstall\JDK8\jre\lib\rt.jar;D:\LocalRepositoryOther\sharding-jdbc-demo\target\classes;D:\WorkSoftwareInstall\repository\org\springframework\boot\spring-boot-starter-web\2.7.5\spring-boot-starter-web-2.7.5.jar;D:\WorkSoftwareInstall\repository\org\springframework\boot\spring-boot-starter\2.7.5\spring-boot-starter-2.7.5.jar;D:\WorkSoftwareInstall\repository\org\springframework\boot\spring-boot\2.7.5\spring-boot-2.7.5.jar;D:\WorkSoftwareInstall\repository\org\springframework\boot\spring-boot-starter-logging\2.7.5\spring-boot-starter-logging-2.7.5.jar;D:\WorkSoftwareInstall\repository\ch\qos\logback\logback-classic\1.2.11\logback-classic-1.2.11.jar;D:\WorkSoftwareInstall\repository\ch\qos\logback\logback-core\1.2.11\logback-core-1.2.11.jar;D:\WorkSoftwareInstall\repository\org\apache\logging\log4j\log4j-to-slf4j\2.17.2\log4j-to-slf4j-2.17.2.jar;D:\WorkSoftwareInstall\repository\org\apache\logging\log4j\log4j-api\2.17.2\log4j-api-2.17.2.jar;D:\WorkSoftwareInstall\repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;D:\WorkSoftwareInstall\repository\org\yaml\snakeyaml\1.30\snakeyaml-1.30.jar;D:\WorkSoftwareInstall\repository\org\springframework\boot\spring-boot-starter-json\2.7.5\spring-boot-starter-json-2.7.5.jar;D:\WorkSoftwareInstall\repository\com\fasterxml\jackson\core\jackson-databind\2.13.4.2\jackson-databind-2.13.4.2.jar;D:\WorkSoftwareInstall\repository\com\fasterxml\jackson\core\jackson-annotations\2.13.4\jackson-annotations-2.13.4.jar;D:\WorkSoftwareInstall\repository\com\fasterxml\jackson\core\jackson-core\2.13.4\jackson-core-2.13.4.jar;D:\WorkSoftwareInstall\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.13.4\jackson-datatype-jdk8-2.13.4.jar;D:\WorkSoftwareInstall\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.13.4\jackson-datatype-jsr310-2.13.4.jar;D:\WorkSoftwareInstall\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.13.4\jackson-module-parameter-names-2.13.4.jar;D:\WorkSoftwareInstall\repository\org\springframework\boot\spring-boot-starter-tomcat\2.7.5\spring-boot-starter-tomcat-2.7.5.jar;D:\WorkSoftwareInstall\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.68\tomcat-embed-core-9.0.68.jar;D:\WorkSoftwareInstall\repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.68\tomcat-embed-el-9.0.68.jar;D:\WorkSoftwareInstall\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.68\tomcat-embed-websocket-9.0.68.jar;D:\WorkSoftwareInstall\repository\org\springframework\spring-web\5.3.23\spring-web-5.3.23.jar;D:\WorkSoftwareInstall\repository\org\springframework\spring-beans\5.3.23\spring-beans-5.3.23.jar;D:\WorkSoftwareInstall\repository\org\springframework\spring-webmvc\5.3.23\spring-webmvc-5.3.23.jar;D:\WorkSoftwareInstall\repository\org\springframework\spring-aop\5.3.23\spring-aop-5.3.23.jar;D:\WorkSoftwareInstall\repository\org\springframework\spring-context\5.3.23\spring-context-5.3.23.jar;D:\WorkSoftwareInstall\repository\org\springframework\spring-expression\5.3.23\spring-expression-5.3.23.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-jdbc-core-spring-boot-starter\5.2.0\shardingsphere-jdbc-core-spring-boot-starter-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sharding-spring-boot-starter\5.2.0\shardingsphere-sharding-spring-boot-starter-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sharding-core\5.2.0\shardingsphere-sharding-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sharding-api\5.2.0\shardingsphere-sharding-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-data-pipeline-core\5.2.0\shardingsphere-data-pipeline-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-data-pipeline-api\5.2.0\shardingsphere-data-pipeline-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\commons\commons-lang3\3.12.0\commons-lang3-3.12.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-schedule-core\5.2.0\shardingsphere-schedule-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-lite-core\3.0.1\elasticjob-lite-core-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-api\3.0.1\elasticjob-api-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-infra-common\3.0.1\elasticjob-infra-common-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-registry-center\3.0.1\elasticjob-registry-center-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-simple-executor\3.0.1\elasticjob-simple-executor-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-executor-kernel\3.0.1\elasticjob-executor-kernel-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-error-handler-general\3.0.1\elasticjob-error-handler-general-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-error-handler-spi\3.0.1\elasticjob-error-handler-spi-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-dataflow-executor\3.0.1\elasticjob-dataflow-executor-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-script-executor\3.0.1\elasticjob-script-executor-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\commons\commons-exec\1.3\commons-exec-1.3.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-http-executor\3.0.1\elasticjob-http-executor-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-tracing-rdb\3.0.1\elasticjob-tracing-rdb-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-tracing-api\3.0.1\elasticjob-tracing-api-3.0.1.jar;D:\WorkSoftwareInstall\repository\com\google\code\gson\gson\2.9.1\gson-2.9.1.jar;D:\WorkSoftwareInstall\repository\org\quartz-scheduler\quartz\2.3.2\quartz-2.3.2.jar;D:\WorkSoftwareInstall\repository\com\mchange\mchange-commons-java\0.2.15\mchange-commons-java-0.2.15.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\elasticjob\elasticjob-lite-lifecycle\3.0.1\elasticjob-lite-lifecycle-3.0.1.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-cluster-mode-repository-zookeeper-curator\5.2.0\shardingsphere-cluster-mode-repository-zookeeper-curator-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\curator\curator-framework\5.1.0\curator-framework-5.1.0.jar;D:\WorkSoftwareInstall\repository\org\apache\curator\curator-client\5.1.0\curator-client-5.1.0.jar;D:\WorkSoftwareInstall\repository\org\apache\zookeeper\zookeeper\3.6.0\zookeeper-3.6.0.jar;D:\WorkSoftwareInstall\repository\org\apache\zookeeper\zookeeper-jute\3.6.0\zookeeper-jute-3.6.0.jar;D:\WorkSoftwareInstall\repository\org\apache\yetus\audience-annotations\0.5.0\audience-annotations-0.5.0.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-transport-native-epoll\4.1.84.Final\netty-transport-native-epoll-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-transport-classes-epoll\4.1.84.Final\netty-transport-classes-epoll-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;D:\WorkSoftwareInstall\repository\org\apache\curator\curator-recipes\5.1.0\curator-recipes-5.1.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-infra-binder\5.2.0\shardingsphere-infra-binder-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-dialect-exception-core\5.2.0\shardingsphere-dialect-exception-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-infra-route\5.2.0\shardingsphere-infra-route-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-infra-rewrite\5.2.0\shardingsphere-infra-rewrite-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-translator-native-provider\5.2.0\shardingsphere-sql-translator-native-provider-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-infra-merge\5.2.0\shardingsphere-infra-merge-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\calcite\calcite-linq4j\1.31.0\calcite-linq4j-1.31.0.jar;D:\WorkSoftwareInstall\repository\org\apache\calcite\avatica\avatica-core\1.22.0\avatica-core-1.22.0.jar;D:\WorkSoftwareInstall\repository\org\apache\calcite\avatica\avatica-metrics\1.22.0\avatica-metrics-1.22.0.jar;D:\WorkSoftwareInstall\repository\com\google\protobuf\protobuf-java\3.17.1\protobuf-java-3.17.1.jar;D:\WorkSoftwareInstall\repository\org\apache\httpcomponents\client5\httpclient5\5.1.3\httpclient5-5.1.3.jar;D:\WorkSoftwareInstall\repository\org\apache\httpcomponents\core5\httpcore5-h2\5.1.4\httpcore5-h2-5.1.4.jar;D:\WorkSoftwareInstall\repository\org\apache\httpcomponents\core5\httpcore5\5.1.4\httpcore5-5.1.4.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-mode-core\5.2.0\shardingsphere-mode-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-system-datetime\5.2.0\shardingsphere-system-datetime-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-infra-datetime-spi\5.2.0\shardingsphere-infra-datetime-spi-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sharding-cosid\5.2.0\shardingsphere-sharding-cosid-5.2.0.jar;D:\WorkSoftwareInstall\repository\me\ahoo\cosid\cosid-core\1.14.4\cosid-core-1.14.4.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sharding-nanoid\5.2.0\shardingsphere-sharding-nanoid-5.2.0.jar;D:\WorkSoftwareInstall\repository\com\aventrix\jnanoid\jnanoid\2.0.0\jnanoid-2.0.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-shadow-spring-boot-starter\5.2.0\shardingsphere-shadow-spring-boot-starter-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-shadow-core\5.2.0\shardingsphere-shadow-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-shadow-api\5.2.0\shardingsphere-shadow-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-db-discovery-spring-boot-starter\5.2.0\shardingsphere-db-discovery-spring-boot-starter-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-db-discovery-core\5.2.0\shardingsphere-db-discovery-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-db-discovery-api\5.2.0\shardingsphere-db-discovery-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-db-discovery-mysql\5.2.0\shardingsphere-db-discovery-mysql-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-db-discovery-opengauss\5.2.0\shardingsphere-db-discovery-opengauss-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-encrypt-spring-boot-starter\5.2.0\shardingsphere-encrypt-spring-boot-starter-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-encrypt-core\5.2.0\shardingsphere-encrypt-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-encrypt-api\5.2.0\shardingsphere-encrypt-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-encrypt-sm\5.2.0\shardingsphere-encrypt-sm-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\bouncycastle\bcprov-jdk15on\1.70\bcprov-jdk15on-1.70.jar;D:\WorkSoftwareInstall\repository\commons-codec\commons-codec\1.15\commons-codec-1.15.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-spring-boot-starter\5.2.0\shardingsphere-readwrite-splitting-spring-boot-starter-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-core\5.2.0\shardingsphere-readwrite-splitting-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-api\5.2.0\shardingsphere-readwrite-splitting-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-jdbc-spring-boot-starter-infra\5.2.0\shardingsphere-jdbc-spring-boot-starter-infra-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-jdbc-transaction-spring\5.2.0\shardingsphere-jdbc-transaction-spring-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-transaction-core\5.2.0\shardingsphere-transaction-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-transaction-api\5.2.0\shardingsphere-transaction-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-infra-executor\5.2.0\shardingsphere-infra-executor-5.2.0.jar;D:\WorkSoftwareInstall\repository\io\vertx\vertx-mysql-client\4.2.3\vertx-mysql-client-4.2.3.jar;D:\WorkSoftwareInstall\repository\io\vertx\vertx-core\4.2.3\vertx-core-4.2.3.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-common\4.1.84.Final\netty-common-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-buffer\4.1.84.Final\netty-buffer-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-transport\4.1.84.Final\netty-transport-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-handler\4.1.84.Final\netty-handler-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-transport-native-unix-common\4.1.84.Final\netty-transport-native-unix-common-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-codec\4.1.84.Final\netty-codec-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-handler-proxy\4.1.84.Final\netty-handler-proxy-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-codec-socks\4.1.84.Final\netty-codec-socks-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-codec-http\4.1.84.Final\netty-codec-http-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-codec-http2\4.1.84.Final\netty-codec-http2-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-resolver\4.1.84.Final\netty-resolver-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-resolver-dns\4.1.84.Final\netty-resolver-dns-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\netty\netty-codec-dns\4.1.84.Final\netty-codec-dns-4.1.84.Final.jar;D:\WorkSoftwareInstall\repository\io\vertx\vertx-sql-client\4.2.3\vertx-sql-client-4.2.3.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-parser-spring-boot-starter\5.2.0\shardingsphere-parser-spring-boot-starter-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-parser-core\5.2.0\shardingsphere-parser-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-parser-api\5.2.0\shardingsphere-parser-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-infra-parser\5.2.0\shardingsphere-infra-parser-5.2.0.jar;D:\WorkSoftwareInstall\repository\com\github\ben-manes\caffeine\caffeine\2.9.3\caffeine-2.9.3.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-translator-spring-boot-starter\5.2.0\shardingsphere-sql-translator-spring-boot-starter-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-translator-core\5.2.0\shardingsphere-sql-translator-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-translator-api\5.2.0\shardingsphere-sql-translator-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-jdbc-core\5.2.0\shardingsphere-jdbc-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-parser-sql92\5.2.0\shardingsphere-sql-parser-sql92-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-parser-engine\5.2.0\shardingsphere-sql-parser-engine-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-parser-spi\5.2.0\shardingsphere-sql-parser-spi-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-parser-statement\5.2.0\shardingsphere-sql-parser-statement-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\antlr\antlr4-runtime\4.9.2\antlr4-runtime-4.9.2.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-parser-mysql\5.2.0\shardingsphere-sql-parser-mysql-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-parser-postgresql\5.2.0\shardingsphere-sql-parser-postgresql-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-parser-oracle\5.2.0\shardingsphere-sql-parser-oracle-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-parser-sqlserver\5.2.0\shardingsphere-sql-parser-sqlserver-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-sql-parser-opengauss\5.2.0\shardingsphere-sql-parser-opengauss-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-authority-core\5.2.0\shardingsphere-authority-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-authority-api\5.2.0\shardingsphere-authority-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-single-table-core\5.2.0\shardingsphere-single-table-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-single-table-api\5.2.0\shardingsphere-single-table-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-traffic-core\5.2.0\shardingsphere-traffic-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-infra-common\5.2.0\shardingsphere-infra-common-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-infra-util\5.2.0\shardingsphere-infra-util-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\groovy\groovy\4.0.3\groovy-4.0.3.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-traffic-api\5.2.0\shardingsphere-traffic-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-infra-context\5.2.0\shardingsphere-infra-context-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-distsql-parser\5.2.0\shardingsphere-distsql-parser-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-distsql-statement\5.2.0\shardingsphere-distsql-statement-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-standalone-mode-core\5.2.0\shardingsphere-standalone-mode-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-standalone-mode-repository-api\5.2.0\shardingsphere-standalone-mode-repository-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-standalone-mode-repository-jdbc-h2\5.2.0\shardingsphere-standalone-mode-repository-jdbc-h2-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-standalone-mode-repository-jdbc-core\5.2.0\shardingsphere-standalone-mode-repository-jdbc-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-cluster-mode-core\5.2.0\shardingsphere-cluster-mode-core-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-cluster-mode-repository-api\5.2.0\shardingsphere-cluster-mode-repository-api-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-infra-federation-executor\5.2.0\shardingsphere-infra-federation-executor-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\shardingsphere\shardingsphere-infra-federation-optimizer\5.2.0\shardingsphere-infra-federation-optimizer-5.2.0.jar;D:\WorkSoftwareInstall\repository\org\apache\calcite\calcite-core\1.31.0\calcite-core-1.31.0.jar;D:\WorkSoftwareInstall\repository\com\esri\geometry\esri-geometry-api\2.2.0\esri-geometry-api-2.2.0.jar;D:\WorkSoftwareInstall\repository\com\fasterxml\jackson\dataformat\jackson-dataformat-yaml\2.13.4\jackson-dataformat-yaml-2.13.4.jar;D:\WorkSoftwareInstall\repository\com\google\uzaygezen\uzaygezen-core\0.2\uzaygezen-core-0.2.jar;D:\WorkSoftwareInstall\repository\com\yahoo\datasketches\sketches-core\0.9.0\sketches-core-0.9.0.jar;D:\WorkSoftwareInstall\repository\com\yahoo\datasketches\memory\0.9.0\memory-0.9.0.jar;D:\WorkSoftwareInstall\repository\net\hydromatic\aggdesigner-algorithm\6.0\aggdesigner-algorithm-6.0.jar;D:\WorkSoftwareInstall\repository\commons-lang\commons-lang\2.4\commons-lang-2.4.jar;D:\WorkSoftwareInstall\repository\commons-logging\commons-logging\1.1.3\commons-logging-1.1.3.jar;D:\WorkSoftwareInstall\repository\org\apache\commons\commons-dbcp2\2.9.0\commons-dbcp2-2.9.0.jar;D:\WorkSoftwareInstall\repository\org\apache\commons\commons-pool2\2.11.1\commons-pool2-2.11.1.jar;D:\WorkSoftwareInstall\repository\commons-io\commons-io\2.11.0\commons-io-2.11.0.jar;D:\WorkSoftwareInstall\repository\org\codehaus\janino\commons-compiler\3.1.8\commons-compiler-3.1.8.jar;D:\WorkSoftwareInstall\repository\org\codehaus\janino\janino\3.1.8\janino-3.1.8.jar;D:\WorkSoftwareInstall\repository\org\apache\commons\commons-collections4\4.4\commons-collections4-4.4.jar;D:\WorkSoftwareInstall\repository\com\h2database\h2\2.1.214\h2-2.1.214.jar;D:\WorkSoftwareInstall\repository\com\google\guava\guava\30.0-jre\guava-30.0-jre.jar;D:\WorkSoftwareInstall\repository\com\google\guava\failureaccess\1.0.1\failureaccess-1.0.1.jar;D:\WorkSoftwareInstall\repository\com\google\code\findbugs\jsr305\3.0.2\jsr305-3.0.2.jar;D:\WorkSoftwareInstall\repository\org\checkerframework\checker-qual\3.5.0\checker-qual-3.5.0.jar;D:\WorkSoftwareInstall\repository\com\google\errorprone\error_prone_annotations\2.3.4\error_prone_annotations-2.3.4.jar;D:\WorkSoftwareInstall\repository\org\slf4j\slf4j-api\1.7.36\slf4j-api-1.7.36.jar;D:\WorkSoftwareInstall\repository\org\slf4j\jcl-over-slf4j\1.7.36\jcl-over-slf4j-1.7.36.jar;D:\WorkSoftwareInstall\repository\org\slf4j\jul-to-slf4j\1.7.36\jul-to-slf4j-1.7.36.jar;D:\WorkSoftwareInstall\repository\com\mysql\mysql-connector-j\8.0.31\mysql-connector-j-8.0.31.jar;D:\WorkSoftwareInstall\repository\com\baomidou\mybatis-plus-boot-starter\3.3.1\mybatis-plus-boot-starter-3.3.1.jar;D:\WorkSoftwareInstall\repository\com\baomidou\mybatis-plus\3.3.1\mybatis-plus-3.3.1.jar;D:\WorkSoftwareInstall\repository\com\baomidou\mybatis-plus-extension\3.3.1\mybatis-plus-extension-3.3.1.jar;D:\WorkSoftwareInstall\repository\com\baomidou\mybatis-plus-core\3.3.1\mybatis-plus-core-3.3.1.jar;D:\WorkSoftwareInstall\repository\com\baomidou\mybatis-plus-annotation\3.3.1\mybatis-plus-annotation-3.3.1.jar;D:\WorkSoftwareInstall\repository\com\github\jsqlparser\jsqlparser\3.1\jsqlparser-3.1.jar;D:\WorkSoftwareInstall\repository\org\springframework\boot\spring-boot-autoconfigure\2.7.5\spring-boot-autoconfigure-2.7.5.jar;D:\WorkSoftwareInstall\repository\org\springframework\boot\spring-boot-starter-jdbc\2.7.5\spring-boot-starter-jdbc-2.7.5.jar;D:\WorkSoftwareInstall\repository\com\zaxxer\HikariCP\4.0.3\HikariCP-4.0.3.jar;D:\WorkSoftwareInstall\repository\org\springframework\spring-jdbc\5.3.23\spring-jdbc-5.3.23.jar;D:\WorkSoftwareInstall\repository\org\springframework\spring-tx\5.3.23\spring-tx-5.3.23.jar;D:\WorkSoftwareInstall\repository\org\projectlombok\lombok\1.18.24\lombok-1.18.24.jar;D:\WorkSoftwareInstall\repository\com\jayway\jsonpath\json-path\2.7.0\json-path-2.7.0.jar;D:\WorkSoftwareInstall\repository\net\minidev\json-smart\2.4.8\json-smart-2.4.8.jar;D:\WorkSoftwareInstall\repository\net\minidev\accessors-smart\2.4.8\accessors-smart-2.4.8.jar;D:\WorkSoftwareInstall\repository\org\ow2\asm\asm\9.1\asm-9.1.jar;D:\WorkSoftwareInstall\repository\org\apiguardian\apiguardian-api\1.1.2\apiguardian-api-1.1.2.jar;D:\WorkSoftwareInstall\repository\org\springframework\spring-core\5.3.23\spring-core-5.3.23.jar;D:\WorkSoftwareInstall\repository\org\springframework\spring-jcl\5.3.23\spring-jcl-5.3.23.jar;D:\WorkSoftwareInstall\repository\com\alibaba\druid-spring-boot-starter\1.2.16\druid-spring-boot-starter-1.2.16.jar;D:\WorkSoftwareInstall\repository\com\alibaba\druid\1.2.16\druid-1.2.16.jar;D:\WorkSoftwareInstall\repository\org\mybatis\spring\boot\mybatis-spring-boot-starter\2.2.1\mybatis-spring-boot-starter-2.2.1.jar;D:\WorkSoftwareInstall\repository\org\mybatis\spring\boot\mybatis-spring-boot-autoconfigure\2.2.1\mybatis-spring-boot-autoconfigure-2.2.1.jar;D:\WorkSoftwareInstall\repository\org\mybatis\mybatis\3.5.9\mybatis-3.5.9.jar;D:\WorkSoftwareInstall\repository\org\mybatis\mybatis-spring\2.0.6\mybatis-spring-2.0.6.jar;D:\WorkSoftwareInstall\IntelliJ IDEA 2022.2.3\lib\idea_rt.jar" com.leslie.shardingjdbcdemo.ShardingJdbcDemoApplication
Connected to the target VM, address: '127.0.0.1:4345', transport: 'socket'

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::                (v2.7.5)

2023-06-02 18:37:31.744  INFO 10768 --- [           main] c.l.s.ShardingJdbcDemoApplication        : Starting ShardingJdbcDemoApplication using Java 1.8.0_291 on DESKTOP-VTOLQIC with PID 10768 (D:\LocalRepositoryOther\sharding-jdbc-demo\target\classes started by 范剑虹 in D:\LocalRepositoryOther\sharding-jdbc-demo)
2023-06-02 18:37:31.746  INFO 10768 --- [           main] c.l.s.ShardingJdbcDemoApplication        : The following 1 profile is active: "myyml"
2023-06-02 18:37:32.597 ERROR 10768 --- [           main] o.s.boot.SpringApplication               : Application run failed

java.lang.IllegalArgumentException: Type is required.
    at com.google.common.base.Preconditions.checkArgument(Preconditions.java:142) ~[guava-30.0-jre.jar:na]
    at org.apache.shardingsphere.infra.config.algorithm.AlgorithmConfiguration.<init>(AlgorithmConfiguration.java:37) ~[shardingsphere-infra-common-5.2.0.jar:5.2.0]
    at org.apache.shardingsphere.spring.boot.registry.AbstractAlgorithmProvidedBeanRegistry.createAlgorithmConfiguration(AbstractAlgorithmProvidedBeanRegistry.java:88) ~[shardingsphere-jdbc-spring-boot-starter-infra-5.2.0.jar:5.2.0]
    at org.apache.shardingsphere.spring.boot.registry.AbstractAlgorithmProvidedBeanRegistry.createAlgorithmConfigurations(AbstractAlgorithmProvidedBeanRegistry.java:80) ~[shardingsphere-jdbc-spring-boot-starter-infra-5.2.0.jar:5.2.0]
    at org.apache.shardingsphere.spring.boot.registry.AbstractAlgorithmProvidedBeanRegistry.registerBean(AbstractAlgorithmProvidedBeanRegistry.java:67) ~[shardingsphere-jdbc-spring-boot-starter-infra-5.2.0.jar:5.2.0]
    at org.apache.shardingsphere.sharding.spring.boot.algorithm.ShardingAlgorithmProvidedBeanRegistry.postProcessBeanDefinitionRegistry(ShardingAlgorithmProvidedBeanRegistry.java:38) ~[shardingsphere-sharding-spring-boot-starter-5.2.0.jar:5.2.0]
    at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanDefinitionRegistryPostProcessors(PostProcessorRegistrationDelegate.java:311) ~[spring-context-5.3.23.jar:5.3.23]
    at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:142) ~[spring-context-5.3.23.jar:5.3.23]
    at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:746) ~[spring-context-5.3.23.jar:5.3.23]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:564) ~[spring-context-5.3.23.jar:5.3.23]
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:147) ~[spring-boot-2.7.5.jar:2.7.5]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:734) [spring-boot-2.7.5.jar:2.7.5]
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:408) [spring-boot-2.7.5.jar:2.7.5]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:308) [spring-boot-2.7.5.jar:2.7.5]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) [spring-boot-2.7.5.jar:2.7.5]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295) [spring-boot-2.7.5.jar:2.7.5]
    at com.leslie.shardingjdbcdemo.ShardingJdbcDemoApplication.main(ShardingJdbcDemoApplication.java:12) [classes/:na]

Disconnected from the target VM, address: '127.0.0.1:4345', transport: 'socket'

Process finished with exit code 1
RaigorJiang commented 1 year ago

Hi @wgijja I usually use ShardingSphere-Proxy, and there is no JDBC demo of 5.2.0, can you provide a reproducible project?

wgijja commented 1 year ago

Hi @RaigorJiang Of course, i tried to find why this problem happened, but i didn't find anything expect a long time ago issue with #2397,maybe you have more idea with it. I'm watting for u,thanks.

And this is my demo project:

sharding-jdbc-demo.zip

RaigorJiang commented 1 year ago

@wgijja I tried to modify your yml configuration, and now it can be started successfully.

spring:
  shardingsphere:
#    mode:
#      type: Standalone
#      repository:
#        type: JDBC
    # 指定 YAML 配置文件
    dataSource:
      names: ds_3312
      ds_3312:
        type: com.zaxxer.hikari.HikariDataSource
        driverClassName: com.mysql.cj.jdbc.Driver
        jdbcUrl: jdbc:mysql://host:port/db_order
        username: root
        password: xxx

    rules:
      sharding:
        tables: # 数据分片规则配置
          t_order: # 逻辑表名称
            actualDataNodes: ds_3312.t_order$->{0..11}
            tableStrategy: # 分表策略，同分库策略
              standard: # 用于单分片键的标准分片场景
                shardingColumn: order_no # 分片列名称
                shardingAlgorithmName: t_order_inline # 分片算法名称

            keyGenerateStrategy: # 分布式序列策略
              column: id
              keyGeneratorName: snowflake

        # 分片算法配置
        sharding-algorithms:
          t_order_inline: # 分片算法名称
            type: INLINE # 分片算法类型
            props: # 分片算法属性配置
              algorithm-expression: t_order$->{order_no % 12} # ...
        # 分布式序列算法配置
        keyGenerators:
          snowflake: # 分布式序列算法名称
            type: SNOWFLAKE # 分布式序列算法类型
            # ...

    props:
      sql-show: true

The previous problems were mainly about keyword shardingsphere and datasource, refer to quick-start.

wgijja commented 1 year ago

Hi, @RaigorJiang. I'm sorry for missing our scheduled time.

I tried running the YML configuration you changed. Yes, it can be started, but when I sent a request with a simple select statement, the problem I mentioned earlier appeared again. It was something like 'Cause: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "T_ORDER" not found (this database is empty);'

I feel like I'm back to square one... Can you please try running it with a successful request?

Thank you!

wgijja commented 1 year ago

Hi, @RaigorJiang Can you see what i describeed in last comment?Thans.😁

RaigorJiang commented 1 year ago

@wgijja Ok, so little free time these days, I'll try.

wgijja commented 1 year ago

Hi,@RaigorJiang. It's alright,, take your time. Thank you.☕☕☕

wgijja commented 1 year ago

@RaigorJiang Hi,Are you still busy?🫥

wgijja commented 1 year ago

@RaigorJiang May i have your attention.plz

RaigorJiang commented 1 year ago

Hi @wgijja Ok, your problem is not solved yet? I will give you feedback after I try it today

RaigorJiang commented 1 year ago

@wgijja After I started the demo you provided, I sent some requests to the controller and found some problems:

  1. The mapper.xml does not match the entity, such as OrderMapper.xml (you need to check your project carefully)
  2. When using shardingsphere-jdbc-core-spring-boot-starter, we cannot rely on druid-spring-boot-starter. If you need druid, please non-starter dependencies.

Finally, I made some changes so that some SQL of Order can be executed in sharding. You can download the demo and access the following interfaces, and observe the SQL routing information from the log.

image

sharding-jdbc-demo-0813.zip

wgijja commented 1 year ago

@RaigorJiang Oh, I apologize for my mistake. Thank you very much for your assistance! 😁 I will definitely give your suggestions a try. Once again, thank you!