[jboss-user] [JBoss Portal] - SQLGrammarException in JBP 2.4

[danny_hon]

I 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)

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3963327#3963327

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3963327