Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Spring JIRA by Miles Huang, 1 year ago
E.JOB_INSTANCE_ID=I.JOB_INSTANCE_ID) AS TMP_SUB WHERE TMP_SUB.ROW_NUMBER = 20 ORDER BY E.JOB_EXECUTION_ID DESC]; nested exception is com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=E.JOB_EXECUTION_ID, DRIVER
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT E.JOB_EXECUTION_ID FROM ( SELECT E.JOB_EXECUTION_ID, ROW_NUMBER() OVER ( ORDER BY E.JOB_EXECUTION_ID DESC) AS ROW_NUMBER FROM SPSSAMPLE.BATCH_JOB_EXECUTION E, SPSSAMPLE.BATCH_JOB_INSTANCE I WHERE E.JOB_INSTANCE_ID=I.JOB_INSTANCE_ID) AS TMP_SUB WHERE TMP_SUB.ROW_NUMBER = 20 ORDER BY E.JOB_EXECUTION_ID DESC]; nested exception is com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=E.JOB_EXECUTION_ID, DRIVER=4.13.80] with root cause
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=E.JOB_EXECUTION_ID, DRIVER=4.13.80	at com.ibm.db2.jcc.am.id.a(id.java:677)	at com.ibm.db2.jcc.am.id.a(id.java:60)	at com.ibm.db2.jcc.am.id.a(id.java:127)	at com.ibm.db2.jcc.am.fo.c(fo.java:2653)	at com.ibm.db2.jcc.am.fo.d(fo.java:2641)	at com.ibm.db2.jcc.am.fo.a(fo.java:2090)	at com.ibm.db2.jcc.t4.cb.h(cb.java:141)	at com.ibm.db2.jcc.t4.cb.b(cb.java:41)	at com.ibm.db2.jcc.t4.q.a(q.java:32)	at com.ibm.db2.jcc.t4.sb.i(sb.java:135)	at com.ibm.db2.jcc.am.fo.ib(fo.java:2059)	at com.ibm.db2.jcc.am.fo.a(fo.java:3130)	at com.ibm.db2.jcc.am.fo.a(fo.java:688)	at com.ibm.db2.jcc.am.fo.executeQuery(fo.java:672)	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464)	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:472)	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:477)	at org.springframework.batch.admin.service.JdbcSearchableJobExecutionDao.getJobExecutions(JdbcSearchableJobExecutionDao.java:191)	at org.springframework.batch.admin.service.SimpleJobService.listJobExecutions(SimpleJobService.java:234)	at org.springframework.batch.admin.web.JobExecutionController.list(JobExecutionController.java:161)	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:601)	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)	at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:73)	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008)	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)	at java.lang.Thread.run(Thread.java:722)