为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:Windows 10
【CPU】:AMD Ryzen 5 3500U
【问题描述】*:
hikariCP 3.4.5版本 连接时会连接超时,Connection timed out: connect 采用JDBC直连时可以正常连接,是什么情况导致的
数据源配置如下
datasource:
dynamic:
primary: master
strict: false
datasource:
master:
driver-class-name: dm.jdbc.driver.DmDriver
url: jdbc:dm://IP:5236?schema=PARK
username: PARK
password: Keytop@123
readPark:
driver-class-name: dm.jdbc.driver.DmDriver
url: jdbc:dm://IP:5236?schema=PARK
username: PARK
password: Keytop@123
kos:
driver-class-name: dm.jdbc.driver.DmDriver
url: jdbc:dm://IP:5236?schema=KOS
username: KOS
password: Keytop@123
coupon:
driver-class-name: dm.jdbc.driver.DmDriver
url: jdbc:dm://IP:5236?schema=KOS
username: KOS
password: Keytop@123
cp:
driver-class-name: dm.jdbc.driver.DmDriver
url: jdbc:dm://IP:5236?schema=PARK
username: PARK
password: Keytop@123
type: com.zaxxer.hikari.HikariDataSource
hikari:
# 连接池中允许的最大连接数。缺省值:10;推荐的公式:((core_count * 2) + effective_spindle_count)
maximum-pool-size: 20
minimum-idle: 10
auto-commit: true
idle-timeout: 30000
pool-name: HikariCP
max-lifetime: 1800000
connection-timeout: 30000
connection-test-query: SELECT 1
url: jdbc:dm://IP:5236?schema=PARK
把IP换成真实的ip试下呢?