Skip to main content

Switching Among Databases

There are small changes using different databases.

Sample

Specify 'data_service' attribute in Model File root node

data_service="mysql"

Here is an example:

<root alias_model_name="artworkfeed"
cfg_mask_china_mobile="false"

english_name="artwork feed"
data_service="mysql"
name="artworkfeed" org="doublechaintech">

Dependencies changes

build.gradle

    implementation 'mysql:mysql-connector-java:8.0.33'

or using Maven

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.33</version>
</dependency>

Change datasource parameters

applicaiton.properties

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://${DB_HOST}:3306/${DB_NAME}?allowPublicKeyRetrieval=true&useSSL=false&serverTimezone=UTC&characterEncoding=utf8
spring.datasource.username=${DB_USER}
spring.datasource.password=${DB_PASSWORD}

Note: set you environment variable or replace with your value in causion of secure standards.