java.sql.SQLSyntaxErrorException:ORA-01722: 无效数字

最新推荐文章于 2024-04-18 09:10:13 发布

唱响星河

最新推荐文章于 2024-04-18 09:10:13 发布

阅读量1.6w

点赞数

文章标签： oracle

本文链接：https://blog.csdn.net/cxws110/article/details/78961473

版权

报错的代码：

org.springframework.dao.DataIntegrityViolationException:

### Error updating database. Cause: java.sql.SQLSyntaxErrorException:ORA-01722: 无效数字

### The error may involvecom.hotent.platform.model.system.SysUser.update-Inline

### The error occurred while settingparameters

### SQL: UPDATE sys_user SET fullname=? , account=? , password=? , isExpired=? , isLock=? , createtime=? , status=? , email=? , mobile=? , phone=? , sex=? , picture=?, fromType=?, entrydate=?, userStatus=?, pwdUpdTime=?, hasSyncToWx =?, weixinid =?, postId=?, postName=?, professionalId=?, professionalName=?, educationId=?, educationName=?, jobgrade=?, jobAge=?, companyAge=?, graduationDate=?, regularDate=?, leaveDate=?, IDENTIFICATION_CARDID=?, BIRTHDAY_DATE=?, AGES=?, JOB_DATE=?, SOCIAL_SECURITYNUM=?, SOCIAL_SECURITY_DEPART=?, NATION=?, POLITICAL_STATUS=?, HOUSEHOLDS=?, BIRTH_PLACE=?, ADDRESS=?, LINKMAN=?, RELATIONSHIP=?, LINKPHONE=?, PROBATION_SALARY=?, PAYMENT_PLACE=?, LEAVE_TYPE=?, IDENTIFICATION_EXPIRE=?, COMMUNICATION_PHONE=?, MOBILE_PHONE=?, OTHER_PHONE=?, WORKADDRESS=?, STATE=?, GRADUATESCHOOL=?, SPECIALTY=?, EDUCATIONAL_DEGREE=?, jobnum=? WHERE userId=?

### Cause: java.sql.SQLSyntaxErrorException:ORA-01722: 无效数字

; SQL []; ORA-01722: 无效数字

; nested exception is java.sql.SQLSyntaxErrorException: ORA-01722: 无效数字

atorg.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)

atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

atorg.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)

atorg.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:364)

atcom.sun.proxy.$Proxy10.update(Unknown Source)

atorg.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:250)

atcom.hotent.core.db.GenericDao.update(GenericDao.java:275)

atcom.hotent.platform.service.system.SysUserService.saveUser(SysUserService.java:566)

atcom.hotent.platform.service.system.SysUserService$$FastClassByCGLIB$$5cd2eb2b.invoke(<generated>)

atnet.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

atorg.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)

atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

atorg.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)

atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

atorg.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:42)

atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

atorg.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)

atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

atorg.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)

atcom.hotent.platform.service.system.SysUserService$$EnhancerByCGLIB$$e715394b.saveUser(<generated>)

atcom.hotent.platform.controller.system.SysUserFormController.save(SysUserFormController.java:132)

atcom.hotent.platform.controller.system.SysUserFormController$$FastClassByCGLIB$$a19ebad3.invoke(<generated>)

atnet.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

atorg.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)

atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

atorg.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)

atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

atorg.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)

atcom.hotent.platform.aop.LogAspect.doAudit(LogAspect.java:122)

atsun.reflect.GeneratedMethodAccessor233.invoke(Unknown Source)

atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

atjava.lang.reflect.Method.invoke(Method.java:606)

atorg.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)

atorg.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)

atorg.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)

atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

atorg.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)

atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

atorg.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)

atcom.hotent.platform.controller.system.SysUserFormController$$EnhancerByCGLIB$$510e853a.save(<generated>)

atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

atjava.lang.reflect.Method.invoke(Method.java:606)

atorg.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)

atorg.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:421)

atorg.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:409)

atorg.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:774)

atorg.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)

atorg.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)

atorg.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)

atjavax.servlet.http.HttpServlet.service(HttpServlet.java:647)

atjavax.servlet.http.HttpServlet.service(HttpServlet.java:728)

atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

atorg.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

atorg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

atorg.springframework.security.web.authentication.switchuser.SwitchUserFilter.doFilter(SwitchUserFilter.java:181)

atcom.hotent.core.web.filter.HtSwitchUserFilter.doFilter(HtSwitchUserFilter.java:41)