为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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: 类型转换异常
可能是驱动版本的问题,更换下mybatis的jdbc驱动试试,到数据库安装目录下有个drivers目录,找到jdbc目录,把里面的驱动复制一份,放到mybatis驱动目录下更换一下,mybatis目录下原驱动文件可以备份一下,然后重启mybatis程序再试试
https://eco.dameng.com/community/article/ea82c4859f3a509443aea48f1ae4ff9c
开启jdbc的日志,看看具体的问题