springboot集成shardingsphere启动失败

最新推荐文章于 2024-04-29 22:33:04 发布
最新推荐文章于 2024-04-29 22:33:04 发布
阅读量6.9k 收藏 8
点赞数
文章标签： spring boot
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43569417/article/details/127965753
版权

 错误信息：

Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/baomidou/mybatisplus/autoconfigure/MybatisPlusAutoConfiguration.class]: Unsatisfied dependency expressed through method 'sqlSessionFactory' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'dataSource' defined in class path resource [org/apache/shardingsphere/spring/boot/ShardingSphereAutoConfiguration.class]: Unsatisfied dependency expressed through method 'dataSource' parameter 0; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'org.apache.shardingsphere.infra.config.mode.ModeConfiguration' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {}
	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:541) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1519) ~[spring-beans-5.3.19.jar:5.3.19]
	... 45 common frames omitted
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'dataSource' defined in class path resource [org/apache/shardingsphere/spring/boot/ShardingSphereAutoConfiguration.class]: Unsatisfied dependency expressed through method 'dataSource' parameter 0; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'org.apache.shardingsphere.infra.config.mode.ModeConfiguration' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {}
	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:541) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:887) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) ~[spring-beans-5.3.19.jar:5.3.19]
	... 58 common frames omitted
Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'org.apache.shardingsphere.infra.config.mode.ModeConfiguration' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {}
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.raiseNoMatchingBeanFound(DefaultListableBeanFactory.java:1799) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1394) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:887) ~[spring-beans-5.3.19.jar:5.3.19]
	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) ~[spring-beans-5.3.19.jar:5.3.19]
	... 72 common frames omitted

环境中pom添加的shardingsphere依赖和版本为

        <dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
            <version>5.1.1</version>
        </dependency>

yml中对于shardingsphere的配置

spring:
  shardingsphere:
    datasource:
      names: db0
      common:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
      db0:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/xxx?useUnicode=true&characterEncoding=UTF8&serverTimezone=Asia/Shanghai&useSSL=false&verifyServerCertificate=false
        username: root
        password: xxxx
  rules:
    sharding:
      # 配置绑定表，每一行为一组
      binding-tables:
        - biblio_temp, collection
        - collection, reader_lend_record
        - collection, history_reader_lend_record
      tables:
        collection:
          actual-data-nodes: db0.collection_$->{0..9}
          database-strategy:
            column: id
            key-generator-name: snowflake
          talbe-strategy:
            standrad:
              sharding-column: school_id
              sharding-algorithm-name: collection-table-standard
      collection-table-standard:
        type: inline
        props: collection_$->{school_id % 10}
  props:
    sql:
      show: true

我报错原因为：

        mode模式默认的没有生效，需要主动添加

          

github apache/springsphere上大佬提供了一个参考配置：

spring:
  shardingsphere:
    props:
      sql-show: true
    datasource:
      ds0:
        username: root
        password: 123456
        url: jdbc:mysql://127.0.0.1:3306/test0
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
      ds1:
        username: root
        password: 123456
        url: jdbc:mysql://127.0.0.1:3306/test1
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
      names: ds0, ds1
    rules:
      sharding:
        sharding-algorithms:
          # 分表算法
          table-inline:
            type: INLINE
            props:
              algorithm-expression: t_user$->{id % 2}
          # 分库算法
          database-inline:
            type: INLINE
            props:
              algorithm-expression: ds$->{sharding_key % 2}

        tables:
          t_user:
            actual-data-nodes: ds$->{0..1}.t_user$->{0..1}
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
            # 分库策略
            database-strategy:
              standard:
                sharding-column: sharding_key
                sharding-algorithm-name: database-inline
            # 分表策略
            table-strategy:
              standard:
                sharding-column: id
                sharding-algorithm-name: table-inline
        key-generators:
          snowflake:
            type: SNOWFLAKE
            props:
              worker-id: 123
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true

记录一下

谋勇
关注
  • 0
    点赞
  • 踩
  • 8
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
springboot整合ShardingSphere5.2.1（最新版）
09-14
springboot整合ShardingSphere5.2.1（最新版）
springboot3.2.3集成shardingsphere5.4.1及动态数据源demo项目
04-12
springboot3.2.3+shardingsphere5.4.1+dynamic-datasource 1.解决了兼容问题 2.可以在多个动态数据源之前切换，包括CK及两个Mysql数据库
微服务启动慢，看我如何消灭这些憨憨怪！
最新发布
1点25的博客
04-29 7237
这样SpringBoot启动时就只会扫描指定的包路径，这样Bean扫描的效率就会高很多，从而提高应用的启动速度，经过我测试，应用的启动速度又缩短了50秒左右，现在距离目标1分钟只有10秒左右了，开心。另外告诉大家一个秘密，我测试的这个微服务中总共有2000多个Bean对象，300个多@Service，200个@RestController~~~~欢迎关注我的公众号：IT周瑜。获取更多技术干货、免费经典面试资料。
Sharding Sphere 配置错误导致启动失败问题排查
GhostGuest的博客
08-09 3456
直接在 (TypedSPIRegistry.java:76)行和(AbstractAlgorithmProvidedBeanRegistry.java:78) 行所在的方法打上断点。而我的前缀（spring.sharding-sphere）是IDEA智能提示出来的，如下，使用了中划线的写法，，如果我们配置的属性前缀和配置类中的映射不一致，就会导致启动失败。官网直接给的配置是具体某项的配置，并没有给具体的前缀。因为我们配置的前缀是。前缀，所以最终可以确认是配置写错导致的问题。前缀，而我们配置的是。
SpringBoot + ShardingSphere分库分表实战(附完整代码)
04-11
Spring Boot ShardingSphere 分库分表 附代码
SpringBoot集成Sharding-jdbc（水平分表）
计算机小白的奋起
04-20 1539
SpringBoot整合Sharding-JDBC实现水平分表
No qualifying bean of type 问题
陌上人如玉，公子世无双
07-27 6万+
No qualifying bean of type 问题
关于org.springframework.beans.factory.UnsatisfiedDependencyException报错解决问题方法
qq_30062771的博客
12-12 5576
最近按照网上的demo做了一个springboot的小项目，为了整合springboot和mybatis+xml进行演示，但是在配置时一直报错，纠结了两个小时： 如下是启动springboot是的报错： org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ...
[报错解决]（Error Creating bean with name ‘xxx‘）类问题解决思路
jcc4261的博客
11-27 2万+
遇到Error Creating bean with name ’ '这类问题的解决思路大意如下：不满足依赖异常。创建名为’xxxMapper’的bean时出错:通过字段’sqlSessionFactory’表达的不满足的依赖项;
# 解决 Error creating bean with name ‘dataSource‘ defined in class path resource [applicationContext
shisanxiang_的博客
10-11 3047
Error creating bean with name 'dataSource' defined in class path resource [applicationContext.xml]: BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with
springboot报错Error creating bean with name ‘dataSource‘的解决方案
qq_62923382的博客
05-17 8579
此异常的根本原因是类“org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseType”的“NoClassDefFoundError”。要解决此问题，应确保在项目的生成配置中正确包含必要的依赖项。具体来说，您需要确保在构建文件（例如，Maven的pom.xml或Gradle的build.Gradle）中正确指定了“spring-jdbc”依赖项。Spring应用程序中名为“dataSource”的bean的依赖项注入存在问题。
springboot集成datax的demo
08-26
springboot集成datax的demo，下载及能运行
springboot集成测试里的redis
08-26
SpringBoot 集成测试中的 Redis 在 SpringBoot 项目中，集成测试是一个非常重要的步骤，它可以确保我们的应用程序在不同的场景下都能正常工作。在这个过程中，Redis 是一个非常重要的组件，因为它可以作为缓存层、...
错误解决：Error creating bean with name ‘XXX‘: Unsatisfied dependency expressed through field ‘XXX‘.
m0_56426418的博客
03-26 3万+
Error creating bean with name 'XXX': Unsatisfied dependency expressed through field 'XXX'.
Spring 报错：Error creating bean with name的解决方法
热门推荐
一勺菠萝丶的博客
11-27 7万+
在使用springboot构建 oltu-oauth的时候启动项目报错 在网上找一下没找到 ,之前项目对比发现忘记在WebApplication中少加了个注解 加上之后问题解决,查了下这个注解(横线以下是对@MapperSecan的介绍): 之前是，直接在Mapper类上面添加注解@Mapper，这种方式要求每一个mapper类都需要添加此注解，麻烦。 通过使用@MapperScan可以指定...
Error creating bean with name ‘dataSourceScriptDatabaseInitializer‘ defined in class path resource [
weixin_45929885的博客
10-01 1万+
Error creating bean with name ‘dataSourceScriptDatabaseInitializer’ defined in class path resource [org/springframework/boot/autoconfigure/sql/init/DataSourceInitializationConfiguration.class]: Unsatisfied dependency expressed through method ‘dataSourceScr
Unsatisfied dependency expressed through bean property ‘sqlSessionFactory‘报错解决
qq_43854669的博客
05-04 7888
在测试代码的时候碰到 Unsatisfied dependency expressed through bean property 'sqlSessionFactory' 其实有个大哥写的很详细 具体可以参考 （亲测解决）Unsatisfied dependency expressed through bean property 'sqlSessionFactory'_TianXinCoord的博客-CSDN博客 如果说这位大哥的方法不管用 而且你的代码报错最后一段有 这种情况你大概率跟我一样.
Spring报错:Error creating bean with name SqlSessionFactory....not find resource com/dao/StudentDao.xml
qq_20026471的博客
11-26 1796
layout: post title: spring报错：提示找不到mapper文件’ date: 2021-08-19 author: Futari cover: ‘http://on2171g4d.bkt.clouddn.com/jekyll-banner.png’ tags: Java spring 在学习spring过程中执行单元测试时提示报错 下面是报错信息的第一行 org.springframework.beans.factory.BeanCreationException: Error .
ShardingSphere问题解决（一）
小熙的博客
05-19 5万+
概要：错误信息 Data sources cannot be empty shardingSphere版本 shardingshpere_version=4.1.0 sharding_jdbc_spring_namespace_version=4.1.0 compile("org.apache.shardingsphere:sharding-jdbc-spring-boot-starter:${shardingshpere_version}") compile("org.apache.shardings
springboot集成shardingsphere
03-16
Spring Boot集成ShardingSphere的步骤如下： 1. 添加ShardingSphere依赖 在pom.xml文件中添加ShardingSphere的依赖： ``` <dependency> <groupId>org.apache.shardingsphere</groupId> <artifactId>sharding-jdbc-spring-boot-starter</artifactId> <version>${shardingsphere.version}</version> </dependency> ``` 2. 配置ShardingSphere 在application.yml文件中配置ShardingSphere的数据源和分片规则： ``` spring: shardingsphere: datasource: names: ds, ds1 ds: type: com.zaxxer.hikari.HikariDataSource driver-class-name: com.mysql.jdbc.Driver jdbc-url: jdbc:mysql://localhost:3306/db username: root password: root ds1: type: com.zaxxer.hikari.HikariDataSource driver-class-name: com.mysql.jdbc.Driver jdbc-url: jdbc:mysql://localhost:3306/db1 username: root password: root sharding: tables: user: actual-data-nodes: ds$->{..1}.user_$->{..1} table-strategy: inline: sharding-column: id algorithm-expression: user_$->{id % 2} ``` 3. 编写代码 在代码中使用ShardingSphere的数据源进行数据库操作： ``` @Autowired private DataSource dataSource; public void addUser(User user) { String sql = "insert into user (id, name, age) values (?, ?, ?)"; try (Connection conn = dataSource.getConnection(); PreparedStatement ps = conn.prepareStatement(sql)) { ps.setLong(1, user.getId()); ps.setString(2, user.getName()); ps.setInt(3, user.getAge()); ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } } ``` 以上就是Spring Boot集成ShardingSphere的基本步骤。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值