欢迎使用CSDN-markdown编辑器

来源：互联网发布：主合取范式编程编辑：程序博客网时间：2024/06/06 23:50

以后将所有遇到难啃的异常一一分享给大家，供自己以后查阅和各位博友参考。
异常描述详情：
2015-05-20 14:24:26 -38241 [685701223@qtp-890910007-3] ERROR - org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: java.lang.NumberFormatException: For input string: “A”

Cause: java.lang.NumberFormatException: For input string: “A”

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: java.lang.NumberFormatException: For input string: “A”

Cause: java.lang.NumberFormatException: For input string: “A”

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:365)at com.sun.proxy.$Proxy29.selectList(Unknown Source)at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:195)at com.zhongying.dao.DaoSupport.findForList(DaoSupport.java:118)at com.zhongying.service.pon.worksheet.WorksheetService.list(WorksheetService.java:56)at com.zhongying.service.pon.worksheet.WorksheetService$$FastClassByCGLIB$$e5c2c137.invoke(<generated>)at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)at com.zhongying.service.pon.worksheet.WorksheetService$$EnhancerByCGLIB$$c77dc8f6.list(<generated>)at com.zhongying.controller.pon.worksheet.WorksheetController.eponlist(WorksheetController.java:66)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

异常说明：数据库字段为oracle char（1），即一个字符，查询时通过where status = ‘A’ 是没有问题的，但是在mybatis中使用就有问题，肯定是mybatis的原因了。
mybatis中mapper文件sql：

0 0