为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
驱动版本:
<dependency>
<groupId>com.dameng</groupId>
<artifactId>DmJdbcDriver18</artifactId>
<version>8.1.3.140</version>
</dependency>
数据库版本:
执行的select和update语句,没有问题,数据库运行也正常。
连接串信息:
jdbc:dm://172.16.0.178:30236/MDA?keywords=(DOMAIN,COMMENT,CONTEXT)
update语句:
update
"MDA"."MDA_DATA" "User"
set
"User"."VAL5" = ?,"User"."VAL4" = ?,"User"."VAL3" = ?,"User"."VAL14" = ?,"User"."VAL7" = ?,"User"."VAL10" = ?,"User"."VAL2" = ?,"User"."VAL1" = ?,"User"."VAL0" = ?,"User"."MODIFIER" = ?,"User"."INDEX1" = ?,"User"."GMT_MODIFIED" = ?,"User"."INDEX2" = ?,"User"."INDEX3" = ?,"User"."CREATOR" = ?
where
(
"User"."VAL2" = ?
and "User"."INDEX2" = ?
and "User"."TENANT_ID" = ?
and "User"."OBJ_ID" = ?
and "User"."STATUS" = ?
);
报错信息:
java.net.SocketTimeoutException: Read timed out
请问改如何处理这种问题?
建议检查下应用服务器与数据库服务器之间是否做了哪些网络层的设置
查看驱动版本,在数据库安装目录下drivers目录有对应版本,是连接断开还是数据库服务停止了
SELECT* FROM V$SESSIONS;查看下你JDBC应用的连接驱动版本是不是太低了