- 浏览: 24227 次
- 性别:
- 来自: 沈阳
文章分类
- 全部博客 (21)
- Android (1)
- Websphere (1)
- DB2 (1)
- j2SE (1)
- weblogic (2)
- J2EE (1)
- Oracle (2)
- oracle 导入导出 (1)
- oracle 查询技巧 (1)
- jquery ajax 跨域 (1)
- 读后感 (1)
- Hibernate 遇到一对多关系映射 (0)
- 遇到的问题 (0)
- Hibernate (3)
- 买电脑被骗大家引以为鉴 (0)
- oracle 三层分页原理 (1)
- 数据库 (1)
- IBM 的东西好难找 (1)
- Linux 性能调优 (1)
- Linux java 系统问题排查 (1)
- Linux (1)
- java (1)
- Spring quartz (1)
最新评论
DB2 Hibernate 查询 SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null
- 博客分类:
- DB2
环境是 tomcat+DB2 9.5
首先在网上查找了一下 SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null 状态码,没有很好的提示。
然后根据报错的类,反编译了代码来看,后来发现 at org.hibernate.engine.query.HQLQueryPlan.performList HQL 解析成为 SQL时出错了(其实仔细看上面能够看得出)
这个HQL 转义成SQL 时出问题了。
SELECT new map(f.pin,f.pushCode) FROM com.techown.proxy.entity.Flow as f WHERE (f.createTime between ? AND ? ) AND (f.status=? OR f.status=?) AND (lower(f.osType)=lower(?) AND (f.pushTime <=:date))
仔细检查发现lower(f.osType)=lower(?) 有问题,因此修改为lower(f.osType)=?
问题解决
10:21:44.083 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] DEBUG o.h.hql.ast.util.JoinProcessor - Using FROM fragment [flow flow0_] 10:21:44.083 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] DEBUG o.h.hql.antlr.HqlSqlBaseWalker - select >> end [level=1, statement=select] 10:21:44.083 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] DEBUG org.hibernate.hql.ast.AST - --- SQL AST --- \-[SELECT] QueryNode: 'SELECT' querySpaces (flow) +-[SELECT_CLAUSE] SelectClause: '{select clause}' | \-[CONSTRUCTOR] ConstructorNode: '(' | +-[IDENT] IdentNode: 'map' {originalText=map} | +-[DOT] DotNode: 'flow0_.pin' {propertyName=pin,dereferenceType=4,propertyPath=pin,path=f.pin,tableAlias=flow0_,className=com.techown.proxy.entity.Flow,classAlias=f} | | +-[ALIAS_REF] IdentNode: 'flow0_.flowId' {alias=f, className=com.techown.proxy.entity.Flow, tableAlias=flow0_} | | \-[IDENT] IdentNode: 'pin' {originalText=pin} | +-[SELECT_COLUMNS] SqlNode: ' as col_0_0_' | +-[DOT] DotNode: 'flow0_.pushCode' {propertyName=pushCode,dereferenceType=4,propertyPath=pushCode,path=f.pushCode,tableAlias=flow0_,className=com.techown.proxy.entity.Flow,classAlias=f} | | +-[ALIAS_REF] IdentNode: 'flow0_.flowId' {alias=f, className=com.techown.proxy.entity.Flow, tableAlias=flow0_} | | \-[IDENT] IdentNode: 'pushCode' {originalText=pushCode} | \-[SELECT_COLUMNS] SqlNode: ' as col_1_0_' +-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[f], fromElementByTableAlias=[flow0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]} | \-[FROM_FRAGMENT] FromElement: 'flow flow0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=f,role=null,tableName=flow,tableAlias=flow0_,origin=null,colums={,className=com.techown.proxy.entity.Flow}} \-[WHERE] SqlNode: 'WHERE' \-[AND] SqlNode: 'AND' +-[AND] SqlNode: 'AND' | +-[BETWEEN] BetweenOperatorNode: 'between' | | +-[DOT] DotNode: 'flow0_.createTime' {propertyName=createTime,dereferenceType=4,propertyPath=createTime,path=f.createTime,tableAlias=flow0_,className=com.techown.proxy.entity.Flow,classAlias=f} | | | +-[ALIAS_REF] IdentNode: 'flow0_.flowId' {alias=f, className=com.techown.proxy.entity.Flow, tableAlias=flow0_} | | | \-[IDENT] IdentNode: 'createTime' {originalText=createTime} | | +-[PARAM] ParameterNode: '?' {ordinal=0, expectedType=org.hibernate.type.TimestampType@e890d3} | | \-[PARAM] ParameterNode: '?' {ordinal=1, expectedType=org.hibernate.type.TimestampType@e890d3} | \-[OR] SqlNode: 'OR' | +-[EQ] BinaryLogicOperatorNode: '=' | | +-[DOT] DotNode: 'flow0_.status' {propertyName=status,dereferenceType=4,propertyPath=status,path=f.status,tableAlias=flow0_,className=com.techown.proxy.entity.Flow,classAlias=f} | | | +-[ALIAS_REF] IdentNode: 'flow0_.flowId' {alias=f, className=com.techown.proxy.entity.Flow, tableAlias=flow0_} | | | \-[IDENT] IdentNode: 'status' {originalText=status} | | \-[PARAM] ParameterNode: '?' {ordinal=2, expectedType=org.hibernate.type.IntegerType@1c22e0} | \-[EQ] BinaryLogicOperatorNode: '=' | +-[DOT] DotNode: 'flow0_.status' {propertyName=status,dereferenceType=4,propertyPath=status,path=f.status,tableAlias=flow0_,className=com.techown.proxy.entity.Flow,classAlias=f} | | +-[ALIAS_REF] IdentNode: 'flow0_.flowId' {alias=f, className=com.techown.proxy.entity.Flow, tableAlias=flow0_} | | \-[IDENT] IdentNode: 'status' {originalText=status} | \-[PARAM] ParameterNode: '?' {ordinal=3, expectedType=org.hibernate.type.IntegerType@1c22e0} \-[AND] SqlNode: 'AND' +-[EQ] BinaryLogicOperatorNode: '=' | +-[METHOD_CALL] MethodNode: '(' | | +-[METHOD_NAME] IdentNode: 'lower' {originalText=lower} | | \-[EXPR_LIST] SqlNode: 'exprList' | | \-[DOT] DotNode: 'flow0_.osType' {propertyName=osType,dereferenceType=4,propertyPath=osType,path=f.osType,tableAlias=flow0_,className=com.techown.proxy.entity.Flow,classAlias=f} | | +-[ALIAS_REF] IdentNode: 'flow0_.flowId' {alias=f, className=com.techown.proxy.entity.Flow, tableAlias=flow0_} | | \-[IDENT] IdentNode: 'osType' {originalText=osType} | \-[METHOD_CALL] MethodNode: '(' | +-[METHOD_NAME] IdentNode: 'lower' {originalText=lower} | \-[EXPR_LIST] SqlNode: 'exprList' | \-[PARAM] ParameterNode: '?' {ordinal=4, expectedType=null} \-[LE] BinaryLogicOperatorNode: '<=' +-[DOT] DotNode: 'flow0_.pushTime' {propertyName=pushTime,dereferenceType=4,propertyPath=pushTime,path=f.pushTime,tableAlias=flow0_,className=com.techown.proxy.entity.Flow,classAlias=f} | +-[ALIAS_REF] IdentNode: 'flow0_.flowId' {alias=f, className=com.techown.proxy.entity.Flow, tableAlias=flow0_} | \-[IDENT] IdentNode: 'pushTime' {originalText=pushTime} \-[NAMED_PARAM] ParameterNode: '?' {name=date, expectedType=org.hibernate.type.TimestampType@e890d3} 10:21:44.083 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors 10:21:44.084 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] DEBUG o.h.hql.ast.QueryTranslatorImpl - HQL: SELECT new map(f.pin,f.pushCode) FROM com.techown.proxy.entity.Flow as f WHERE (f.createTime between ? AND ? ) AND (f.status=? OR f.status=?) AND (lower(f.osType)=lower(?) AND (f.pushTime <=:date)) 10:21:44.084 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] DEBUG o.h.hql.ast.QueryTranslatorImpl - SQL: select flow0_.pin as col_0_0_, flow0_.pushCode as col_1_0_ from flow flow0_ where (flow0_.createTime between ? and ?) and (flow0_.status=? or flow0_.status=?) and lower(flow0_.osType)=lower(?) and flow0_.pushTime<=? 10:21:44.084 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors [2014-06-04 10:21:44.084][DEBUG][org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@197593b] for key [org.hibernate.impl.SessionFactoryImpl@229bb] bound to thread [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] 10:21:44.084 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 10:21:44.084 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] DEBUG org.hibernate.SQL - select flow0_.pin as col_0_0_, flow0_.pushCode as col_1_0_ from flow flow0_ where (flow0_.createTime between ? and ?) and (flow0_.status=? or flow0_.status=?) and lower(flow0_.osType)=lower(?) and flow0_.pushTime<=? [2014-06-04 10:21:44.131][DEBUG][org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] - com.mchange.v2.c3p0.impl.NewPooledConnection@6470a6 handling a throwable. com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null at com.ibm.db2.jcc.b.hh.c(hh.java:1662) at com.ibm.db2.jcc.b.hh.d(hh.java:1650) at com.ibm.db2.jcc.b.hh.a(hh.java:1219) at com.ibm.db2.jcc.c.db.g(db.java:139) at com.ibm.db2.jcc.c.db.a(db.java:39) at com.ibm.db2.jcc.c.t.a(t.java:34) at com.ibm.db2.jcc.c.sb.f(sb.java:142) at com.ibm.db2.jcc.b.hh.n(hh.java:1190) at com.ibm.db2.jcc.b.ih.eb(ih.java:1997) at com.ibm.db2.jcc.b.ih.d(ih.java:2439) at com.ibm.db2.jcc.b.ih.V(ih.java:492) at com.ibm.db2.jcc.b.ih.executeQuery(ih.java:475) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1808) at org.hibernate.loader.Loader.doQuery(Loader.java:697) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2228) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125) at org.hibernate.loader.Loader.list(Loader.java:2120) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at com.techown.proxy.dao.PushDaoImpl$3.doInHibernate(PushDaoImpl.java:117) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339) at com.techown.proxy.dao.PushDaoImpl.queryAndroidPushByTime(PushDaoImpl.java:101) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy4.queryAndroidPushByTime(Unknown Source) at com.techown.server.dao.DataManagerImpl.getPushListForPush(DataManagerImpl.java:201) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy19.getPushListForPush(Unknown Source) at com.techown.server.scheduler.service.secondary.CommandPushPorcess.doProcess(CommandPushPorcess.java:24) at com.techown.server.scheduler.service.secondary.ResultHandlerContext.doProcess(ResultHandlerContext.java:45) at com.techown.server.scheduler.service.secondary.ResultHandlerContext$$FastClassByCGLIB$$7baefe8.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635) at com.techown.server.scheduler.service.secondary.ResultHandlerContext$$EnhancerByCGLIB$$40f3b5f9.doProcess(<generated>) at com.techown.server.scheduler.service.CommandProcessServiceImpl.doPush(CommandProcessServiceImpl.java:46) at com.techown.server.scheduler.service.CommandProcessServiceImpl.commandProcess(CommandProcessServiceImpl.java:35) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy30.commandProcess(Unknown Source) at com.techown.server.scheduler.CommmandHandleJob.executeInternal(CommmandHandleJob.java:41) at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529) [2014-06-04 10:21:44.131][DEBUG][org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1] - Attempted to convert SQLException to SQLException. Leaving it alone. [SQLState: 42610; errorCode: -418] com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null at com.ibm.db2.jcc.b.hh.c(hh.java:1662) at com.ibm.db2.jcc.b.hh.d(hh.java:1650) at com.ibm.db2.jcc.b.hh.a(hh.java:1219) at com.ibm.db2.jcc.c.db.g(db.java:139) at com.ibm.db2.jcc.c.db.a(db.java:39) at com.ibm.db2.jcc.c.t.a(t.java:34) at com.ibm.db2.jcc.c.sb.f(sb.java:142) at com.ibm.db2.jcc.b.hh.n(hh.java:1190) at com.ibm.db2.jcc.b.ih.eb(ih.java:1997) at com.ibm.db2.jcc.b.ih.d(ih.java:2439) at com.ibm.db2.jcc.b.ih.V(ih.java:492) at com.ibm.db2.jcc.b.ih.executeQuery(ih.java:475) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1808) at org.hibernate.loader.Loader.doQuery(Loader.java:697) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2228) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125) at org.hibernate.loader.Loader.list(Loader.java:2120) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at com.techown.proxy.dao.PushDaoImpl$3.doInHibernate(PushDaoImpl.java:117) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339) at com.techown.proxy.dao.PushDaoImpl.queryAndroidPushByTime(PushDaoImpl.java:101) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy4.queryAndroidPushByTime(Unknown Source) at com.techown.server.dao.DataManagerImpl.getPushListForPush(DataManagerImpl.java:201) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy19.getPushListForPush(Unknown Source) at com.techown.server.scheduler.service.secondary.CommandPushPorcess.doProcess(CommandPushPorcess.java:24) at com.techown.server.scheduler.service.secondary.ResultHandlerContext.doProcess(ResultHandlerContext.java:45) at com.techown.server.scheduler.service.secondary.ResultHandlerContext$$FastClassByCGLIB$$7baefe8.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635) at com.techown.server.scheduler.service.secondary.ResultHandlerContext$$EnhancerByCGLIB$$40f3b5f9.doProcess(<generated>) at com.techown.server.scheduler.service.CommandProcessServiceImpl.doPush(CommandProcessServiceImpl.java:46) at com.techown.server.scheduler.service.CommandProcessServiceImpl.commandProcess(CommandProcessServiceImpl.java:35) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy30.commandProcess(Unknown Source) at com.techown.server.scheduler.CommmandHandleJob.executeInternal(CommmandHandleJob.java:41) at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
首先在网上查找了一下 SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null 状态码,没有很好的提示。
然后根据报错的类,反编译了代码来看,后来发现 at org.hibernate.engine.query.HQLQueryPlan.performList HQL 解析成为 SQL时出错了(其实仔细看上面能够看得出)
这个HQL 转义成SQL 时出问题了。
SELECT new map(f.pin,f.pushCode) FROM com.techown.proxy.entity.Flow as f WHERE (f.createTime between ? AND ? ) AND (f.status=? OR f.status=?) AND (lower(f.osType)=lower(?) AND (f.pushTime <=:date))
仔细检查发现lower(f.osType)=lower(?) 有问题,因此修改为lower(f.osType)=?
问题解决
相关推荐
db2 sqlstate 57016,db2 57016 原因码7错误怎么解决呢?下面小编给大家带来了DB2 sqlstate 57016 SQLCODE=-668 原因码 "7"错误的快速解决办法,一起看下吧
因为项目中需要用到db2 ,故找了一些db2 的错误码供查阅
以上所述是小编给大家介绍的详解DB2 sqlstate 57016 SQLCODE=-668 原因码 “7”错误的快速解决办法,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对软件开发网网站...
DB2的SQL、sqlcode、sqlstate错误码大全,含说明和用户响应方法,SQL0000~SQL9399
db2 数据库错误对照文档,错误分析及解决办法,常见的都有。db2数据库开发者最好的帮助文档。
DB2中出现的主要错误,操作数据库过程中,遇到许多问题,很多都与SQL CODE和SQL State相关,现在把一个完整的SQLCODE和SQLState错误信息和相关解释作以下说明,一来可以自己参考,对DB2错误自行找出原因
涵盖所有常见DB2 sqlcode sqlstate的信息中文解释大全。 是进行DB2相关学习和工作的必备参考资料! 内容粗览: DB2错误信息(按sqlcode排序) sqlcode sqlstate 说明 000 00000 SQL语句成功完成 01xxx SQL语句成功...
NULL 博文链接:https://jingyemingyue.iteye.com/blog/1125082
DB2_sqlCode,罗列了DB2的报错代码,使用起来方便多了
DB2 SQLCODE 大全 DB2错误信息 sqlcode sqlstate 说明 000 00000 SQL语句成功完成 01xxx SQL语句成功完成,但是有警告 +012 01545 未限定的列名被解释为一个有相互关系的引用 +098 01568 动态SQL语句用分号结束 +100...
db2sql存储table数据库nullsqlcode sqlstate 说明 000 00000 SQL语句成功完成 01xxx SQL语句成功完成,但是有警告 +012 01545 未限定的列名被解释为一个有相互关系的引用 +098 01568 动态SQL语句用分号结束...
+012 01545 未限定的列名被解释为一个有相互关系的引用 +098 01568 动态SQL语句用分号结束 +100 02000 没有找到满足SQL语句的行 +110 01561 用DATA CAPTURE定义的表的更新操作不能发送到原来的子系统 ...
就业系统的使用说明
收集汇总了设计者在SQL 编程中所有出现的错误代码提示大全 希望对大家有所帮助
常见db2错误代码分析提示,如: +117 01525 要插入的值的个数不等于被插入表的列数 +218 01537 因为SQL语句引用一个远程对象,不能为该SQL语句执行EXPLAIN
提供db2 sqlcode大全,包括所有的报错代码信息。。。。
1、DB2(DataBase2DataBase)开发常遇到一些错误,汇总了几百个常见的错误信息,用以查错使用。 2、可以按需检索,检索错误码或者关键字都可以。 3、资源内容列举: 关键字:SQL0084 SQLCODE -84 说明: SQL statement...
DB2错误信息 sqlcode error code DB2 SQL Error: SQLCODE SQLSTATE
db2数据库错误解决代码sqlcode db2数据库错误解决代码sqlcode