The error occurred while setting parameters 错误解析--Bad value for type timestamp : 3

错误信息:nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.reflect.UndeclaredThrowableException
### The error may exist in file [D:apache-tomcat-7.0.52webappschp-loanWEB-INFclassesmappingsluePaybackBlueMapper.xml]
### The error may involve com.creditharmony.loan.borrow.blue.dao.PaybackBlueDao.findPayback-Inline
### The error occurred while setting parameters
### SQL: SELECT p.id as paybackId, p.contract_code, p.dict_pay_status, p.payback_day, p.payback_bule_amount, p.payback_month_amount, p.modify_time, p.payback_back_amount, p.payback_current_month, lc.customer_cert_num, lc.customer_name, lc.customer_telesales_flag, c.loan_code, c.product_type, c.contract_amount, c.contract_months, c.contract_month_repay_amount, c.contract_replay_day, c.contract_end_day, li.dict_loan_status, li.loan_team_orgid, li.loan_store_orgid, li.loan_flag, lb.id as loanBankId, lb.loan_code, lb.bank_account_name, lb.bank_account, lb.bank_branch, lb.bank_name, usa.r_grant_id, usa.urge_moeny, lg.grant_amount, pm.id as paybackMonthId, pm.MONTH_PENALTY_SHOULD as month_Penalty_Should_sum ,pm.MONTH_INTEREST_PUNISHSHOULD as month_Interest_Punishshould_Sum, pro.product_name from jk.t_jk_payback p LEFT JOIN jk.t_jk_contract c ON p.contract_code = c.contract_code LEFT JOIN jk.t_jk_loan_customer lc ON c.loan_code = lc.loan_code LEFT JOIN jk.t_jk_loan_info li ON c.loan_code = li.loan_code LEFT JOIN jk.t_jk_loan_bank lb ON lb.loan_code = c.loan_code LEFT JOIN jk.t_jk_loan_grant lg ON lg.contract_code = p.contract_code LEFT JOIN jk.t_jk_urge_services_amount usa ON usa.r_grant_id = lg.id LEFT JOIN jk.t_jk_payback_month pm ON pm.contract_code = p.contract_code and pm.months = p.payback_current_month LEFT JOIN JK.t_gl_jk_product pro on c.product_type = pro.product_code where 1=1 AND p.effective_flag = ? AND p.dict_pay_status in ('7','1','0') AND p.payback_bule_amount > ? AND p.create_time is not null order by p.create_time DESC limit ?
### Cause: java.lang.reflect.UndeclaredThrowableException

Bad value for type timestamp : 3

----------------------------

这个是字段错误,而且是字段类型修改了,由日期型转成字符型了,极其难找

p.payback_day,  就是这个字段

将实体类中的Date 改为String ,在jsp中修改为String即可!

原文地址:https://www.cnblogs.com/hoge/p/5257670.html