Created
August 23, 2013 16:54
-
-
Save seeb/6321537 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| + Technical Information for Developers | |
| org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select acf.categoryID from articleCategoryFlagged acf join userProfile up on up.userProfileID = acf.userProfileID where up.authId = ? and acf.articleID = ?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query | |
| at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635) | |
| at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) | |
| at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) | |
| at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339) | |
| at org.ambraproject.service.article.ArticleServiceImpl.getFlaggedCategories(ArticleServiceImpl.java:845) | |
| at org.ambraproject.service.article.ArticleServiceImpl.createArticleInfo(ArticleServiceImpl.java:715) | |
| at org.ambraproject.service.article.ArticleServiceImpl.getArticleInfo(ArticleServiceImpl.java:644) | |
| at org.ambraproject.service.article.ArticleServiceImpl$$FastClassByCGLIB$$1d680ea0.invoke() | |
| at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) | |
| at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698) | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) | |
| at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) | |
| at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) | |
| at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) | |
| at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631) | |
| at org.ambraproject.service.article.ArticleServiceImpl$$EnhancerByCGLIB$$e9a73026.getArticleInfo() | |
| at org.ambraproject.action.article.FetchArticleTabsAction.setCommonData(FetchArticleTabsAction.java:282) | |
| at org.ambraproject.action.article.FetchArticleTabsAction.fetchArticle(FetchArticleTabsAction.java:136) | |
| 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 com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252) | |
| at org.ambraproject.struts2.EnsureUserAccountInterceptor.intercept(EnsureUserAccountInterceptor.java:103) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at org.ambraproject.struts2.InternalIpInterceptor.intercept(InternalIpInterceptor.java:46) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167) | |
| at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265) | |
| at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68) | |
| at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239) | |
| at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:161) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171) | |
| at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at com.opensymphony.xwork2.interceptor.LoggingInterceptor.intercept(LoggingInterceptor.java:67) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at com.opensymphony.xwork2.interceptor.TimerInterceptor.invokeUnderTiming(TimerInterceptor.java:135) | |
| at com.opensymphony.xwork2.interceptor.TimerInterceptor.intercept(TimerInterceptor.java:122) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189) | |
| at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) | |
| at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) | |
| at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:563) | |
| at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77) | |
| at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99) | |
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) | |
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) | |
| at org.ambraproject.web.JournalStaticResourceFilter.doFilter(JournalStaticResourceFilter.java:81) | |
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) | |
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) | |
| at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81) | |
| at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:132) | |
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) | |
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) | |
| at org.ambraproject.web.DummySSOFilter.doFilter(DummySSOFilter.java:106) | |
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) | |
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) | |
| at org.ambraproject.web.VirtualJournalMappingFilter.doFilter(VirtualJournalMappingFilter.java:85) | |
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) | |
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) | |
| at org.ambraproject.web.VirtualJournalContextFilter.doFilter(VirtualJournalContextFilter.java:142) | |
| 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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) | |
| at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) | |
| at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) | |
| at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) | |
| at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195) | |
| at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159) | |
| at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141) | |
| at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90) | |
| at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:406) | |
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) | |
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) | |
| at org.ambraproject.web.MultipleRequestFilter.doFilter(MultipleRequestFilter.java:137) | |
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) | |
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) | |
| at org.ambraproject.web.GatekeeperFilter.doFilter(GatekeeperFilter.java:71) | |
| 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:103) | |
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) | |
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) | |
| at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879) | |
| at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:600) | |
| at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1703) | |
| at java.lang.Thread.run(Thread.java:662) | |
| Caused by: org.hibernate.exception.SQLGrammarException: could not execute query | |
| at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) | |
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) | |
| at org.hibernate.loader.Loader.doList(Loader.java:2536) | |
| at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) | |
| at org.hibernate.loader.Loader.list(Loader.java:2271) | |
| at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) | |
| at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) | |
| at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) | |
| at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) | |
| at org.ambraproject.service.article.ArticleServiceImpl$4.doInHibernate(ArticleServiceImpl.java:847) | |
| at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) | |
| ... 112 more | |
| Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambra.articleCategoryFlagged' doesn't exist | |
| at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) | |
| at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) | |
| at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) | |
| at java.lang.reflect.Constructor.newInstance(Constructor.java:513) | |
| at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) | |
| at com.mysql.jdbc.Util.getInstance(Util.java:386) | |
| at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) | |
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) | |
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) | |
| at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) | |
| at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) | |
| at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) | |
| at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) | |
| at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2283) | |
| at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) | |
| at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) | |
| at org.hibernate.loader.Loader.doQuery(Loader.java:802) | |
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) | |
| at org.hibernate.loader.Loader.doList(Loader.java:2533) | |
| ... 120 more |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment