#Mybaties的xml
```
updatenewcontentsetNEWNAME=#{newname,jdbcType=VARCHAR},NEWJIANJIE=#{newjianjie,jdbcType=VARCHAR},NEWFENGMIAN=#{newfengmian,jdbcType=VARCHAR},NEWFENLEI=#{newfenlei,jdbcType=VARCHAR},NEWYINPIN=#{newyinpin,jdbcType=VARCHAR},NEWYUEDU=#{newyuedu,jdbcType=NUMERIC},NEWCONTEN=#{newconten,jdbcType=VARCHAR},NORDER=#{norder,jdbcType=NUMERIC}whereNEWID=#{newid,jdbcType=VARCHAR}
```
**NORDER=#{norder,jdbcType=NUMERIC}是这一句有问题我给这个去掉程序运行正常，加上这个就不对**
**实体的对应的属性是：
privateIntegernorder;**
**controller，services和dao层检查过了norder是有值的**
**oracle数据库对应的字段：NORDER是NUMBER类型**
#报错信息：
```
Thisapplicationhasnoexplicitmappingfor/error,soyouareseeingthisasafallback.
MonMay1101:24:02CST2020
Therewasanunexpectederror(type=InternalServerError,status=500).
nestedexceptionisorg.apache.ibatis.type.TypeException:Couldnotsetparametersformapping:ParameterMapping{property='newid',mode=IN,javaType=classjava.lang.String,jdbcType=VARCHAR,numericScale=null,resultMapId='null',jdbcTypeName='null',expression='null'}.Cause:org.apache.ibatis.type.TypeException:Errorsettingnonnullforparameter#9withJdbcTypeVARCHAR.TrysettingadifferentJdbcTypeforthisparameteroradifferentconfigurationproperty.Cause:java.sql.SQLException:??????
org.mybatis.spring.MyBatisSystemException:nestedexceptionisorg.apache.ibatis.type.TypeException:Couldnotsetparametersformapping:ParameterMapping{property='newid',mode=IN,javaType=classjava.lang.String,jdbcType=VARCHAR,numericScale=null,resultMapId='null',jdbcTypeName='null',expression='null'}.Cause:org.apache.ibatis.type.TypeException:Errorsettingnonnullforparameter#9withJdbcTypeVARCHAR.TrysettingadifferentJdbcTypeforthisparameteroradifferentconfigurationproperty.Cause:java.sql.SQLException:??????
atorg.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:78)
atorg.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
atcom.sun.proxy.$Proxy60.update(UnknownSource)
atorg.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:287)
atorg.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
atorg.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
atcom.sun.proxy.$Proxy65.contentup(UnknownSource)
atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
atjava.lang.reflect.Method.invoke(Method.java:498)
atorg.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
atorg.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
atorg.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
atcom.sun.proxy.$Proxy66.contentup(UnknownSource)
atcom.mall.shopping.demo.services.NewcontentService.contentupdate(NewcontentService.java:23)
atcom.mall.shopping.demo.controller.NewcontentController.updatecontent(NewcontentController.java:284)
atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
atjava.lang.reflect.Method.invoke(Method.java:498)
atorg.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)
atorg.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
atorg.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
atorg.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
atorg.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
atorg.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
atorg.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
atorg.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
atorg.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
atorg.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:660)
atorg.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:741)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
atorg.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
atorg.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
atorg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
atorg.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
atorg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
atorg.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
atorg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
atorg.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
atorg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
atorg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
atorg.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
atorg.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
atorg.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
atorg.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
atorg.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
atjava.lang.Thread.run(Thread.java:748)
Causedby:org.apache.ibatis.type.TypeException:Couldnotsetparametersformapping:ParameterMapping{property='newid',mode=IN,javaType=classjava.lang.String,jdbcType=VARCHAR,numericScale=null,resultMapId='null',jdbcTypeName='null',expression='null'}.Cause:org.apache.ibatis.type.TypeException:Errorsettingnonnullforparameter#9withJdbcTypeVARCHAR.TrysettingadifferentJdbcTypeforthisparameteroradifferentconfigurationproperty.Cause:java.sql.SQLException:??????
atorg.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:89)
atorg.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:93)
atorg.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64)
atorg.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
atorg.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
atorg.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
atorg.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
atorg.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
atsun.
分 --> |
