Rate This Document
Findability
Accuracy
Completeness
Readability

Changing the Database Connection Configuration

  1. Check the current database connection configuration.

    After the migration is complete, you can choose Configuration Migration Report > View Details on the migration result page to view the configuration files that need to be modified.

    Take application-druid.yml as an example:

    Figure 1 Suggestion

    Click View Details to view the modification suggestion.

    Figure 2 Viewing details
  2. Change the DM8 database connection configuration.

    In this practice, the database is switched from MySQL to DM8. You need to modify the database source information and driver dependency.

    Decompress the downloaded RuoYi package RuoYi-master.zip and use VS Code to open the folder.

    • Modification 1: database source configuration

      Change the MySQL database driver in the ruoyi-admin/src/main/resources/application-druid.yml file to the DM8 database driver.

      Replace the 5th line with the following code:

      1
      driverClassName: dm.jdbc.driver.DmDriver
      

      Replace lines 9 to 11 with the following lines. Note that the IP address in the URL must be changed to the DM8 server IP address.

      1
      2
      3
      url: jdbc:dm://192.168.0.3:5236?schema=ry&useUnicode=true&characterEncoding=utf8
      username: SYSDBA
      password: SYSDBA
      

      Example:

    • Modification 2: driver dependency configuration

      Change the MySQL driver dependency in the ruoyi-admin/pom.xml file to the DM8 driver dependency.

      Replace lines 46 to 50 with the following lines:

      1
      2
      3
      4
      5
      <dependency>
          <groupId>com.dameng</groupId>
          <artifactId>DmJdbcDriver18</artifactId>
          <version>8.1.3.140</version>
      </dependency>
      

      Example: