Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BINARY...

约定不等于承诺〃 2023-06-01 03:19 5阅读 0赞

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)  
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)  
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)  
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)  
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)  
at com.sun.proxy.$Proxy130.getList(Unknown Source)  
at com.jeecms.cms.api.admin.main.CmsModelItemApiAct.update(CmsModelItemApiAct.java:137)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:606)  
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)  
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)  
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)  
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)  
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)  
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)  
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)  
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)  
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)  
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)  
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)  
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)  
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)  
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)  
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)  
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)  
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)  
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)  
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)  
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)  
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)  
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)  
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)  
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)  
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)  
at java.lang.Thread.run(Thread.java:745)  
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BINARY

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)  
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)  
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)  
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)  
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)  
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)  
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)  
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)  
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)  
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)  
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)  
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)  
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)  
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353)  
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)  
... 82 more  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:net.sf.ehcache.store.disk.Segment Method: net.sf.ehcache.store.disk.Segment.put(Segment.java:453) \]  
DEBUG:put updated, deleted 0 on heap  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:net.sf.ehcache.store.disk.Segment Method: net.sf.ehcache.store.disk.Segment.put(Segment.java:457) \]  
DEBUG:put updated, deleted 0 on disk  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.cache.spi.UpdateTimestampsCache Method: org.hibernate.cache.spi.UpdateTimestampsCache.invalidate(UpdateTimestampsCache.java:139) \]  
DEBUG:Invalidating space \[jc\_api\_user\_login\], timestamp: 6406583440146432  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.cache.ehcache.internal.regions.EhcacheGeneralDataRegion Method: org.hibernate.cache.ehcache.internal.regions.EhcacheGeneralDataRegion.put(EhcacheGeneralDataRegion.java:103) \]  
DEBUG:key: jc\_api\_user\_login value: 6406583440146432  
2019-07-26 10:14:45 上午 \[Thread: http-8080-8\]\[ Class:com.jeecms.common.web.springmvc.HandlerApiExceptionResolver Method: com.jeecms.common.web.springmvc.HandlerApiExceptionResolver.resolveException(HandlerApiExceptionResolver.java:51) \]  
ERROR:msg->could not extract ResultSet  
2019-07-26 10:14:45 上午 \[Thread: com%002ejeecms%002ecms%002eentity%002emain%002e%0041pi%0055ser%004cogin.data\]\[ Class:net.sf.ehcache.store.disk.Segment Method: net.sf.ehcache.store.disk.Segment.fault(Segment.java:779) \]  
DEBUG:fault removed 0 from heap  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:net.sf.ehcache.store.disk.Segment Method: net.sf.ehcache.store.disk.Segment.put(Segment.java:425) \]  
DEBUG:put added 0 on heap  
2019-07-26 10:14:45 上午 \[Thread: com%002ejeecms%002ecms%002eentity%002emain%002e%0041pi%0055ser%004cogin.data\]\[ Class:net.sf.ehcache.store.disk.Segment Method: net.sf.ehcache.store.disk.Segment.fault(Segment.java:796) \]  
DEBUG:fault added 0 on disk  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:net.sf.ehcache.store.disk.Segment Method: net.sf.ehcache.store.disk.Segment.put(Segment.java:453) \]  
DEBUG:put updated, deleted 0 on heap  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:net.sf.ehcache.store.disk.Segment Method: net.sf.ehcache.store.disk.Segment.put(Segment.java:457) \]  
DEBUG:put updated, deleted 0 on disk  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.internal.SessionImpl Method: org.hibernate.internal.SessionImpl.disconnect(SessionImpl.java:468) \]  
DEBUG:Disconnecting session  
2019-07-26 10:14:45 上午 \[Thread: org%002ehibernate%002ecache%002espi%002e%0055pdate%0054imestamps%0043ache.data\]\[ Class:net.sf.ehcache.store.disk.Segment Method: net.sf.ehcache.store.disk.Segment.fault(Segment.java:779) \]  
DEBUG:fault removed 0 from heap  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.engine.jdbc.internal.LogicalConnectionImpl Method: org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:246) \]  
DEBUG:Releasing JDBC connection  
2019-07-26 10:14:45 上午 \[Thread: org%002ehibernate%002ecache%002espi%002e%0055pdate%0054imestamps%0043ache.data\]\[ Class:net.sf.ehcache.store.disk.Segment Method: net.sf.ehcache.store.disk.Segment.fault(Segment.java:796) \]  
DEBUG:fault added 0 on disk  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.engine.jdbc.internal.LogicalConnectionImpl Method: org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:264) \]  
DEBUG:Released JDBC connection  
org.hibernate.exception.SQLGrammarException: could not extract ResultSet  
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)  
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)  
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)  
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)  
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)  
at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)  
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)  
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)  
at org.hibernate.loader.Loader.doQuery(Loader.java:910)  
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)  
at org.hibernate.loader.Loader.doList(Loader.java:2554)  
at org.hibernate.loader.Loader.doList(Loader.java:2540)  
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)  
at org.hibernate.loader.Loader.list(Loader.java:2365)  
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)  
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)  
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)  
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)  
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)  
at com.jeecms.common.hibernate4.HibernateSimpleDao.find(HibernateSimpleDao.java:70)  
at com.jeecms.cms.dao.main.impl.CmsModelItemDaoImpl.getList(CmsModelItemDaoImpl.java:27)  
at com.jeecms.cms.manager.main.impl.CmsModelItemMngImpl.getList(CmsModelItemMngImpl.java:21)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:606)  
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)  
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)  
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)  
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)  
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)  
at com.sun.proxy.$Proxy130.getList(Unknown Source)  
at com.jeecms.cms.api.admin.main.CmsModelItemApiAct.update(CmsModelItemApiAct.java:137)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:606)  
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)  
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)  
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)  
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)  
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)  
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)  
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)  
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)  
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)  
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)  
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)  
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)  
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)  
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)  
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)  
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)  
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)  
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)  
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)  
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)  
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)  
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)  
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)  
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)  
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)  
at java.lang.Thread.run(Thread.java:745)  
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BINARY

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)  
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)  
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)  
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)  
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)  
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)  
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)  
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)  
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)  
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)  
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)  
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)  
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)  
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353)  
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)  
at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)  
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)  
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)  
at org.hibernate.loader.Loader.doQuery(Loader.java:910)  
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)  
at org.hibernate.loader.Loader.doList(Loader.java:2554)  
at org.hibernate.loader.Loader.doList(Loader.java:2540)  
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)  
at org.hibernate.loader.Loader.list(Loader.java:2365)  
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)  
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)  
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)  
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)  
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)  
at com.jeecms.common.hibernate4.HibernateSimpleDao.find(HibernateSimpleDao.java:70)  
at com.jeecms.cms.dao.main.impl.CmsModelItemDaoImpl.getList(CmsModelItemDaoImpl.java:27)  
at com.jeecms.cms.manager.main.impl.CmsModelItemMngImpl.getList(CmsModelItemMngImpl.java:21)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:606)  
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)  
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)  
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)  
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)  
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)  
at com.sun.proxy.$Proxy130.getList(Unknown Source)  
at com.jeecms.cms.api.admin.main.CmsModelItemApiAct.update(CmsModelItemApiAct.java:137)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:606)  
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)  
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)  
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)  
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)  
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)  
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)  
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)  
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)  
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)  
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)  
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)  
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)  
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)  
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)  
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)  
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)  
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)  
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)  
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)  
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)  
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)  
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)  
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)  
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)  
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)  
at java.lang.Thread.run(Thread.java:745)  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.engine.jdbc.spi.SqlExceptionHelper Method: org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions(SqlExceptionHelper.java:144) \]  
WARN:SQL Error: 932, SQLState: 42000  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.engine.jdbc.spi.SqlExceptionHelper Method: org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions(SqlExceptionHelper.java:146) \]  
ERROR:ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BINARY

2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.engine.transaction.spi.AbstractTransactionImpl Method: org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:205) \]  
DEBUG:rolling back  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction Method: org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:164) \]  
DEBUG:rolled JDBC Connection  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction Method: org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.releaseManagedConnection(JdbcTransaction.java:126) \]  
DEBUG:re-enabling autocommit  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.internal.SessionImpl Method: org.hibernate.internal.SessionImpl.disconnect(SessionImpl.java:468) \]  
DEBUG:Disconnecting session  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.engine.jdbc.internal.LogicalConnectionImpl Method: org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:246) \]  
DEBUG:Releasing JDBC connection  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.engine.jdbc.internal.LogicalConnectionImpl Method: org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:264) \]  
DEBUG:Released JDBC connection  
org.hibernate.exception.SQLGrammarException: could not extract ResultSet  
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)  
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)  
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)  
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)  
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)  
at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)  
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)  
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)  
at org.hibernate.loader.Loader.doQuery(Loader.java:910)  
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)  
at org.hibernate.loader.Loader.doList(Loader.java:2554)  
at org.hibernate.loader.Loader.doList(Loader.java:2540)  
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)  
at org.hibernate.loader.Loader.list(Loader.java:2365)  
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)  
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)  
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)  
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)  
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)  
at com.jeecms.common.hibernate4.HibernateSimpleDao.find(HibernateSimpleDao.java:70)  
at com.jeecms.cms.dao.main.impl.CmsModelItemDaoImpl.getList(CmsModelItemDaoImpl.java:27)  
at com.jeecms.cms.manager.main.impl.CmsModelItemMngImpl.getList(CmsModelItemMngImpl.java:21)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:606)  
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)  
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)  
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)  
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)  
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)  
at com.sun.proxy.$Proxy130.getList(Unknown Source)  
at com.jeecms.cms.api.admin.main.CmsModelItemApiAct.update(CmsModelItemApiAct.java:137)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:606)  
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)  
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)  
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)  
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)  
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)  
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)  
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)  
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)  
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)  
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)  
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)  
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)  
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)  
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)  
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)  
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)  
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)  
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)  
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)  
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)  
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)  
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)  
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)  
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)  
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)  
at java.lang.Thread.run(Thread.java:745)  
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BINARY

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)  
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)  
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)  
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)  
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)  
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)  
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)  
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)  
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)  
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)  
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)  
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)  
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)  
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353)  
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)  
... 82 more  
2019-07-26 10:14:45 上午 \[Thread: http-8080-1\]\[ Class:com.jeecms.common.web.springmvc.HandlerApiExceptionResolver Method: com.jeecms.common.web.springmvc.HandlerApiExceptionResolver.resolveException(HandlerApiExceptionResolver.java:51) \]  
ERROR:msg->could not extract ResultSet  
org.hibernate.exception.SQLGrammarException: could not extract ResultSet  
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)  
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)  
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)  
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)  
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)  
at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)  
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)  
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)  
at org.hibernate.loader.Loader.doQuery(Loader.java:910)  
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)  
at org.hibernate.loader.Loader.doList(Loader.java:2554)  
at org.hibernate.loader.Loader.doList(Loader.java:2540)  
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)  
at org.hibernate.loader.Loader.list(Loader.java:2365)  
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)  
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)  
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)  
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)  
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)  
at com.jeecms.common.hibernate4.HibernateSimpleDao.find(HibernateSimpleDao.java:70)  
at com.jeecms.cms.dao.main.impl.CmsModelItemDaoImpl.getList(CmsModelItemDaoImpl.java:27)  
at com.jeecms.cms.manager.main.impl.CmsModelItemMngImpl.getList(CmsModelItemMngImpl.java:21)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:606)  
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)  
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)  
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)  
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)  
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)  
at com.sun.proxy.$Proxy130.getList(Unknown Source)  
at com.jeecms.cms.api.admin.main.CmsModelItemApiAct.update(CmsModelItemApiAct.java:137)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:606)  
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)  
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)  
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)  
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)  
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)  
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)  
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)  
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)  
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)  
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)  
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)  
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)  
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)  
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)  
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)  
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)  
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)  
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)  
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)  
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)  
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)  
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)  
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)  
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)  
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)  
at java.lang.Thread.run(Thread.java:745)  
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BINARY

Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BINARY

DEBUG:Invalidating space \[jc\_api\_user\_login\], timestamp: 6406583440146432

2019-07-26 10:16:41 上午 \[Thread: http-8080-8\]\[ Class:org.hibernate.engine.internal.Collections Method: org.hibernate.engine.internal.Collections.processReachableCollection(Collections.java:201) \]  
DEBUG:Collection found: \[com.jeecms.core.entity.CmsUser.eventUsers\#1\], was: \[com.jeecms.core.entity.CmsUser.eventUsers\#1\] (uninitialized)  
2019-07-26 10:16:41 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.engine.jdbc.spi.SqlExceptionHelper Method: org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions(SqlExceptionHelper.java:144) \]  
WARN:SQL Error: 932, SQLState: 42000  
2019-07-26 10:16:41 上午 \[Thread: http-8080-8\]\[ Class:org.hibernate.engine.internal.Collections Method: org.hibernate.engine.internal.Collections.processReachableCollection(Collections.java:201) \]  
DEBUG:Collection found: \[com.jeecms.core.entity.CmsUser.thirdAccounts\#1\], was: \[com.jeecms.core.entity.CmsUser.thirdAccounts\#1\] (uninitialized)  
2019-07-26 10:16:41 上午 \[Thread: http-8080-1\]\[ Class:org.hibernate.engine.jdbc.spi.SqlExceptionHelper Method: org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions(SqlExceptionHelper.java:146) \]  
ERROR:ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BINARY

2019-07-26 10:16:41 上午 \[Thread: http-8080-8\]\[ Class:org.hibernate.SQL Method: org.hibernate.engine.jdbc.spi.SqlStatementLogger.logStatement(SqlStatementLogger.java:109) \]  
DEBUG:select cmsmodelit0\_.modelitem\_id as modelitem\_id1\_72\_, cmsmodelit0\_.field as field2\_72\_, cmsmodelit0\_.item\_label as item\_label3\_72\_, cmsmodelit0\_.priority as priority4\_72\_, cmsmodelit0\_.def\_value as def\_value5\_72\_, cmsmodelit0\_.opt\_value as opt\_value6\_72\_, cmsmodelit0\_.text\_size as text\_size7\_72\_, cmsmodelit0\_.area\_rows as area\_rows8\_72\_, cmsmodelit0\_.area\_cols as area\_cols9\_72\_, cmsmodelit0\_.help as help10\_72\_, cmsmodelit0\_.help\_position as help\_position11\_72\_, cmsmodelit0\_.data\_type as data\_type12\_72\_, cmsmodelit0\_.is\_single as is\_single13\_72\_, cmsmodelit0\_.is\_channel as is\_channel14\_72\_, cmsmodelit0\_.is\_custom as is\_custom15\_72\_, cmsmodelit0\_.is\_display as is\_display16\_72\_, cmsmodelit0\_.is\_required as is\_required17\_72\_, cmsmodelit0\_.image\_width as image\_width18\_72\_, cmsmodelit0\_.image\_height as image\_height19\_72\_, cmsmodelit0\_.model\_id as model\_id20\_72\_ from jc\_model\_item cmsmodelit0\_ where cmsmodelit0\_.model\_id=? and cmsmodelit0\_.is\_channel=? order by cmsmodelit0\_.priority asc, cmsmodelit0\_.modelitem\_id asc  
2019-07-26 10:16:41 上午 \[Thread: http-8080-8\]\[ Class:com.mchange.v2.c3p0.impl.NewPooledConnection Method: com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$DebugLogger.log(Slf4jMLog.java:207) \]  
DEBUG:com.mchange.v2.c3p0.impl.NewPooledConnection@158ae04 handling a throwable.  
java.sql.SQLSyntaxErrorException: ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BINARY

http://localhost:8080/jeecmsv9/jeeadmin/jeecms/index.do\#  
/contentModel/update?type=update  
&id=32  
&noce\_str=FZPUT6N&  
modelId=1&  
isChannel=false&  
modelName=%E6%96%B0%E9%97%BB

http://localhost:8080/jeecmsv9/api/admin/item/update

http://localhost:8080/jeecmsv9/jeeadmin/jeecms/index.do\#  
/channelModel/list?type=list  
&id=0  
&noce\_str=AZYEFED&  
modelId=1  
&isChannel=true  
&modelName=%E6%96%B0%E9%97%BB

后台传参错误，加上参数解决！

转载于:https://www.cnblogs.com/Jeely/p/11250372.html