shardingsphere的坑。。。

最新推荐文章于 2025-06-30 18:24:10 发布
最新推荐文章于 2025-06-30 18:24:10 发布
阅读量2.5w 收藏 5
点赞数 2
CC 4.0 BY-SA版权
文章标签： shardingsphere
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/yao012/article/details/89098778
本文记录了一次使用ShardingSphere过程中遇到的空指针异常问题，详细介绍了异常的具体表现及排查过程，并最终定位为缺少antlr4-runtime-4.7.1.jar依赖导致。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

前面有说到defaultDataSource设置不生效,手动修改后,此项还勉强能用,如今又遇到一个奇葩的问题,本地调试时一切正常,丢到服务器后就一直报错,重点是:只是说空指针,就是不说具体哪里有毛病…,报错信息如下:

Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@53c0ed78] was not registered for synchronization because synchronization is not active
JDBC Connection [io.shardingsphere.shardingjdbc.jdbc.core.connection.ShardingConnection@ab67e80] will not be managed by Spring
==>  Preparing: select * from micro_user_qc where openid = ? and qcCode = ?
==> Parameters: ouxU447wKbhvEAWxH8_ors2V6dHk1(String), testqc(String)
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@53c0ed78]
E 14:09:40.805 [support.ErrorPageFilter] Forwarding to error page from request [/micro_box/check_bind] due to exception [nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: java.lang.NullPointerException
### The error may exist in com/eques/eqhome/db/mapper/MicroUserQcMapper.java (best guess)
### The error may involve com.eques.eqhome.db.mapper.MicroUserQcMapper.findMicroUserQc-Inline
### The error occurred while setting parameters
### SQL: select * from micro_user_qc where openid = ? and qcCode = ?
### Cause: java.lang.NullPointerException]
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: java.lang.NullPointerException
### The error may exist in com/eques/eqhome/db/mapper/MicroUserQcMapper.java (best guess)
### The error may involve com.eques.eqhome.db.mapper.MicroUserQcMapper.findMicroUserQc-Inline
### The error occurred while setting parameters
### SQL: select * from micro_user_qc where openid = ? and qcCode = ?
### Cause: java.lang.NullPointerException
        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77) ~[mybatis-spring-2.0.0.jar:2.0.0]
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) ~[mybatis-spring-2.0.0.jar:2.0.0]
        at com.sun.proxy.$Proxy82.selectOne(Unknown Source) ~[?:?]
        at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166) ~[mybatis-spring-2.0.0.jar:2.0.0]
        at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:99) ~[mybatis-plus-core-3.1.0.jar:3.1.0]
        at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:61) ~[mybatis-plus-core-3.1.0.jar:3.1.0]
        at com.sun.proxy.$Proxy89.findMicroUserQc(Unknown Source) ~[?:?]
        at com.eques.eqhome.db.services.MicroUserQcService.findMicroUserQc(MicroUserQcService.java:37) ~[eqhome-db-api-1.1.0-SNAPSHOT.jar:?]
        at com.eques.eqhome.db.services.MicroUserQcService$$FastClassBySpringCGLIB$$d715773.invoke(<generated>) ~[eqhome-db-api-1.1.0-SNAPSHOT.jar:?]
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at com.eques.eqhome.db.services.MicroUserQcService$$EnhancerBySpringCGLIB$$1231cba2.findMicroUserQc(<generated>) ~[eqhome-db-api-1.1.0-SNAPSHOT.jar:?]
        at com.eques.eqhome.controller.MicroBoxController.checkBind(MicroBoxController.java:154) ~[classes/:?]
        at com.eques.eqhome.controller.MicroBoxController$$FastClassBySpringCGLIB$$12d6e256.invoke(<generated>) ~[classes/:?]
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at com.eques.eqhome.controller.MicroBoxController$$EnhancerBySpringCGLIB$$6412d22b.checkBind(<generated>) ~[classes/:?]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_171]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_171]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_171]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_171]
        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) ~[servlet-api.jar:?]
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[servlet-api.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[catalina.jar:9.0.16]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.16]
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-websocket.jar:9.0.16]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.16]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.16]
        at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) ~[log4j-web-2.10.0.jar:2.10.0]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.16]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.16]
        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.16]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.16]
        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.16]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.16]
        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.16]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.16]
        at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:130) [spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
        at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66) [spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
        at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:105) [spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:123) [spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.16]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.16]
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.16]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.16]
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) [catalina.jar:9.0.16]
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:9.0.16]
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [catalina.jar:9.0.16]
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:9.0.16]
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.16]
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.16]
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.16]
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-coyote.jar:9.0.16]
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:9.0.16]
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) [tomcat-coyote.jar:9.0.16]
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) [tomcat-coyote.jar:9.0.16]
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.16]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_171]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_171]
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.16]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_171]
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: java.lang.NullPointerException
### The error may exist in com/eques/eqhome/db/mapper/MicroUserQcMapper.java (best guess)
### The error may involve com.eques.eqhome.db.mapper.MicroUserQcMapper.findMicroUserQc-Inline
### The error occurred while setting parameters
### SQL: select * from micro_user_qc where openid = ? and qcCode = ?
### Cause: java.lang.NullPointerException
        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.0.jar:3.5.0]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150) ~[mybatis-3.5.0.jar:3.5.0]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) ~[mybatis-3.5.0.jar:3.5.0]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77) ~[mybatis-3.5.0.jar:3.5.0]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_171]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_171]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_171]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_171]
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-2.0.0.jar:2.0.0]
        ... 79 more
Caused by: java.lang.NullPointerException
        at io.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:139) ~[sharding-jdbc-core-3.1.0.jar:?]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_171]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_171]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_171]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_171]
        at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) ~[mybatis-3.5.0.jar:3.5.0]
        at com.sun.proxy.$Proxy120.execute(Unknown Source) ~[?:?]
        at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) ~[mybatis-3.5.0.jar:3.5.0]
        at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.5.0.jar:3.5.0]
        at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.5.0.jar:3.5.0]
        at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) ~[mybatis-3.5.0.jar:3.5.0]
        at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.0.jar:3.5.0]
        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.5.0.jar:3.5.0]
        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) ~[mybatis-3.5.0.jar:3.5.0]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) ~[mybatis-3.5.0.jar:3.5.0]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) ~[mybatis-3.5.0.jar:3.5.0]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77) ~[mybatis-3.5.0.jar:3.5.0]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_171]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_171]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_171]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_171]
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-2.0.0.jar:2.0.0]
        ... 79 more

看的出来哪里有毛病?我是没看出来,debug，发现

    @Override
    public boolean execute() throws SQLException {
        try {
            clearPrevious();
            sqlRoute();
            initPreparedStatementExecutor();
            return preparedStatementExecutor.execute();
        } finally {
        	// 报错语句,
            refreshTableMetaData(connection.getShardingContext(), routeResult.getSqlStatement());
            clearBatch();
        }
    }

走到

refreshTableMetaData(connection.getShardingContext(), routeResult.getSqlStatement());

就会报错,直接 NullPointerException ,查看源码后发现shardingsphere源码中日志少的可怜,异常也被直接抛弃掉了(不知道作者怎么想的)；
比如:

/*
 * Copyright 2016-2018 shardingsphere.io.
 * <p>
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 * </p>
 */

package io.shardingsphere.core.parsing.antlr.parser;

import com.google.common.base.Optional;
import io.shardingsphere.core.constant.DatabaseType;
import io.shardingsphere.core.parsing.antlr.parser.impl.SQLParserFactory;
import io.shardingsphere.core.parsing.antlr.rule.registry.ParsingRuleRegistry;
import io.shardingsphere.core.parsing.antlr.rule.registry.statement.SQLStatementRule;
import io.shardingsphere.core.parsing.parser.exception.SQLParsingUnsupportedException;
import lombok.RequiredArgsConstructor;
import org.antlr.v4.runtime.ParserRuleContext;
import org.antlr.v4.runtime.tree.ErrorNode;
import org.antlr.v4.runtime.tree.ParseTree;

/**
 * SQL parser engine.
 * 
 * @author zhangliang
 */
@RequiredArgsConstructor
public final class SQLParserEngine {
    
    private final ParsingRuleRegistry parsingRuleRegistry = ParsingRuleRegistry.getInstance();
    
    private final DatabaseType databaseType;
    
    private final String sql;
    
    /**
     * Parse SQL to AST.
     * 
     * @return Abstract syntax tree of SQL
     */
    public SQLAST parse() {
        try {
            ParseTree parseTree = SQLParserFactory.newInstance(databaseType, sql).execute().getChild(0);
            if (parseTree instanceof ErrorNode) {
                throw new SQLParsingUnsupportedException(String.format("Unsupported SQL of `%s`", sql));
            }
            Optional<SQLStatementRule> sqlStatementRule = parsingRuleRegistry.findSQLStatementRule(databaseType, parseTree.getClass().getSimpleName());
            if (!sqlStatementRule.isPresent()) {
                throw new SQLParsingUnsupportedException(String.format("Unsupported SQL of `%s`", sql));
            }
            return new SQLAST((ParserRuleContext) parseTree, sqlStatementRule.get());
        }catch(Throwable th){
        	// 这里是自己定义的异常捕获,
            th.printStackTrace();
            throw new RuntimeException(th);
        }
    }
}

请教公司大佬,直接把源码拿过来直接捕获异常发现了如下问题:

Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7476e8d2] was not registered for synchronization because synchronization is not active
JDBC Connection [io.shardingsphere.shardingjdbc.jdbc.core.connection.ShardingConnection@2d1792c4] will not be managed by Spring
==>  Preparing: select * from micro_user_qc where openid = ? and qcCode = ?
==> Parameters: ouxU447wKbhvEAWxH8_ors2V6dHk1(String), testqc(String)
java.lang.NoClassDefFoundError: org/antlr/v4/runtime/CharStream
        at io.shardingsphere.core.parsing.antlr.parser.SQLParserEngine.parse(SQLParserEngine.java:52)
        at io.shardingsphere.core.parsing.antlr.AntlrParsingEngine.parse(AntlrParsingEngine.java:59)
        at io.shardingsphere.core.parsing.SQLParsingEngine.parse(SQLParsingEngine.java:67)
        at io.shardingsphere.core.routing.router.sharding.ParsingSQLRouter.parse(ParsingSQLRouter.java:82)
        at io.shardingsphere.core.routing.PreparedStatementRoutingEngine.route(PreparedStatementRoutingEngine.java:62)
        at io.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.sqlRoute(ShardingPreparedStatement.java:214)
        at io.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:135)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
        at com.sun.proxy.$Proxy116.execute(Unknown Source)
        at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
        at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
        at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
        at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
        at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
        at com.sun.proxy.$Proxy80.selectOne(Unknown Source)
        at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)
        at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:99)
        at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:61)
        at com.sun.proxy.$Proxy87.findMicroUserQc(Unknown Source)
        at com.eques.eqhome.db.services.MicroUserQcService.findMicroUserQc(MicroUserQcService.java:37)
        at com.eques.eqhome.db.services.MicroUserQcService$$FastClassBySpringCGLIB$$d715773.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
        at com.eques.eqhome.db.services.MicroUserQcService$$EnhancerBySpringCGLIB$$561b1f26.findMicroUserQc(<generated>)
        at com.eques.eqhome.controller.MicroBoxController.checkBind(MicroBoxController.java:154)
        at com.eques.eqhome.controller.MicroBoxController$$FastClassBySpringCGLIB$$12d6e256.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
        at com.eques.eqhome.controller.MicroBoxController$$EnhancerBySpringCGLIB$$a7fc25af.checkBind(<generated>)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)
        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:130)
        at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66)
        at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:105)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:123)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassNotFoundException: org.antlr.v4.runtime.CharStream
        at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        ... 107 more

这样就很明显了,少了依赖,antlr4-runtime-4.7.1.jar 把这个jar扔上去就好了,但是问题是,shardingsphere为什么把异常丢弃,玩呢。。。

yao012
关注
工程设计-shardingsphere源码解读(2)
AI
04-04 1976
数据分片设计，原理，工程设计，实现机制
shardingsphere不支持子查询
qq_36189997的博客
06-20 929
java中的list用下面的方法进行对数据进行处理。
我与ShardingSphere的爱恨情仇
m0_60681411的博客
12-11 979
本文通过SpringBoot+ShardingSphere ,实现了Mysql数据库和DM数据库的分表操作。
shardingsphere-proxy成可执行jar包总结
江畔独步寻欢的博客
05-15 769
shardingsphere-proxy模块打可执行jar包
ShardingSphere详解
最新发布
我是Java程序员廖志伟，感谢朋友们的支持！不定期贡献一篇高品质、过万文字、图文并茂且附有视频解说、满载代码示例注释的良心之作，坚决杜绝粗制乱造。
06-30 966
不定期分享高并发、高可用、高性能、微服务、分布式、海量数据、性能调优、云原生、项目管理、产品思维、技术选型、架构设计、求职面试、副业思维、个人成长等内容。阅读结束后，反思和总结所学内容，并尝试应用到现实中，有助于深化理解和应用知识。接下来，我将为大家呈现正文内容。
ShardingSphere源码编译报错有些文件找不到
cainiao1412的博客
09-09 2370
shardingsphere.sql.parser.autogen.PostgreSQLStatementParser 等 Java 文件由于较大，默认配置的 IDEA。可以调整 IDEA 的属性：idea.max.intellisense.filesize=10000。所以需要执行以下命令快速生成。生成的代码例如 org.
既有项目修改shardingshpere分库分表踩坑记（一）
weixin_48484941的博客
11-15 255
在既有项目使用shardingshpere分库分表改造后。发现有些sql（例如：select * from order join user ）还需要关联单表（举例user表），user表没有做任何配置，故是单表，其他库查sql的话是找不到user表的，所以会报错。由于用户角色模块是单独的自研的工程配置的。工程还没有分表分库配置。对方也没打算改。所以只能自己想办法。
ShardingSphere不支持的SQL
勤于笔记，成于点滴。
07-20 4459
由于业务需要我们需要用sharding 进行分库分表，那么必须get到一些填坑指南，如下是其不支持的SQL。
Shardingsphere 4.1.1 版本坑
wangzhe969的博客
09-12 1761
SELECT COUNT(*) FROM ( SELECT XXX FROM XXX r LEFT JOIN YYY d ON r.id = d.resource_position_id AND d.tenant_code = '10001' WHERE 1 = 1 AND r.custom_id = ? AND r.is_deleted = 'N' AND r.tenant_code = '10001' GROUP BY r.id ...
postgresq数据库使用shardingsphere 避坑-分表归并和空指针异常
小菜bill的博客
07-02 554
postgresq数据库使用shardingsphere 避坑-分表归并和空指针异常
navicat连接ShardingSphere分表分库插件的坑
温建平的博客
12-21 1707
最近刚好在了解分表分库这个知识，买了个专栏学习。第一步就遇到坑，根据步骤启动成功了ShardingSphere，但是使用Navicat Premium 15一直连接不上，报下面这个错误 Navicat Premium 版本 错误： 一开始以为mysql配置问题，百度了此问题好久，最后通过几篇博客明白了。安装了一个Navicat Premium 11版本终于能连接上了。相关的博客地址贴下面： ShardingSphere应用专题–4.1.1版本–Sharding-Proxy的使用（十六）_
springboot2.0集成ShardingSphere-jdbc5.0-alpha所遇到的一些坑
dhaibo1986的专栏
09-21 7207
在springboot 2.5.3中配置使用ShardingSphere 5.0-alpha遇到了不少的坑，现在总结如下： 1.没有使用shardingsphere-jdbc-core-spring-boot-starter 在使用ShardingSphere的过程中，首先参考了下快速入门： https://shardingsphere.apache.org/document/5.0.0-alpha/cn/quick-start/shardingsphere-jdbc-quick-start/ 这个地方有
填坑：sharding-sphere不支持多条Sql语句的批量更新
fang0604631023的博客
03-31 4289
sharding-sphere分库分表，批量更新的问题
记ShardingSphere-JDBC的一个坑（SQLFeatureNotSupportedException: getObject with type）
Mark4z
08-19 8734
近日在使用Mybatis的时候出现了这么一个奇怪的报错：SQLFeatureNotSupportedException: getObject with type 现场还原： Mybatis: 3.5.2+ JDBC: shardingsphere-jdbc 4.0.1- Error attempting to get column 'update_time' from result set. Cause: java.sql.SQLFeatureNotSupportedException: getObjec
sharding 不支持sql关键字情况的解决方案
baidu_23263735的博客
11-08 3713
springboot使用sharding 插件不支持sql中含有以下关键字： 不支持HAVING 不支持OR，UNION 和 UNION ALL 不支持特殊INSERT 每条INSERT语句只能插入一条数据，不支持VALUES后有多行数据的语句 不支持DISTINCT聚合 不支持dual虚拟表 不支持SELECT LAST_INSERT_ID() 不支持CASE WHEN 对于...
ShardingSphere核心源码剖析
小强同志的博客
02-16 1951
下载源码（选择自己喜欢的版本即可） https://github.com/apache/incubator-shardingsphere/archive/4.0.0-RC2.zip 2、导入工程到IDEA 3、sharding-core-parse编译 注意先编译此工程是因为：工程内的部分类需要依靠antlr4 SQL解析引擎生成，否则直 接编译sharding工程讲报部分类找不到的错误。 编译本工程注意用的是：lifecycle下的install 4、编译全工程 注意是用..
sharding 目前支持和不支持的 sql
Angus
02-21 4009
描述：使用sharding中间件，不支持一些sql 具体看官网：https://shardingsphere.apache.org/document/current/cn/features/sharding/use-norms/sql/
shardingsphere-jdbc(5.0.0)
dengdai123654的博客
01-26 2691
5.0.0
springcloud alibaba框架整合sharding, durid, postgresql，配置文件使用properties
02-16
<think>嗯，用户想要了解如何将Spring Cloud Alibaba框架整合Sharding、Druid和PostgreSQL，并且使用properties配置文件。首先，我需要确认用户的具体需求。Spring Cloud Alibaba通常用于微服务架构，而ShardingSphere可能是指分库分表或者读写分离，Druid是数据库连接池，PostgreSQL是数据库。用户可能是在搭建一个分布式系统，需要整合这些组件。 首先，我应该考虑各个组件的版本兼容性。Spring Boot、Spring Cloud Alibaba、ShardingSphere、Druid和PostgreSQL驱动之间需要版本匹配，否则可能会出现兼容性问题。比如，Spring Cloud Alibaba的版本需要与Spring Boot版本对应，ShardingSphere的版本也需要适配。 接下来，依赖配置。用户需要使用Maven或Gradle来管理依赖。需要添加Spring Cloud Alibaba的依赖，比如Nacos用于服务发现和配置管理，Sentinel用于流量控制。然后是ShardingSphere的JDBC驱动，Druid的starter，以及PostgreSQL的驱动。需要确保这些依赖的版本正确，并且没有冲突。 然后是配置文件部分，用户要求使用properties格式。需要配置数据源，ShardingSphere的规则，比如分片策略、分片键、分片算法。Druid的连接池参数，比如初始大小、最大活跃连接数等。同时，可能还需要配置Spring Cloud Alibaba的相关组件，比如Nacos的地址，Sentinel的配置。 在数据源配置方面，使用ShardingSphere的数据源，并指定实际的数据库节点。比如，配置两个数据源ds0和ds1，分别指向不同的PostgreSQL实例。然后定义分片策略，比如根据用户ID取模分片。同时，主键生成策略可能需要配置，比如使用Snowflake算法。 另外，Druid的连接池配置需要正确设置，确保连接池的参数合理，避免资源泄露或性能问题。例如，initialSize、minIdle、maxActive等参数。 可能还需要注意事务管理，ShardingSphere和Spring的事务整合是否会有问题，是否需要额外配置。此外，分布式事务可能需要使用Seata，但用户没有提到，所以可能暂时不考虑。 测试部分，用户可能需要编写简单的CRUD操作来验证分片是否生效，数据是否正确地分布在不同的数据源中。同时，检查Druid监控是否正常，连接池是否工作。 可能遇到的坑包括版本冲突、分片策略配置错误、数据源名称不匹配、Druid配置未生效等。需要提醒用户注意检查日志，确保所有配置正确加载，并且组件初始化成功。 总结步骤应该是：创建项目，配置依赖，编写properties配置文件，定义数据源和分片规则，配置Druid，配置Spring Cloud Alibaba组件，编写测试代码验证。以下是</think>关于整合 **Spring Cloud Alibaba**、**ShardingSphere-JDBC**（分库分表）、**Druid**（连接池）与 **PostgreSQL** 的步骤说明，基于 `properties` 配置文件格式。 --- ### 1. 环境依赖 确保 `pom.xml` 中包含以下核心依赖（版本需匹配）： ```xml <!-- Spring Cloud Alibaba --> <dependency> <groupId>com.alibaba.cloud</groupId> <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId> <version>2022.0.0.0-RC2</version> </dependency> <!-- ShardingSphere-JDBC --> <dependency> <groupId>org.apache.shardingsphere</groupId> <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId> <version>5.3.2</version> </dependency> <!-- Druid 连接池 --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.2.18</version> </dependency> <!-- PostgreSQL 驱动 --> <dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId> <version>42.6.0</version> </dependency> ``` --- ### 2. 配置文件 (`application.properties`) ```properties # ========== Spring Cloud Alibaba Nacos ========== spring.cloud.nacos.discovery.server-addr=127.0.0.1:8848 # ========== ShardingSphere 数据源配置 ========== # 定义数据源名称（多个用逗号分隔） spring.shardingsphere.datasource.names=ds0,ds1 # 配置数据源 ds0 spring.shardingsphere.datasource.ds0.type=com.alibaba.druid.pool.DruidDataSource spring.shardingsphere.datasource.ds0.driver-class-name=org.postgresql.Driver spring.shardingsphere.datasource.ds0.url=jdbc:postgresql://localhost:5432/db0 spring.shardingsphere.datasource.ds0.username=postgres spring.shardingsphere.datasource.ds0.password=123456 # 配置数据源 ds1 spring.shardingsphere.datasource.ds1.type=com.alibaba.druid.pool.DruidDataSource spring.shardingsphere.datasource.ds1.driver-class-name=org.postgresql.Driver spring.shardingsphere.datasource.ds1.url=jdbc:postgresql://localhost:5432/db1 spring.shardingsphere.datasource.ds1.username=postgres spring.shardingsphere.datasource.ds1.password=123456 # ========== Sharding 分片规则 ========== # 分表策略：user 表按 user_id 取模分片 spring.shardingsphere.rules.sharding.tables.user.actual-data-nodes=ds$->{0..1}.user_$->{0..1} spring.shardingsphere.rules.sharding.tables.user.table-strategy.standard.sharding-column=user_id spring.shardingsphere.rules.sharding.tables.user.table-strategy.standard.sharding-algorithm-name=user-table-inline # 分库策略：按 user_id 取模分库 spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.type=INLINE spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.props.algorithm-expression=ds$->{user_id % 2} # 分表算法配置 spring.shardingsphere.rules.sharding.sharding-algorithms.user-table-inline.type=INLINE spring.shardingsphere.rules.sharding.sharding-algorithms.user-table-inline.props.algorithm-expression=user_$->{user_id % 2} # 分布式主键生成策略 spring.shardingsphere.rules.sharding.key-generators.snowflake.type=SNOWFLAKE spring.shardingsphere.rules.sharding.key-generators.snowflake.props.worker-id=123 # ========== Druid 连接池配置 ========== # 连接池通用参数 spring.datasource.druid.initial-size=5 spring.datasource.druid.min-idle=5 spring.datasource.druid.max-active=20 spring.datasource.druid.test-on-borrow=true spring.datasource.druid.validation-query=SELECT 1 # 监控页面配置（可选） spring.datasource.druid.stat-view-servlet.enabled=true spring.datasource.druid.stat-view-servlet.url-pattern=/druid/* ``` --- ### 3. 关键配置说明 1. **ShardingSphere-JDBC**： - `actual-data-nodes`：定义物理表分布，如 `ds0.user_0, ds1.user_1`。 - 分片策略：通过 `sharding-column` 指定分片键，`algorithm-expression` 定义分片算法（支持 Groovy 表达式）。 - 分布式主键：使用 Snowflake 算法生成唯一 ID。 2. **Druid**： - 通过 `spring.datasource.druid.*` 配置连接池参数。 - 启用监控页面（访问 `/druid` 查看统计信息）。 3. **PostgreSQL**： - 确保数据库驱动与 URL 格式正确（如 `jdbc:postgresql://host:port/dbname`）。 --- ### 4. 验证与调试 1. **启动应用**：检查日志中是否成功加载 ShardingSphere 和 Druid 配置。 2. **监控页面**：访问 `http://localhost:port/druid` 查看 Druid 连接池状态。 3. **分片测试**：插入数据时观察数据是否按规则分布到不同库表。 --- ### 5. 注意事项 - **版本兼容性**：确保 Spring Boot、Spring Cloud Alibaba、ShardingSphere 和 Druid 版本匹配。 - **事务管理**：如需跨库事务，可结合 `Seata`（Spring Cloud Alibaba 生态的分布式事务组件）。 - **SQL 兼容性**：验证 PostgreSQL 语法是否与 ShardingSphere 的路由规则兼容。 如有具体需求（如读写分离、加密等），可进一步调整 ShardingSphere 配置。
评论 9
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值