Home > Back-end >  Mybaties error problem and solutions
Mybaties error problem and solutions

Time:09-25

# Mybaties XML

` ` `
The update newcontent set NEWNAME=# {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} where NEWID=# {NEWID, jdbcType=VARCHAR}

` ` `
* * NORDER=# {NORDER, jdbcType=NUMERIC} is this sentence has a problem I give this to remove programs running normally, this is not right with * *


* * entities corresponding attributes are:
Private Integer norder; * *

* * controller, services, and the dao layer checked norder is value * *

* * the oracle database corresponding fields: NORDER is NUMBER type * *

# error message:

` ` `
This application has no explicit mapping for/error, so you are seeing This as a fallback.

Mon May 11 01:24:02 CST 2020
There was an unexpected error (type=Internal Server error, the status=500).
nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='newid', mode=IN, javaType=class java.lang.String, jdbcType=VARCHAR, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #9 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: ??????
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='newid', mode=IN, javaType=class java.lang.String, jdbcType=VARCHAR, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #9 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: ??????
The at org. Mybatis. Spring. MyBatisExceptionTranslator. TranslateExceptionIfPossible (MyBatisExceptionTranslator. Java: 78)
The at org. Mybatis. Spring. SqlSessionTemplate $SqlSessionInterceptor. Invoke (SqlSessionTemplate. Java: 440)
At com. Sun. Proxy. $Proxy60. Update (Unknown Source)
The at org. Mybatis. Spring. SqlSessionTemplate. Update (SqlSessionTemplate. Java: 287)
The at org. Apache. Ibatis. Binding. MapperMethod. Execute (MapperMethod. Java: 62)
The at org. Apache. Ibatis. Binding. MapperProxy. Invoke (MapperProxy. Java: 59)
At com. Sun. Proxy. $Proxy65. Contentup (Unknown Source)
At sun. Reflect. NativeMethodAccessorImpl. Invoke0 (Native Method)
At sun. Reflect. NativeMethodAccessorImpl. Invoke (NativeMethodAccessorImpl. Java: 62)
At sun. Reflect. DelegatingMethodAccessorImpl. Invoke (43) DelegatingMethodAccessorImpl. Java:
The at Java. Lang. Reflect. Method. Invoke (498) Method. The Java:
The at org. Springframework. Aop. Support. AopUtils. InvokeJoinpointUsingReflection (AopUtils. Java: 343)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. InvokeJoinpoint (ReflectiveMethodInvocation. Java: 198)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. Proceed (ReflectiveMethodInvocation. Java: 163)
The at org. Springframework. Dao. Support. PersistenceExceptionTranslationInterceptor. Invoke (PersistenceExceptionTranslationInterceptor. Java: 139)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. Proceed (ReflectiveMethodInvocation. Java: 186)
The at org. Springframework. Aop. Framework. JdkDynamicAopProxy. Invoke (JdkDynamicAopProxy. Java: 212)
At com. Sun. Proxy. $Proxy66. Contentup (Unknown Source)
At com. Mall. Shopping. Demo. Services. NewcontentService. Contentupdate (NewcontentService. Java: 23)
At com. Mall. Shopping. Demo. Controller. NewcontentController. Updatecontent (NewcontentController. Java: 284)
At sun. Reflect. NativeMethodAccessorImpl. Invoke0 (Native Method)
At sun. Reflect. NativeMethodAccessorImpl. Invoke (NativeMethodAccessorImpl. Java: 62)
At sun. Reflect. DelegatingMethodAccessorImpl. Invoke (43) DelegatingMethodAccessorImpl. Java:
The at Java. Lang. Reflect. Method. Invoke (498) Method. The Java:
The at org. Springframework. Web. Method. Support. InvocableHandlerMethod. DoInvoke (InvocableHandlerMethod. Java: 189)
The at org. Springframework. Web. Method. Support. InvocableHandlerMethod. InvokeForRequest (InvocableHandlerMethod. Java: 138)
The at org. Springframework. Web. Servlet. MVC) method. The annotation. ServletInvocableHandlerMethod. InvokeAndHandle (ServletInvocableHandlerMethod. Java: 102)
The at org. Springframework. Web. Servlet. MVC) method. The annotation. RequestMappingHandlerAdapter. InvokeHandlerMethod (RequestMappingHandlerAdapter. Java: 895)
The at org. Springframework. Web. Servlet. MVC) method. The annotation. RequestMappingHandlerAdapter. HandleInternal (RequestMappingHandlerAdapter. Java: 800)
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related