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

时间:2024-09-23 10:34:38

错误信息: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.52\webapps\chp-loan\WEB-INF\classes\mappings\blue\PaybackBlueMapper.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即可!