Mysql 更换达梦数据源后一直 Set network timeout error

为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:DmJdbcDriver18.jar

【操作系统】：win11
【CPU】:inter
【问题描述】*：Exception in thread "HikariPool-1 network timeout executor" java.lang.RuntimeException: Set network timeout error
at dm.jdbc.driver.DBError.throwRuntimeException(DBError.java:626)
at dm.jdbc.c.a.setSoTimeout(DBAccess.java:1077)
at dm.jdbc.driver.DmdbConnection$5.run(DmdbConnection.java:1322)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.net.SocketException: Socket is closed

下面是我的项目的一些配置信息
springBootVersion = '2.7.17'
mybatisPlusVersion = '3.5.2'

spring:
datasource:
driverClassName: dm.jdbc.driver.DmDriver
url: jdbc:dm://xxxxxx?schema=xxxx
username: SYSDBA
password: xxxx
hikari:
connection-timeout: 5000 # 连接超时时间，单位毫秒
connection-test-query: SELECT 1 FROM DUAL

已解决: 更换了最新的 jdbc驱动,就可以了

回答 0

暂无回答

lysrwhjy

该评论已被删除

发布于 2023/11/28 09:43

有事打电话

又复现了, 上面的解决方案灭用

发布于 2023/12/05 17:45

大夹子

我也有同样的问题，用的jdbc驱动是：DmJdbcDriver18-8.1.2.141.jar，只有用了Hikari连接池的项目出现了这个问题，请问下有没有好的解决方案呢

发布于 2023/12/21 11:27

一位不愿透露姓名的网友

我这里也出现了类似问题，一直报错，是什么原因造成的

Exception in thread "HikariPool-1 network timeout executor" java.lang.RuntimeException: Set network timeout error
at dm.jdbc.driver.DBError.throwRuntimeException(DBError.java:625)
at dm.jdbc.c.a.setSoTimeout(DBAccess.java:1053)
at dm.jdbc.driver.DmdbConnection$4.run(DmdbConnection.java:1260)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: java.net.SocketException: Socket is closed
at java.base/sun.nio.ch.SocketAdaptor.setSoTimeout(SocketAdaptor.java:313)
at dm.jdbc.c.a.setSoTimeout(DBAccess.java:1048)
... 4 more
Exception in thread "HikariPool-1 network timeout executor" java.lang.RuntimeException: Set network timeout error
at dm.jdbc.driver.DBError.throwRuntimeException(DBError.java:625)
at dm.jdbc.c.a.setSoTimeout(DBAccess.java:1053)
at dm.jdbc.driver.DmdbConnection$4.run(DmdbConnection.java:1260)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: java.net.SocketException: Socket is closed
at java.base/sun.nio.ch.SocketAdaptor.setSoTimeout(SocketAdaptor.java:313)
at dm.jdbc.c.a.setSoTimeout(DBAccess.java:1048)
... 4 more

springboot版本：3.2.2
达梦驱动版本： 8.1.1.49
达梦连接池配置：
hikari:
minimum-idle: 5
maximum-pool-size: 15
connection-timeout: 30000
idle-timeout: 600000
max-lifetime: 1800000
connection-test-query: SELECT 1 FROM DUAL

发布于 2024/11/13 09:52