SQLGrammarException in JBP 2.4
danny_hon Aug 4, 2006 6:05 PMI checked out and compiled the latest 2.4 code, and deployed the portal to AS 4.0.4GA, using MySQL 4.x as database. I got a SQLGrammarException during login. Below is the exception.
17:00:29,009 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
17:00:29,009 ERROR [JDBCExceptionReporter] Table 'jbptest.jbp_instance_per_user' doesn't exist
17:00:29,009 ERROR [ControllerCommand] Rendering portlet window default.default.CatalogPortletWindow produced an interna
l error
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2061)
at org.hibernate.loader.Loader.list(Loader.java:2021)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:756)
at org.jboss.portal.core.impl.model.instance.InstanceImpl.invoke(InstanceImpl.java:248)
at org.jboss.portal.core.command.RenderWindowCommand.execute(RenderWindowCommand.java:108)
at org.jboss.portal.core.command.ControllerCommand.dispatch(ControllerCommand.java:91)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
at org.jboss.portal.core.aspects.controller.EventBroadcasterInterceptor.invoke(EventBroadcasterInterceptor.java:
171)
at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
at org.jboss.portal.core.aspects.controller.PageNavigationInterceptor.invoke(PageNavigationInterceptor.java:80)
at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.jav
a:79)
at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
at org.jboss.portal.core.aspects.controller.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:59)
at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
at org.jboss.portal.core.command.CommandContext.execute(CommandContext.java:102)
at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:91)
at org.jboss.portal.core.command.CommandContext.chain(CommandContext.java:148)
at org.jboss.portal.core.command.MarkupCommand.renderPortletWindow(MarkupCommand.java:463)
at org.jboss.portal.core.command.RenderPageCommand.renderFragments(RenderPageCommand.java:76)
at org.jboss.portal.core.command.MarkupCommand.execute(MarkupCommand.java:340)
at org.jboss.portal.core.command.ControllerCommand.dispatch(ControllerCommand.java:91)
at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
at org.jboss.portal.core.aspects.controller.EventBroadcasterInterceptor.invoke(EventBroadcasterInterceptor.java:
171)