注册

部分sql报网络通信异常

盲目的拾荒者 2024/10/23 316 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:1-3-140-2024.05.07-227421-20093-ENT
【操作系统】:
【CPU】: armv8
【问题描述】*:部分sql执行时报网络通信一样。具体异常如下。
但其他sql执行就没问题,

The error occurred while setting parameters

SQL: UPDATE id_t_user_org_position SET org_id = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, user_id = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, job = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, show_order = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, email = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, pwd_level = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, user_office_phone = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, office_address = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, jh_email = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, job_type = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, position = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, job_level = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, job_duty = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, certificate_cn = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, job_ext1 = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, job_ext2 = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, job_ext3 = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, job_ext4 = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, job_attribute = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, approval_job_level = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, status = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, update_by = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, valid_time = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, position_type = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, technology_position = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, job_ext = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END, level_one_org = CASE WHEN id = ? THEN ? WHEN id = ? THEN ? END WHERE tenant_id = 1 AND id IN (?, ?)

Cause: dm.jdbc.driver.DMException: 网络通信异常

; 网络通信异常; nested exception is dm.jdbc.driver.DMException: 网络通信异常

Caused by: java.io.EOFException
at dm.jdbc.c.a.c.a(ByteArrayBuffer.java:1281) ~[DmJdbcDriver-18.jar!/:?]
at dm.jdbc.c.a.c.a(ByteArrayBuffer.java:1267) ~[DmJdbcDriver-18.jar!/:?]
at dm.jdbc.c.a.b.a(ByteArrayBuffer.java:1046) ~[DmJdbcDriver-18.jar!/:?]
at dm.jdbc.c.a.c(DBAccess.java:970) ~[DmJdbcDriver-18.jar!/:?]
at dm.jdbc.c.a.a(DBAccess.java:890) ~[DmJdbcDriver-18.jar!/:?]
at dm.jdbc.c.a.a(DBAccess.java:365) ~[DmJdbcDriver-18.jar!/:?]
at dm.jdbc.driver.DmdbPreparedStatement.executeInner(DmdbPreparedStatement.java:212) ~[DmJdbcDriver-18.jar!/:?]
at dm.jdbc.driver.DmdbPreparedStatement.do_execute(DmdbPreparedStatement.java:301) ~[DmJdbcDriver-18.jar!/:?]
at dm.jdbc.driver.DmdbPreparedStatement.execute(DmdbPreparedStatement.java:1621) ~[DmJdbcDriver-18.jar!/:?]
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497) ~[druid-1.1.24.jar!/:1.1.24]
at sun.reflect.GeneratedMethodAccessor555.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) ~[mybatis-3.5.6.jar!/:3.5.6]
at com.sun.proxy.$Proxy633.execute(Unknown Source) ~[?:?]

sql用客户端工具执行是没问题的。
报上面错误后,看数据库日志报
[ERROR] database P0001386835 T0000000000002502594 cmd 13 validate error!

驱动用的是 DmJdbcDriver-18.jar

回答 0
暂无回答
扫一扫
联系客服