springboot工程从mysql迁移到达梦数据库之nacos适配

陈zzz

已于 2022-12-11 00:12:19 修改

阅读量516

点赞数

文章标签： spring boot 数据库 mysql

于 2022-11-23 10:03:58 首次发布

本文链接：https://blog.csdn.net/cheyzz/article/details/127984381

版权

nacos引入依赖驱动

方法一：仓库直接导入

<dependency>
  <groupId>com.dameng</groupId>
  <artifactId>Dm8JdbcDriver18</artifactId>
  <version>8.1.1.49</version>
</dependency>

方法二：相对路径导入 scope为system 需要在plugin里配置system打包
方法三：mvn命令导入

修改nacos源码
1. 修改ExternalDataSourceProperties
法一：在原有基础上改
法二：新建

	private String jdbcDriverName;
	
    public String getJdbcDriverName() {
        return jdbcDriverName;
    }

    public void setJdbcDriverName(String jdbcDriverName) {
        this.jdbcDriverName = jdbcDriverName;
    }

法一

// update start 自定义对达梦数据库的支持
            if (StringUtils.isNotEmpty(jdbcDriverName)) {
                System.out.println("####################################" + jdbcDriverName);
                // 设置模式名
                ds.setSchema("NACOS");
                ds.setDriverClassName(jdbcDriverName);
            }else {
                ds.setDriverClassName(JDBC_DRIVER_NAME);
            }

法二

System.out.println("===================================");
            System.out.println("jdbcDriverName=" + jdbcDriverName);
            if (StringUtils.isNotEmpty(jdbcDriverName)) {
                // 怎加其他数据库驱动
                ds.setDriverClassName(jdbcDriverName);
            } else {
                //默认为mysql驱动
                ds.setDriverClassName(JDBC_DRIVER_NAME);
            }
            System.out.println("===================================");
            System.out.println("dataSources=" + dataSources);

法三

System.out.println("#################################");
            System.out.println("jdbcDriverName=" + jdbcDriverName);
            if (StringUtils.isNotEmpty(jdbcDriverName)) {
                // 增加其他数据库驱动的支持
                ds.setDriverClassName(jdbcDriverName);
            } else {
                //默认使用mysql驱动
                ds.setDriverClassName(JDBC_DRIVER_NAME);
            }
            System.out.println("#################################");
            System.out.println("dataSources=" + dataSources);

修改ExternalDataSourceServiceImpl
法一：在原有基础上改
法二：新建

dataSourceList = new DMDataSourceProperties()

修改DynamicDataSource

 basicDataSourceService = new DMDataSourceServiceImpl();

修改PropertiesConstant

    public static final String DM = "dm";

修改PropertyUtil

setUseExternalDB(PropertiesConstant.DM.equalsIgnoreCase
(getString(PropertiesConstant.SPRING_DATASOURCE_PLATFORM, "")));

修改nacos配置

spring.datasource.platform=dm
db.num=1
db.jdbcDriverName=dm.jdbc.driver.DmDriver
db.url.0=jdbc:dm://127.0.0.1:5236/MAIN?STU&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
db.user.0=NACOS
db.password.0=NACOS!@#

启动
VM options：-Dnacos.standalone=true
打包nacos

mvn -Prelease-nacos -Dmaven.test.skip=true -Dpmd.skip=true -Dcheckstyle.skip=true clean install -U

修改StartingApplicationListener
工程引入依赖驱动
修改工程源码

参考：
https://blog.csdn.net/u010715243/article/details/126584579
https://huaweicloud.csdn.net/63356f28d3efff3090b56ca0.html?spm=1001.2101.3001.6650.5&utm_medium=distribute.pc_relevant.none-task-blog-2_defaultESLANDING_{activity-5-126015374-blog-126584579.pc_relevant_landingrelevant&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2}default_ESLANDINGactivity-5-126015374-blog-126584579.pc_relevant_landingrelevant&utm_relevant_index=6
https://blog.csdn.net/yy1209357299/article/details/123486377?spm=1001.2101.3001.6650.6&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7EESLANDING%7Edefault-6-123486377-blog-126584579.pc_relevant_landingrelevant&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7EESLANDING%7Edefault-6-123486377-blog-126584579.pc_relevant_landingrelevant&utm_relevant_index=7
https://developer.aliyun.com/article/976299
https://blog.csdn.net/weixin_40484820/article/details/127610640