apollo数据库从MySQL迁移到达梦

一.在添加达梦数据库相关依赖包

1. (1).下载数据库驱动，下载地址：https://download.csdn.net/download/zhaobh9527/12721873
   (2).下载达梦的hibernate方言包下载地址：https://download.csdn.net/download/zhaobh9527/12728052
2. 上传数据库驱动到私有仓库，在项目pom和apollo-common中添加依赖
   (1).工程的pom中添加maven依赖

			<!--dm驱动-->
			<dependency>
				<groupId>com.dm</groupId>
				<artifactId>DmJdbcDriver</artifactId>
				<version>1.8</version>
			</dependency>
			<!--dm的hibernate方言包-->
			<dependency>
				<groupId>com.dm.dialect</groupId>
				<artifactId>hibernate4</artifactId>
				<version>5.3</version>
			</dependency>

(2).在apollo-common 的pom中添加依赖

        <dependency>
            <groupId>com.dm</groupId>
            <artifactId>DmJdbcDriver</artifactId>
        </dependency>
        <dependency>
            <groupId>com.dm.dialect</groupId>
            <artifactId>hibernate</artifactId>
        </dependency>

注：如果没有maven的私有仓库则执行以下操作。
3. (1).在工程下建lib文件夹，将jar包复制进去

(2).在apollo-common的src下建lib文件夹，将jar包复制进去

4. pom文件里添加依赖

 <dependency>
            <groupId>com.dm</groupId>
            <artifactId>DmJdbcDriver</artifactId>
            <version>1.8</version>
            <scope>system</scope>              		<systemPath>${project.basedir}/lib/DmJdbcDriver18.jar</systemPath>
  </dependency>
   <dependency>
            <groupId>com.dm.dialect</groupId>
            <artifactId>hibernate</artifactId>
            <version>5.3</version>
            <scope>system</scope>  
            <systemPath>${project.basedir}/lib/DmDialect-for-hibernate5.3.jar</systemPath>
  </dependency>

4. apollo-common 的pom添加依赖

<!--dm-->
        <dependency>
            <groupId>com.dm</groupId>
            <artifactId>DmJdbcDriver</artifactId>
              <scope>system</scope>
            <systemPath>${basedir}/src/lib/DmJdbcDriver18.jar</systemPath>
        </dependency>
        <dependency>
            <groupId>com.dm.dialect</groupId>
            <artifactId>hibernate</artifactId>
            <version>5.3</version>
            <scope>system</scope>
            <systemPath>${basedir}/src/lib/DmDialect-for-hibernate5.3.jar</systemPath>
        </dependency>

二、更改配置文件application.properties

1. 去掉mysql的配置

#spring.datasource.hikari.connectionInitSql=set names utf8mb4
#spring.jpa.database-platform=org.hibernate.dialect.MySQLDialect

2. 达梦添加部分

spring.jpa.database-platform=org.hibernate.dialect.DmDialect
spring.jpa.show-sql=true
spring.datasource.driver-class-name=dm.jdbc.driver.DmDriver

三、去掉打包文件中的相关配置，配置直接从config下读取

# package config-service and admin-service
echo "==== starting to build config-service and admin-service ===="

# mvn clean package -DskipTests -pl apollo-configservice,apollo-adminservice -am -Dapollo_profile=github -Dspring_datasource_url=$apollo_config_db_url -Dspring_datasource_username=$apollo_config_db_username -Dspring_datasource_password=$apollo_config_db_password
mvn clean package -DskipTests -pl apollo-configservice,apollo-adminservice -am -Dapollo_profile=github

echo "==== building config-service and admin-service finished ===="

echo "==== starting to build portal ===="

# mvn clean package -DskipTests -pl apollo-portal -am -Dapollo_profile=github,auth -Dspring_datasource_url=$apollo_portal_db_url -Dspring_datasource_username=$apollo_portal_db_username -Dspring_datasource_password=$apollo_portal_db_password $META_SERVERS_OPTS
mvn clean package -DskipTests -pl apollo-portal -am -Dapollo_profile=github,auth

echo "==== building portal finished ===="

四、AuthConfiguration类，去掉sql语句中表名的单引号