org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select count(0) from (select * from (select a.*,b.memo,rownumber() OVER (ORDER BY SFRQ DESC) AS ROW_NUM from B_XFDJ a,s_workflow b where (a.CLZT='转发' or a.CLZT='办结并答复')  and  a.DQCZZT='1=正常' and b.MAINTABLE = 'b_xfdj' and a.id=b.MAINTABLEID and b.MEMO IS NOT NULL and b.OPTIONS='已处理') as allpage) as tmp]; nested exception is com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2ADMIN.B_XFDJ
Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2ADMIN.B_XFDJ
	at com.ibm.db2.jcc.b.sf.e(sf.java:1680)
	at com.ibm.db2.jcc.b.sf.a(sf.java:1239)
	at com.ibm.db2.jcc.c.jb.h(jb.java:139)
	at com.ibm.db2.jcc.c.jb.a(jb.java:43)
	at com.ibm.db2.jcc.c.w.a(w.java:30)
	at com.ibm.db2.jcc.c.cc.g(cc.java:161)
	at com.ibm.db2.jcc.b.sf.n(sf.java:1219)
	at com.ibm.db2.jcc.b.tf.gb(tf.java:1818)
	at com.ibm.db2.jcc.b.tf.d(tf.java:2294)
	at com.ibm.db2.jcc.b.tf.X(tf.java:508)
	at com.ibm.db2.jcc.b.tf.executeQuery(tf.java:491)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:560)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:499)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:553)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:582)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:590)
	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:633)
	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:644)
	at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:671)
	at com.gzepro.form.business.impl.XfdjMgrImpl.getTotalCnt(XfdjMgrImpl.java:232)
	at com.gzepro.form.business.impl.XfdjMgrImpl.getXfdjs(XfdjMgrImpl.java:103)
	at com.gzepro.form.business.impl.XfdjMgrImpl$$FastClassByCGLIB$$ca6660a0.invoke()
	at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
	at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:714)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:162)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:652)
	at com.gzepro.form.business.impl.XfdjMgrImpl$$EnhancerByCGLIB$$9314f956.getXfdjs()
	at com.gzepro.form.web.XfdjController.index(XfdjController.java:53)
	at sun.reflect.GeneratedMethodAccessor186.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:434)
	at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:372)
	at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:806)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:736)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:78)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)