Try setting a different JdbcType for this parameter or a different configuration property
-
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='auditStatus', mode=IN, javaType=class java.lang.Integer, jdbcType=VARCHAR, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException
-
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='auditStatus', mode=IN, javaType=class java.lang.Integer, jdbcType=VARCHAR, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException
-
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
-
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
-
at com.sun.proxy.$Proxy26.selectOne(Unknown Source)
-
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
-
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
-
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:93)
-
at com.sun.proxy.$Proxy85.getProcModel(Unknown Source)
-
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
-
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
-
at java.lang.reflect.Method.invoke(Method.java:498)
-
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
-
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
-
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
-
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
-
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
-
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
-
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
-
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
-
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
-
at com.sun.proxy.$Proxy86.getProcModel(Unknown Source)
-
at com.ftcs.userinfo.service.service.impl.ExitCompanyAuditServiceImpl.getProcModel(ExitCompanyAuditServiceImpl.java:101)
-
at com.ftcs.userinfo.service.service.impl.ExitCompanyAuditServiceImpl$$FastClassBySpringCGLIB$$336c7faf.invoke(<generated>)
-
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
-
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:750)
-
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
-
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
-
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
-
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
-
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
-
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
-
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
-
at com.ftcs.userinfo.service.service.impl.ExitCompanyAuditServiceImpl$$EnhancerBySpringCGLIB$$fe4fb185.getProcModel(<generated>)
-
at org.apache.dubbo.common.bytecode.Wrapper39.invokeMethod(Wrapper39.java)
-
at org.apache.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:47)
-
at org.apache.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:84)
-
at org.apache.dubbo.config.invoker.DelegateProviderMetaDataInvoker.invoke(DelegateProviderMetaDataInvoker.java:56)
-
at org.apache.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:56)
-
at org.apache.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:77)
-
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
-
at org.apache.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:46)
-
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
-
at org.apache.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:91)
-
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
-
at org.apache.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:52)
-
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
-
at com.alibaba.dubbo.rpc.Invoker$CompatibleInvoker.invoke(Invoker.java:55)
-
at com.ftcs.commons.dubbo.trace.filter.TraceProviderFilter.invoke(TraceProviderFilter.java:60)
-
at com.alibaba.dubbo.rpc.Filter.invoke(Filter.java:29)
-
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
-
at org.apache.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:192)
-
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
-
at org.apache.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38)
-
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
-
at org.apache.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:41)
-
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
-
at org.apache.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:129)
-
at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
-
at org.apache.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:148)
-
at org.apache.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:100)
-
at org.apache.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:175)
-
at org.apache.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:51)
-
at org.apache.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:57)
-
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
-
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
-
at org.apache.dubbo.common.threadlocal.InternalRunnable.run(InternalRunnable.java:41)
-
at java.lang.Thread.run(Thread.java:748)
-
Caused by: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='auditStatus', mode=IN, javaType=class java.lang.Integer, jdbcType=VARCHAR, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException
-
at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:89)
-
at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:94)
-
at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64)
-
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:88)
-
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
-
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
-
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
-
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:136)
-
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
-
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
-
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
-
at sun.reflect.GeneratedMethodAccessor253.invoke(Unknown Source)
-
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
-
at java.lang.reflect.Method.invoke(Method.java:498)
-
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
-
... 65 more
-
Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException
-
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:71)
-
at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:87)
-
... 79 more
-
Caused by: java.lang.ClassCastException
上面的报错提示重点看下面
Could not set parameters for mapping: ParameterMapping{property='auditStatus', mode=IN, javaType=class java.lang.Integer, jdbcType=VARCHAR, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='auditStatus', mode=IN, javaType=class java.lang.Integer, jdbcType=VARCHAR, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException
这边是sql
-
<select id="getProcModel" parameterType="java.lang.Integer" resultMap="BaseResultMap">
-
select
-
<include refid="Base_Column_List" />
-
from exit_company_audit
-
where is_deleted = 0
-
and user_id = #{userId, jdbcType=INTEGER}
-
and audit_status = #{auditStatus, jdbcType=VARCHAR}
-
</select>
这个提示就很明显了,属性auditStatus设置了一个和其本身数据类型不一致的数据,那么可能的情况有哪些?
1:java中写的dao中auditStatus的数据类型和sql中auditStatus的数据类型不一致
解决方案:修改成一致或者直接删掉sql中auditStatus的jdbcType
2:parameterType="java.lang.Integer"中表示参数是Integer,但是你有两个参数,auditStatus是varchar的.
解决方案:删除paramType这个参数
3:还有就是sql中auditStatus的和java中auditStatus的名称不一样(这个不是我这边存在的问题)
这篇好文章是转载于:学新通技术网
- 版权申明: 本站部分内容来自互联网,仅供学习及演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,请提供相关证据及您的身份证明,我们将在收到邮件后48小时内删除。
- 本站站名: 学新通技术网
- 本文地址: /boutique/detail/tanhfhkchi
-
photoshop保存的图片太大微信发不了怎么办
PHP中文网 06-15 -
Android 11 保存文件到外部存储,并分享文件
Luke 10-12 -
word里面弄一个表格后上面的标题会跑到下面怎么办
PHP中文网 06-20 -
《学习通》视频自动暂停处理方法
HelloWorld317 07-05 -
微信公众号没有声音提示怎么办
PHP中文网 03-31 -
photoshop扩展功能面板显示灰色怎么办
PHP中文网 06-14 -
excel下划线不显示怎么办
PHP中文网 06-23 -
excel打印预览压线压字怎么办
PHP中文网 06-22 -
怎样阻止微信小程序自动打开
PHP中文网 06-13 -
photoshop蒙版画笔没反应怎么办
PHP中文网 06-24