shardingjdbc4.0.0-RC1--＞RC2 读写分离示例错误排查

Tony带水!

已于 2023-12-04 15:06:20 修改

阅读量543

点赞数

分类专栏： Java 文章标签： java spring boot mybatis maven intellij-idea mysql

于 2023-10-01 16:42:51 首次发布

本文链接：https://blog.csdn.net/qq_42468502/article/details/133465863

版权

Java 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

0. 前言

环境：CentOS7.8+mysql5.7.29+jdk1.8+maven3.5

框架：springboot2.4.5 + mybatisplus3.4.2(mybatis-plus-boot-starter)+sharding-jdbc4.0.0-RC2(sharding-jdbc-spring-boot-starter兼容性问题由1改成2)+druid

项目视频参考—>shardingjdbc读写分离案例

觉得文字太多的铁子可以直接看【3.依赖冲突问题解决方法总结】

详细排查过程看【2.兼容性问题排查】

------------------------------------------------------------

1.数据库连接性问题

错误原因：数据库连接不上，要么数据库没开，要么访问不了10.0.0.200:3307

INFO 12396 — [ main] com.itheima.Application
ERROR 12396 — [eate-2142450580] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://10.0.0.200:3307/rw?characterEncoding=utf-8, errorCode 0, state 08S01

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Caused by: java.net.ConnectException: Connection refused: connect

解决思路：1.检查url是否正确 2.mysql是否设置了防火墙 3.数据库是否支持远程访问(本地安装不算)

----------------------------------------------------------

2. 依赖兼容性问题排查

2.1 SpringBootConfiguration配置类缺少依赖类问题

因为依赖问题，源demo的druid-spring-boot-starter的SpringBootConfiguration类缺少以下三个类

EncryptDataSourceFactory
MasterSlaveDataSourceFactory
ShardingDataSourceFactory

排查过程：
运行demo

监控台打印：
java.lang.IllegalArgumentException: Unresolvable class definition for class [org.apache.shardingsphere.shardingjdbc.spring.boot.sharding.SpringBootShardingRuleConfigurationProperties]
Caused by: java.lang.NoClassDefFoundError: org/apache/shardingsphere/core/yaml/config/sharding/YamlShardingRuleConfiguration
at java.lang.ClassLoader.defineClass
…
Caused by: java.lang.ClassNotFoundException: org.apache.shardingsphere.core.yaml.config.sharding.YamlShardingRuleConfiguration
at java.net.URLClassLoader.findClass

YamlShardingRuleConfiguration有该类的话是可以打开的，但是报红了且不能打开
在这里插入图片描述

提示还是不够明显，加入以下坐标帮助查询错误信息

<dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>sharding-core-common</artifactId>
    <version>4.0.0-RC1</version>
</dependency>

清除缓存maven clean+idea Invalidate Cache：在这里插入图片描述
再次运行

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘userController’: Unsatisfied dependency expressed through field ‘dataSource’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘dataSource’ defined in class path resource [org/apache/shardingsphere/shardingjdbc/spring/boot/SpringBootConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method ‘dataSource’ threw exception; nested exception is java.lang.NoClassDefFoundError: org/apache/shardingsphere/shardingjdbc/api/MasterSlaveDataSourceFactory

Caused by: java.lang.ClassNotFoundException: org.apache.shardingsphere.shardingjdbc.api.MasterSlaveDataSourceFactory
at java.net.URLClassLoader.findClass(URLClassLoader.java)

再查看SpringBootConfiguration.class上面import导入的api都报红了

import org.apache.shardingsphere.shardingjdbc.api.EncryptDataSourceFactory;
import org.apache.shardingsphere.shardingjdbc.api.MasterSlaveDataSourceFactory;
import org.apache.shardingsphere.shardingjdbc.api.ShardingDataSourceFactory;

结论：说明springboot2.4.5应该是不兼容shardingjdbc4.0.0RC1的

解决方法尝试：shardingjdbc4.0.0RC1升级到shardingjdbc4.0.0RC2

思路：再次查看import导入的api是正常且不报红，说明springboot2.4.5兼容shardingjdbc4.0.0RC2，可以继续往下搞

不兼容就没有必要继续

清除缓存maven clean+idea Invalidate Cache：
在这里插入图片描述

2.2 DruidDataSourceAutoConfigure自动配置数据源失败问题

druid-spring-boot-starter的DruidDataSourceAutoConfigure类不能获取到
spring.shardingsphere. datasource配置，即appplication.yml数据源配置这一段：

spring:
  shardingsphere:
    datasource:

排查过程

继2.1再次运行排查

WARN 9112 — [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘userController’: Unsatisfied dependency expressed through field ‘dataSource’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘dataSource’ defined in class path resource [com/alibaba/druid/spring/boot/autoconfigure/DruidDataSourceAutoConfigure.class]: Invocation of init method failed; nested exception is org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver class

Failed to configure a DataSource: ‘url’ attribute is not specified and no embedded datasource could be configured.
Reason: Failed to determine a suitable driver class
Action:
Consider the following:
If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).

根据提示查看com/alibaba/druid/spring/boot/autoconfigure/DruidDataSourceAutoConfigure.class类

这个网友给了一段注释思路：https://blog.csdn.net/evalsys/article/details/107165308
非常感谢
不然真的淦

在这里插入图片描述

//if not found prefix 'spring.datasource.druid' jdbc properties ,'spring.datasource' prefix jdbc properties will be used.
如果没有找到前缀'spring.datasource.druid '  jdbc属性, 将使用spring.datasource前缀jdbc属性去创建数据源

实际根据spring.datasource.druid或者spring.datasource查找jdbc属性是找不到的，

因为老师的demo里面的application.yml文件配置结构是spring.shardingsphere.datasource

server:
  port: 8080
spring:
  application:
    name: reggie
  shardingsphere:
    datasource:
      names: master,slave
      master:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://10.0.0.200:3306/reggie?characterEncoding=utf-8
        username: root
        password: 111111
      slave:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://10.0.0.200:3307/reggie?characterEncoding=utf-8
        username: root
        password: 111111
    masterslave:
      load-balance-algorithm-type: round_robin
      name: dataSource
      master-data-source-name: master
      slave-data-source-names: slave
    props:
      sql.show: true
  main:
    allow-bean-definition-overriding: true
  redis:
    host: 127.0.0.1
    port: 6379
    password: 123456
    database: 0
  cache:
    redis:
      time-to-live: 1800000
  servlet:
    multipart:
      max-file-size: 50MB
      max-request-size: 50MB
mybatis-plus:
  configuration:
    map-underscore-to-camel-case: true
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  global-config:
    db-config:
      id-type: ASSIGN_ID
reggie:
  path: D:\reggie\img\

解决方式1：

1）如果想继续用druid-spring-boot-starter，则在启动类上排除druid自动配置
@SpringBootApplication(exclude = {DruidDataSourceAutoConfigure.class})
2）升级shardingjdbc，把坐标改成RC2

        <dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
            <version>4.0.0-RC2</version>
        </dependency>

解决方式2：

1）升级shardingjdbc，把坐标改成RC2
2）如果不想更改启动类，则修改pom坐标

com.alibaba druid-spring-boot-starter 1.1.23 改为 com.alibaba druid 1.1.23

我选择更改坐标

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.4.5</version>
        <relativePath/>
    </parent>
    <groupId>com.cctv</groupId>
    <artifactId>rw_demo</artifactId>
    <version>1.0-SNAPSHOT</version>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
            <version>4.0.0-RC2</version>
        </dependency>
        <dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>sharding-core-common</artifactId>
            <version>4.0.0-RC2</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.20</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.76</version>
        </dependency>
        <dependency>
            <groupId>commons-lang</groupId>
            <artifactId>commons-lang</artifactId>
            <version>2.6</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.2</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.23</version>
        </dependency>
    </dependencies>
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <version>2.4.5</version>
            </plugin>
        </plugins>
    </build>
</project>

原demo+修改后demo链接：https://pan.baidu.com/s/1sy0V3oFh6umIBLAcBBx1Kg?pwd=1234
提取码：1234

----------------------------------------------------------

3. 依赖冲突问题解决方法总结

①问题描述：2022年出的瑞吉外卖项目shardingjdbc4.0.0-RC1有依赖冲突问题，有类未实现，导致无法正常创建数据源，运行失败

②解决方法
解决方法1:（推荐，亲测可行）

升级shardingjdbc，把坐标改成RC2
把druid-spring-boot-starter改成druid
maven clean + Invalidate Cache（不做该步骤可能有缓存问题）

解决方法2：

升级shardingjdbc，把坐标改成RC2
不改druid，还是使用druid-spring-boot-starter，
在启动类加上@SpringBootApplication(exclude = {DruidDataSourceAutoConfigure.class})
maven clean + Invalidate Cache（不做该步骤可能有缓存问题）

----------------------------------------------------------

4. idea maven坐标资源下载慢问题

如果嫌弃idea加载坐标资源慢
可以手动下载安装jar包到本地仓库方便maven坐标加载（前提已经安装maven）：示例如下
1、去到- - ->maven中央仓库https://mvnrepository.com
2、下载jar包步骤：

1）搜索druid-spring-boot-starter

在这里插入图片描述

2）选择版本
在这里插入图片描述

3）一般选择jar下载
在这里插入图片描述
4）到下载文件的所在路径上方地址栏输入cmd进入win命令窗口

输入以下命令回车安装jar包到本地maven仓库
mvn install:install-file -Dfile=druid-spring-boot-starter-1.2.19.jar -DgroupId=com.alibaba -DartifactId=druid-spring-boot-starter -Dversion=1.2.19 -Dpackaging=jar -settings=D:\Java_data\apache-maven-3.5.2\conf\settings.xml
在这里插入图片描述
-settings指定maven仓库配置文件

成功提示：在这里插入图片描述
idea的maven刷新加入安装好的坐标，刷新就能使用

觉得有帮助的老铁，允许给个小赞鼓励一下!😎😎😎😎
其他问题–>

Tony带水!

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
打赏
0
评论
shardingjdbc4.0.0-RC1--＞RC2 读写分离示例错误排查

linux环境：CentOS7.8+mysql5.7.29框架：springboot2.4.5 + mybatisplus3.4.2(mybatis-plus-boot-starter)+sharding-jdbc4.0.0-RC2(sharding-jdbc-spring-boot-starter兼容性问题由1改成2)+druid。
复制链接

扫一扫