注册

紧急求助,sql在达梦中单独执行没有问题,mybatis中就会有类型转换错误

Tiám 2024/08/05 581 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:
【CPU】:
【问题描述】:### Error querying database. Cause: dm.jdbc.driver.DMException: 类型转换异常 ### The error may exist in com/inspur/bank/datastatistics/dao/OrderResultReportMapper.xml ### The error may involve com.inspur.bank.datastatistics.dao.OrderResultReportMapper.listOrderResultByStatus-Inline ### The error occurred while setting parameters ### SQL: SELECT * FROM (SELECT TMP_TB.,ROWNUM ROW_ID FROM (select DISTINCT wo.id, wo.ordernum, inuse, wo.applytime, wo.companyname, product, wo.productcode, wo.bank, wo.bankcode, applyamount, applyterm, applyuse, wo.phone, orderstatus, creditamount, wo.credittime, applyusername, applyidcard, creditnum, legalpersonname, companyaddress, firstauditingtime, firstauditingresult, firstauditingwhy, firstauditingremark, updatetime, creaditterm, remark, wo.bankmanageraccount, wo.citycode, bindingtime, posttime, creditexpirydate, creditresult, creditfailcause, bankbranch, wo.user_id, rate, reminder_times, wwu.user_name, creditupdate, creditmaterials , wo.evaluate_time as evaluateTime, wo.evaluate_score as evaluateScore, wo.evaluate_content as evaluateContent, (SELECT wydt_wx_user.USER_NAME FROM wydt_wx_user WHERE wydt_wx_user.USER_ID = wo.bankmanageraccount) as nname, wxu.phone as bankmanagerphone, if(ISNULL(firstauditingtime), TIMESTAMPDIFF(HOUR, FROM_UNIXTIME(applytime), NOW())-24, TIMESTAMPDIFF(HOUR, FROM_UNIXTIME(applytime), FROM_UNIXTIME(firstauditingtime))-24) overtime, (SELECT audit_time_value FROM wydt_financial_organization WHERE ORG_CODE = wo.bankcode) as audit_time_value, (SELECT credit_time_value FROM wydt_financial_organization WHERE ORG_CODE = wo.bankcode) as credit_time_value, (SELECT loan_time_value FROM wydt_financial_organization WHERE ORG_CODE = wo.bankcode) as loan_time_value, wm.makeloanamount,wm.makeloantime,wm.makeloanexpirydate from wydt_order wo LEFT JOIN wydt_wx_user wxu ON wxu.USER_ID = wo.bankmanageraccount left join wydt_wx_user wwu on wo.assignBankManagerPhone = wwu.phone LEFT JOIN wydt_user wu ON wo.USER_ID = wu.id LEFT JOIN (SELECT ordernum, SUM(makeloanamount) as makeloanamount,MAX(makeloantime) as makeloantime, MAX(makeloanexpirydate) as makeloanexpirydate from wydt_makeloan GROUP BY ordernum) wm ON wo.ordernum=wm.ordernum where inuse = 'y' order by wo.applytime desc) TMP_TB WHERE ROWNUM<=25) WHERE ROW_ID>=1 ### Cause: dm.jdbc.driver.DMException: 类型转换异常 ; uncategorized SQLException for SQL []; SQL state [HY096]; error code [6007]; 类型转换异常; nested exception is dm.jdbc.driver.DMException: 类型转换异常

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