20:14:52.792 http-nio-8080-exec-2467 com.lcnetwork.web.WJUserController 保存错误---!Nutz SQL Error: 'UPDATE T_MAIN_PRTY_INDIVIDUAL SET CREDENTIALS_TYPE=?,ID_CARD=?,NAME=?,SEX_CD=?,QQ=?,WECHAT=?,LIVE_WITH=?,FAMILY_TOTAL_VAL=?,HOUSE_TYP=?,LIVING_DT=?,SOCIAL_CARD_NUM=?,EXP_DESC=?,BIRTH=?,MARRY_CD=?,DEGREE_CD=?,NATIONALITY_CD=?,REGIONS_CD=?,PROVINCES_CD=?,REGISTRY_PRVC_CD=?,REGISTRY_CITY_CD=?,REGISTRY_ADDR=?,ADDR=?,TEL=?,HOME_TEL=?,EMPLOY_ORG=?,POSITION_CD=?,EMPLOY_ORG_ADDR=?,EMPLOY_ORG_TEL=?,E_MAIL=?,CREATEUID=?,CREATTIME=?,UPDATEUID=?,UPDATETIME=?,RFLAG=?,REMARK1=?,REMARK2=?,REMARK3=?,REMARK4=?,HEALTH_CD=?,LOCAL_LIVING_YEAES_CD=?,WIFE_CHILD_SEAT_CD=?,AGE=?,REGISTRY_FORM=?,CARD_NUM=?,RENTAL_TIME=?,LIVE_WITH_REMARK1=?,LIVE_WITH_REMARK2=?,MONTH_INCOM=?,CHILD_IN_SCHOOL_CD=?,IS_KNOW_LOAN=?,IS_COMMON_BORROW=?,OWNERUID=?,LOAD_STATUS=?,SZ_LIVE=?,DOC_ID=?,ESTATE_NUM=?,VEHICLE_NUM=?,MARKET_VALUE=?,CUST_CODE=?,CUST_CLASSIFY=?,EDUCATION=?,GPS_CITY_CD=?,GPS_AREA_NAME=?,GPS_ADDR=?,IS_COMPLETE=?,BANK_IS_COMPLETE=?,CONTACT_IS_COMPLETE=?,JOB_IS_COMPLETE=?,P_INFO_IS_COMPLETE=?,CREDIT_IS_COMPLETE=?,PHONE_IS_COMPLETE=? WHERE INDIVIDUAL_PARTY_ID=?
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 |
|------|--------------------|-----|------|-----------|----------|------|------|------|------|------|------|------|------|------|------|------|------|------|------|--------------|------|-------------|------|------|------|------|------|----------------|------|---------------------|------|------|---|-------------|------|------|------|------|------|------|------|------|------|------|------|------|------|------|------|------|------|------|------|------|------|------|------|------|-----|--------|--|---------|-----------------------|--|---|---|---|---|--|--|---------------------|
| NULL | 511023198806171418 | 刘红兵 | NULL | 328476443 | liuhb598 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 林芝巴宜区苹果园E11号 | NULL | 18081103178 | NULL | NULL | NULL | NULL | NULL | 328476443qqcom | 2549 | 2017-06-08 20:08:59 | NULL | NULL | 1 | 18081103178 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | C01 | 高中职高技校 | | 林芝地区林芝县 | 中国西藏自治区林芝地区林芝县G318沪聂线 | | 1 | 1 | 1 | 1 | | | P170608200859081822 |
For example:> "UPDATE T_MAIN_PRTY_INDIVIDUAL SET CREDENTIALS_TYPE=NULL,ID_CARD='511023198806171418',NAME='刘红兵',SEX_CD=NULL,QQ='328476443',WECHAT='liuhb598',LIVE_WITH=NULL,FAMILY_TOTAL_VAL=NULL,HOUSE_TYP=NULL,LIVING_DT=NULL,SOCIAL_CARD_NUM=NULL,EXP_DESC=NULL,BIRTH=NULL,MARRY_CD=NULL,DEGREE_CD=NULL,NATIONALITY_CD=NULL,REGIONS_CD=NULL,PROVINCES_CD=NULL,REGISTRY_PRVC_CD=NULL,REGISTRY_CITY_CD=NULL,REGISTRY_ADDR='林芝巴宜区苹果园E11号',ADDR=NULL,TEL='18081103178',HOME_TEL=NULL,EMPLOY_ORG=NULL,POSITION_CD=NULL,EMPLOY_ORG_ADDR=NULL,EMPLOY_ORG_TEL=NULL,E_MAIL='328476443qqcom',CREATEUID='2549',CREATTIME='2017-06-08 20:08:59',UPDATEUID=NULL,UPDATETIME=NULL,RFLAG=1,REMARK1='18081103178',REMARK2=NULL,REMARK3=NULL,REMARK4=NULL,HEALTH_CD=NULL,LOCAL_LIVING_YEAES_CD=NULL,WIFE_CHILD_SEAT_CD=NULL,AGE=NULL,REGISTRY_FORM=NULL,CARD_NUM=NULL,RENTAL_TIME=NULL,LIVE_WITH_REMARK1=NULL,LIVE_WITH_REMARK2=NULL,MONTH_INCOM=NULL,CHILD_IN_SCHOOL_CD=NULL,IS_KNOW_LOAN=NULL,IS_COMMON_BORROW=NULL,OWNERUID=NULL,LOAD_STATUS=NULL,SZ_LIVE=NULL,DOC_ID=NULL,ESTATE_NUM=NULL,VEHICLE_NUM=NULL,MARKET_VALUE=NULL,CUST_CODE=NULL,CUST_CLASSIFY='C01',EDUCATION='高中职高技校',GPS_CITY_CD='',GPS_AREA_NAME='林芝地区林芝县',GPS_ADDR='中国西藏自治区林芝地区林芝县G318沪聂线',IS_COMPLETE='',BANK_IS_COMPLETE='1',CONTACT_IS_COMPLETE='1',JOB_IS_COMPLETE='1',P_INFO_IS_COMPLETE='1',CREDIT_IS_COMPLETE='',PHONE_IS_COMPLETE='' WHERE INDIVIDUAL_PARTY_ID='P170608200859081822'"'
PreparedStatement:
'UPDATE T_MAIN_PRTY_INDIVIDUAL SET CREDENTIALS_TYPE=?,ID_CARD=?,NAME=?,SEX_CD=?,QQ=?,WECHAT=?,LIVE_WITH=?,FAMILY_TOTAL_VAL=?,HOUSE_TYP=?,LIVING_DT=?,SOCIAL_CARD_NUM=?,EXP_DESC=?,BIRTH=?,MARRY_CD=?,DEGREE_CD=?,NATIONALITY_CD=?,REGIONS_CD=?,PROVINCES_CD=?,REGISTRY_PRVC_CD=?,REGISTRY_CITY_CD=?,REGISTRY_ADDR=?,ADDR=?,TEL=?,HOME_TEL=?,EMPLOY_ORG=?,POSITION_CD=?,EMPLOY_ORG_ADDR=?,EMPLOY_ORG_TEL=?,E_MAIL=?,CREATEUID=?,CREATTIME=?,UPDATEUID=?,UPDATETIME=?,RFLAG=?,REMARK1=?,REMARK2=?,REMARK3=?,REMARK4=?,HEALTH_CD=?,LOCAL_LIVING_YEAES_CD=?,WIFE_CHILD_SEAT_CD=?,AGE=?,REGISTRY_FORM=?,CARD_NUM=?,RENTAL_TIME=?,LIVE_WITH_REMARK1=?,LIVE_WITH_REMARK2=?,MONTH_INCOM=?,CHILD_IN_SCHOOL_CD=?,IS_KNOW_LOAN=?,IS_COMMON_BORROW=?,OWNERUID=?,LOAD_STATUS=?,SZ_LIVE=?,DOC_ID=?,ESTATE_NUM=?,VEHICLE_NUM=?,MARKET_VALUE=?,CUST_CODE=?,CUST_CLASSIFY=?,EDUCATION=?,GPS_CITY_CD=?,GPS_AREA_NAME=?,GPS_ADDR=?,IS_COMPLETE=?,BANK_IS_COMPLETE=?,CONTACT_IS_COMPLETE=?,JOB_IS_COMPLETE=?,P_INFO_IS_COMPLETE=?,CREDIT_IS_COMPLETE=?,PHONE_IS_COMPLETE=? WHERE INDIVIDUAL_PARTY_ID=?'
@wendal
org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:86)
org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:242)
com.lcnetwork.nakri.db.SpringDaoRunner.run(SpringDaoRunner.java:18)
org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:197)
org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
org.nutz.dao.impl.NutDao.update(NutDao.java:193)
com.lcnetwork.nakri.db.dao.impl.TMainPrtyIndividualDaoImpl.updateTMainPrtyIndividual(TMainPrtyIndividualDaoImpl.java:80)
com.lcnetwork.service.impl.UserServiceImpl.saveOrupdatePInfo(UserServiceImpl.java:2414)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:497)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
com.sun.proxy.$Proxy443.saveOrupdatePInfo(Unknown Source)
com.lcnetwork.web.WJUserController.wjSavePInfo(WJUserController.java:666)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:497)
org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1441)
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:745)