问题场景
在项目中采用了hibernate ,连接数据库原本为ORACLE,后续打算改造为国产数据库 达梦
链接配置:
# 达梦写法,
index:
driver-class-name: dm.jdbc.driver.DmDriver
jdbc-url: jdbc:dm://192.168.220.225:5236/IDX4
username: SYSDBA
password: SYSDBA
#low:低频;high:高频;all:低频+高频
server-type: low
#英语:en_US;中文:zh_CN;
language: zh_CN
#分布式唯一节点id
node-id: 1
# 回零配置
zero-tag:
# 是否启用回零: 启用:true; 禁用:false
enable: false
# 回零判断中 逐渐上升的斜率,斜率大于等于0并且小于等于max-rate此配置时执行回零逻辑
max-rate: 100
# 回零判断中, 低点到上升点之间的点数,大于等于此配置时执行回零逻辑
range-count: 0
supplant:
# 指标是否同步到SupOS
enable-ems-sync: true
# SupOS 地址
ems-sync-url: http://192.168.90.223:8080
#排班日历 本地模式local 平台模式supplant
scheduling-mode: local
#一批读取位号数量
read-tag-num: 10000
#标准数据服务时区
tagTimeZone: '0800'
#supplant 模式下是否每天更新排班
auto-update: false
# 是否引用测点SDK
is-enable-tagSDK: false
# 排班起始于 1表示昨天,2表示今天
team-offset-type: 1
#sqlserver 分区
database:
filepath: C:\database\index\
server:
port: 20081
shutdown: graceful
spring:
application:
name: index-service
lifecycle:
timeout-per-shutdown-phase: 10s
main:
allow-bean-definition-overriding: true
datasource:
driver-class-name: ${index.driver-class-name}
url: ${index.jdbc-url}
username: ${index.username}
password: ${index.password}
type: com.zaxxer.hikari.HikariDataSource
jpa:
# 达梦数据库
# properties:
# hibernate:
# dialect: org.hibernate.dialect.Oracle12cDialect
#方言结束
hibernate:
ddl-auto: 'update'
naming:
physicalStrategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
show-sql: true
open-in-view: false
thymeleaf:
prefix: classpath:/templates/
check-template-location: true
suffix: .html
mode: LEGACYHTML5
encoding: UTF-8
content-type: text/html
cache: false
jackson:
time-zone: GMT+8
redis:
host: 192.168.90.223
port: 6379
password:
database: 0
timeout: 10000
jedis:
pool:
max-active: 100
max-idle: 20
min-idle: 10
max-wait: -1
mybatis-plus:
mapper-locations: classpath:/mapper/*Mapper.xml
configuration:
cache-enabled: false
scDog:
heartbeat: 600
springfox:
documentation:
enabled: true
启动过程中遇到的问题:
"C:\Program Files\Java\jdk1.8.0_202\bin\java.exe" -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:49779,suspend=y,server=n -javaagent:C:\Users\qcby4\AppData\Local\JetBrains\IdeaIC2023.1\captureAgent\debugger-agent.jar -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_202\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_202\jre\lib\rt.jar;D:\Project\QCBY\qcby-sass\qcby-parent\qcby-service\target\classes;D:\Project\QCBY\qcby-sass\qcby-parent\qcby-api\target\classes;D:\Project\resourse\repository227\maven\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.3\jackson-datatype-jsr310-2.11.3.jar;D:\Project\resourse\repository227\maven\com\fasterxml\jackson\core\jackson-annotations\2.12.3\jackson-annotations-2.12.3.jar;D:\Project\resourse\repository227\maven\com\fasterxml\jackson\core\jackson-core\2.12.3\jackson-core-2.12.3.jar;D:\Project\resourse\repository227\maven\com\fasterxml\jackson\core\jackson-databind\2.12.3\jackson-databind-2.12.3.jar;D:\Project\resourse\repository227\maven\org\mybatis\mybatis-typehandlers-jsr310\1.0.1\mybatis-typehandlers-jsr310-1.0.1.jar;D:\Project\resourse\repository227\maven\io\springfox\springfox-boot-starter\3.0.0\springfox-boot-starter-3.0.0.jar;D:\Project\resourse\repository227\maven\io\springfox\springfox-oas\3.0.0\springfox-oas-3.0.0.jar;D:\Project\resourse\repository227\maven\io\swagger\core\v3\swagger-annotations\2.1.2\swagger-annotations-2.1.2.jar;D:\Project\resourse\repository227\maven\io\swagger\core\v3\swagger-models\2.1.2\swagger-models-2.1.2.jar;D:\Project\resourse\repository227\maven\io\springfox\springfox-spi\3.0.0\springfox-spi-3.0.0.jar;D:\Project\resourse\repository227\maven\io\springfox\springfox-schema\3.0.0\springfox-schema-3.0.0.jar;D:\Project\resourse\repository227\maven\io\springfox\springfox-core\3.0.0\springfox-core-3.0.0.jar;D:\Project\resourse\repository227\maven\io\springfox\springfox-spring-web\3.0.0\springfox-spring-web-3.0.0.jar;D:\Project\resourse\repository227\maven\io\github\classgraph\classgraph\4.8.83\classgraph-4.8.83.jar;D:\Project\resourse\repository227\maven\io\springfox\springfox-spring-webmvc\3.0.0\springfox-spring-webmvc-3.0.0.jar;D:\Project\resourse\repository227\maven\io\springfox\springfox-spring-webflux\3.0.0\springfox-spring-webflux-3.0.0.jar;D:\Project\resourse\repository227\maven\io\springfox\springfox-swagger-common\3.0.0\springfox-swagger-common-3.0.0.jar;D:\Project\resourse\repository227\maven\org\mapstruct\mapstruct\1.3.1.Final\mapstruct-1.3.1.Final.jar;D:\Project\resourse\repository227\maven\i