Spring boot 同时连接达梦6和达梦7数据库

最新推荐文章于 2024-05-24 22:55:02 发布

代码不听话

最新推荐文章于 2024-05-24 22:55:02 发布

阅读量348

点赞数 1

文章标签： spring boot 数据库 linux

本文链接：https://blog.csdn.net/qq_39132795/article/details/132625370

版权

pom依赖

 <!-- 达梦数据库连接驱动 -->
 <dependency>
            <groupId>dm.jdbc</groupId>
            <artifactId>dm-jdbc</artifactId>
            <version>7.0.0</version>
            <scope>system</scope>
            <systemPath>${project.basedir}/src/main/resources/lib/dm-jdbc-7.0.0.jar</systemPath>
        </dependency>
        <!-- 达梦数据库连接驱动 -->
        <dependency>
            <groupId>dm.jdbc</groupId>
            <artifactId>dm-jdbc</artifactId>
            <version>6.0.0</version>
            <scope>system</scope>
            <systemPath>${project.basedir}/src/main/resources/lib/Dm6JdbcDriver.jar</systemPath>
        </dependency>

yml

  datasource:
    dynamic:
      primary: db-DM7 #设置默认的数据源或者数据源组,默认值即为master
      strict: false
      datasource:
        db-DM7:
          type: com.alibaba.druid.pool.DruidDataSource
          driver-class-name: dm.jdbc.driver.DmDriver
          url: jdbc:dm://localhost:5236/SG_DATACENTER?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
          username: SYSDBA
          password: SYSDBA
        db-DM6:
          type: com.alibaba.druid.pool.DruidDataSource
          driver-class-name: dm6.jdbc.driver.DmDriver
          url: jdbc:dm6://192.168.233.132:12345/SYSTEM?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
          username: SYSDBA
          password: SYSDBA