phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ns G <nsgns...@gmail.com>
Subject REG: Query failing when executing through JDBC
Date Thu, 04 Feb 2016 13:41:23 GMT
Hi There,

I have a query which is failing when executing through JDBC (using spring
jdbctemplate) but when the same query is executed through sqlline it is
working fine.

the thing is the column does not belong to my table at all.

Here is the Stack Trace of the error when executing through JDBC

org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703):
*Undefined
column. columnName=EVENT\*r\n\tat
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99)\r\n\tat
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)\r\n\tat
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\r\n\tat
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\r\n\tat
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)\r\n\tat
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)\r\n\tat
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:481)\r\n\tat
com.nielsen.ap.ndm.dao.impl.AuditDAOImpl.findAuditsByCategory(AuditDAOImpl.java:124)\r\n\tat
com.nielsen.ap.ndm.dao.impl.AuditDAOImpl$$FastClassBySpringCGLIB$$8840cc54.invoke(<generated>)\r\n\tat
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n\tat
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717)\r\n\tat
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)\r\n\tat
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)\r\n\tat
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)\r\n\tat
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)\r\n\tat
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n\tat
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)\r\n\tat
com.nielsen.ap.ndm.dao.impl.AuditDAOImpl$$EnhancerBySpringCGLIB$$2ba71b3.findAuditsByCategory(<generated>)\r\n\tat
com.nielsen.ap.ndm.audit.AuditTableProcessor.findAuditDetails(AuditTableProcessor.java:25)\r\n\tat
com.nielsen.ap.ndm.service.impl.AuditServiceImpl.findAuditsByCategory(AuditServiceImpl.java:60)\r\n\tat
com.nielsen.ap.ndm.controller.AuditController.viewAudit(AuditController.java:52)\r\n\tat
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\r\n\tat
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat
java.lang.reflect.Method.invoke(Method.java:606)\r\n\tat
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)\r\n\tat
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)\r\n\tat
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)\r\n\tat
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:776)\r\n\tat
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705)\r\n\tat
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\r\n\tat
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)\r\n\tat
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)\r\n\tat
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)\r\n\tat
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)\r\n\tat
javax.servlet.http.HttpServlet.service(HttpServlet.java:620)\r\n\tat
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)\r\n\tat
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)\r\n\tat
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)\r\n\tat
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\r\n\tat
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n\tat
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)\r\n\tat
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\r\n\tat
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)\r\n\tat
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)\r\n\tat
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)\r\n\tat
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)\r\n\tat
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\r\n\tat
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)\r\n\tat
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)\r\n\tat
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)\r\n\tat
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)\r\n\tat
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)\r\n\tat
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)\r\n\tat
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\r\n\tat
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)\r\n\tat
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\n\tat
java.lang.Thread.run(Thread.java:744)\r\nCaused by:
org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703):
Undefined column. columnName=EVENT\r\n\tat
org.apache.phoenix.compile.RowProjector.getColumnIndex(RowProjector.java:155)\r\n\tat
org.apache.phoenix.jdbc.PhoenixResultSet.findColumn(PhoenixResultSet.java:178)\r\n\tat
org.apache.phoenix.jdbc.PhoenixResultSet.getString(PhoenixResultSet.java:614)\r\n\tat
org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263)\r\n\tat
org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263)\r\n\tat
com.nielsen.ap.ndm.dao.impl.AuditDAOImpl$1.mapRow(AuditDAOImpl.java:133)\r\n\tat
com.nielsen.ap.ndm.dao.impl.AuditDAOImpl$1.mapRow(AuditDAOImpl.java:1)\r\n\tat
org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:93)\r\n\tat
org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:60)\r\n\tat
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:460)\r\n\tat
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)\r\n\t...
53 more\r\n."


Any insight please?

Thanks,

Mime
View raw message