注册

数据类型不匹配

文春 2023/09/18 1002 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:win10
【CPU】:i5
【问题描述】*:

Error querying database. Cause: dm.jdbc.driver.DMException: 第19 行附近出现错误:

数据类型不匹配

The error may exist in URL [jar:file:/D:/programs/oms/osms3.5/osms_archiver/target/OSS_Beta_V3.5.3.11/WEB-INF/lib/osms_service-0.0.1-SNAPSHOT.jar!/com/netzon/osms/model/mapper/MsgInfMapper.xml]

The error may involve MsgInf.findLastSendSuccess

The error occurred while executing a query

SQL: SELECT "MSG_ID","NODELOG_ID","MSG_REC_TYPE", "MSG_RECEIVE", "MSG_TITLE","MSG_CONTEXT", "MSG_STATE","CASE_ID", "MSG_TYPE","MSG_SENDEMAIL", "MSG_SENDSMS","RECEIVE_ID", "READ_USER","ADDRESSEE_ID", "MSG_REPLY","BELONG_ORG", "CREAT_USER","CREAT_TIME", "UPDATE_USER","UPDATE_TIME", "COMMENT","MSG_SEND_STATE" FROM mp_msg_inf WHERE 1=1 AND msg_title = ? AND TEXT_EQUAL(MSG_CONTEXT,?) AND MSG_RECEIVE = ? AND MSG_STATE = 3 ORDER BY UPDATE_TIME DESC LIMIT 0, 1;

Cause: dm.jdbc.driver.DMException: 第19 行附近出现错误:

数据类型不匹配
; 第19 行附近出现错误:
数据类型不匹配

<select id="findLastSendSuccess" resultMap="msgInfResult">
SELECT "MSG_ID","NODELOG_ID","MSG_REC_TYPE",
"MSG_RECEIVE",
"MSG_TITLE","MSG_CONTEXT",
"MSG_STATE","CASE_ID",
"MSG_TYPE","MSG_SENDEMAIL",
"MSG_SENDSMS","RECEIVE_ID",
"READ_USER","ADDRESSEE_ID",
"MSG_REPLY","BELONG_ORG",
"CREAT_USER","CREAT_TIME",
"UPDATE_USER","UPDATE_TIME",
"COMMENT","MSG_SEND_STATE"
FROM mp_msg_inf
WHERE 1=1
AND msg_title = #{msgTitle}
AND TEXT_EQUAL(MSG_CONTEXT,#{msgContext})
AND MSG_RECEIVE = #{msgReceive}
AND MSG_STATE = 3
ORDER BY UPDATE_TIME DESC
LIMIT 0, 1;
</select>

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