3 Replies Latest reply on Jul 30, 2005 2:14 AM by peter

    Some bugs in the forum portal

    Florian Gogon Newbie

      Hello,

      I'm making my training period, and i have some troubles with the forum portlet.

      I was using the bundle pack with JBoss AS and JBoss Portal with an Oracle9i database, and i have already some errors with the forum.

      As i have problems with Mbeans components, i thought it was these errors that was bugging the forum ( i don't understand exactly how the JBoss Server works so... ).

      So i decided to install the JBoss AS 4.0.2 and the JBoss Portal 2.0 separetely: I don't still have errors with MBeans :-) but the forum is still bugging.

      I saw that someone has already posted with errors like me but as no body has reply to him, i decide to post again.
      http://www.jboss.org/index.html?module=bb&op=viewtopic&t=65510

      When i deploy the forum in the portal, there are no errors, but when i use it, I have these bugs:

      first one:when i create a topic, this one is inserted in the database,we can see into the forum, but i have this:

      15:48:39,640 ERROR [CoreServlet] Error
      java.lang.NullPointerException
      at org.jboss.portlet.forums.ForumsPortlet.fillShowForumContext(ForumsPor
      tlet.java:2350)
      at org.jboss.portlet.forums.ForumsPortlet.doView(ForumsPortlet.java:346)

      at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:217)
      at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:204)
      at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:347)
      at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeReque
      st(DispatcherInterceptor.java:163)
      at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(Disp
      atcherInterceptor.java:195)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(Pre
      ferencesInterceptor.java:93)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.server.invocation.component.ContextDispatcherInterce
      ptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:94)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.j
      ava:49)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
      icationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
      ilterChain.java:173)
      at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
      atcher.java:672)
      at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
      ispatcher.java:539)
      at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
      patcher.java:499)
      at org.jboss.portal.server.invocation.component.ContextDispatcherInterce
      ptor.invoke(ContextDispatcherInterceptor.java:58)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.core.invocation.AccessControlInterceptor.invoke(Acce
      ssControlInterceptor.java:125)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.server.invocation.component.CacheInterceptor.invoke(
      CacheInterceptor.java:74)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:238)
      at org.jboss.portal.server.Component.invoke(Component.java:173)
      at org.jboss.portal.server.invocation.portal.MainDispatcherInterceptor.i
      nvoke(MainDispatcherInterceptor.java:93)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.core.invocation.StrategyInterceptor.invoke(StrategyI
      nterceptor.java:184)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.core.invocation.ViewInterceptor.invoke(ViewIntercept
      or.java:118)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.server.invocation.portal.TargetInterceptor.invoke(Ta
      rgetInterceptor.java:153)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.core.invocation.ContentTypeInterceptor.invoke(Conten
      tTypeInterceptor.java:117)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.core.invocation.UserContextInterceptor.invoke(UserCo
      ntextInterceptor.java:92)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:238)
      at org.jboss.portal.server.PortalServer.invoke(PortalServer.java:186)
      at org.jboss.portal.server.servlet.AbstractMainServlet.invoke(AbstractMa
      inServlet.java:78)
      at org.jboss.portal.server.servlet.AbstractMainServlet.doGet(AbstractMai
      nServlet.java:71)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
      icationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
      ilterChain.java:173)
      at org.jboss.portal.core.servlet.TransactionFilter$1.run(TransactionFilt
      er.java:79)
      at org.jboss.portal.common.transaction.Transactions.requiresNew(Transact
      ions.java:149)
      at org.jboss.portal.core.servlet.TransactionFilter.doFilter(TransactionF
      ilter.java:75)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
      icationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
      ilterChain.java:173)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
      lter.java:81)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
      icationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
      ilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
      alve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
      alve.java:178)
      at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrinc
      ipalValve.java:39)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
      yAssociationValve.java:153)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
      torBase.java:482)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
      e.java:59)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
      ava:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
      ava:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
      ve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
      a:148)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
      :856)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
      ssConnection(Http11Protocol.java:744)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
      int.java:527)
      at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
      kerThread.java:112)
      at java.lang.Thread.run(Thread.java:595)
      15:49:03,044 INFO [STDOUT] INTERVAL:2159
      15:49:06,789 ERROR [JDBCTransaction] JDBC commit failed
      java.sql.SQLException: You cannot commit during a managed transaction!
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcComm
      it(BaseWrapperManagedConnection.java:519)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConne
      ction.java:451)
      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
      :95)
      at org.jboss.portlet.forums.impl.ForumsModuleImpl.createTopic(ForumsModu
      leImpl.java:430)
      at org.jboss.portlet.forums.commands.post.NewTopicCommand.__execute(NewT
      opicCommand.java:89)
      at org.jboss.portlet.forums.commands.post.ForumCommand.execute(ForumComm
      and.java:163)
      at org.jboss.portal.common.command.filter.ExecuteFilter.filter(ExecuteFi
      lter.java:25)
      at org.jboss.portlet.forums.interceptors.FloodControlInterceptor.filter(
      FloodControlInterceptor.java:87)
      at org.jboss.portlet.forums.interceptors.NotificationInterceptor.filter(
      NotificationInterceptor.java:122)
      at org.jboss.portal.common.command.filter.CompositeFilter.filter(Composi
      teFilter.java:41)
      at org.jboss.portlet.forums.ForumsPortlet.posting(ForumsPortlet.java:576
      )
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:140)
      at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:96)
      at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:342)
      at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeActio
      n(DispatcherInterceptor.java:110)
      at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(Disp
      atcherInterceptor.java:191)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(Pre
      ferencesInterceptor.java:93)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.server.invocation.component.ContextDispatcherInterce
      ptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:94)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.j
      ava:49)
      at org.jboss.portal.server.servlet.CommandServlet.doPost(CommandServlet.
      java:98)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
      icationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ...etc...


      second one:When i post-reply(it works too,but that generate me errors...), i have:



      15:58:31,321 ERROR [ReplyCommand] Cannot create post reply
      org.jboss.portal.core.modules.ModuleException: Cannot create topic
      at org.jboss.portlet.forums.impl.ForumsModuleImpl.createPost(ForumsModul
      eImpl.java:484)
      at org.jboss.portlet.forums.commands.post.ReplyCommand.__execute(ReplyCo
      mmand.java:74)
      at org.jboss.portlet.forums.commands.post.ForumCommand.execute(ForumComm
      and.java:163)
      at org.jboss.portal.common.command.filter.ExecuteFilter.filter(ExecuteFi
      lter.java:25)
      at org.jboss.portlet.forums.interceptors.FloodControlInterceptor.filter(
      FloodControlInterceptor.java:87)
      at org.jboss.portlet.forums.interceptors.NotificationInterceptor.filter(
      NotificationInterceptor.java:122)
      at org.jboss.portal.common.command.filter.CompositeFilter.filter(Composi
      teFilter.java:41)
      at org.jboss.portlet.forums.ForumsPortlet.posting(ForumsPortlet.java:576
      )
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:140)
      at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:96)
      at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:342)
      at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeActio
      n(DispatcherInterceptor.java:110)
      at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(Disp
      atcherInterceptor.java:191)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(Pre
      ferencesInterceptor.java:93)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.server.invocation.component.ContextDispatcherInterce
      ptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:94)
      at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.j
      ava:49)
      at org.jboss.portal.server.servlet.CommandServlet.doPost(CommandServlet.
      java:98)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
      icationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
      ilterChain.java:173)
      at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
      atcher.java:672)
      at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
      ispatcher.java:539)
      at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
      patcher.java:499)
      at org.jboss.portal.server.invocation.component.ContextDispatcherInterce
      ptor.invoke(ContextDispatcherInterceptor.java:58)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.core.invocation.AccessControlInterceptor.invoke(Acce
      ssControlInterceptor.java:125)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.server.invocation.component.CacheInterceptor.invoke(
      CacheInterceptor.java:74)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:238)
      at org.jboss.portal.server.Component.invoke(Component.java:130)
      at org.jboss.portal.server.invocation.portal.TargetInterceptor.invokeWin
      dow(TargetInterceptor.java:167)
      at org.jboss.portal.server.invocation.portal.TargetInterceptor.invoke(Ta
      rgetInterceptor.java:67)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.core.invocation.ContentTypeInterceptor.invoke(Conten
      tTypeInterceptor.java:117)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.core.invocation.UserContextInterceptor.invoke(UserCo
      ntextInterceptor.java:92)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:238)
      at org.jboss.portal.server.PortalServer.invoke(PortalServer.java:186)
      at org.jboss.portal.server.servlet.AbstractMainServlet.invoke(AbstractMa
      inServlet.java:78)
      at org.jboss.portal.server.servlet.AbstractMainServlet.doGet(AbstractMai
      nServlet.java:71)
      at org.jboss.portal.server.servlet.AbstractMainServlet.doPost(AbstractMa
      inServlet.java:62)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
      icationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
      ilterChain.java:173)
      at org.jboss.portal.core.servlet.TransactionFilter$1.run(TransactionFilt
      er.java:79)
      at org.jboss.portal.common.transaction.Transactions.requiresNew(Transact
      ions.java:149)
      at org.jboss.portal.core.servlet.TransactionFilter.doFilter(TransactionF
      ilter.java:75)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
      icationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
      ilterChain.java:173)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
      lter.java:81)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
      icationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
      ilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
      alve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
      alve.java:178)
      at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrinc
      ipalValve.java:39)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
      yAssociationValve.java:153)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
      torBase.java:482)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
      e.java:59)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
      ava:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
      ava:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
      ve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
      a:148)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
      :856)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
      ssConnection(Http11Protocol.java:744)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
      int.java:527)
      at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
      kerThread.java:112)
      at java.lang.Thread.run(Thread.java:595)
      Caused by: org.hibernate.TransactionException: JDBC commit failed
      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
      :110)
      at org.jboss.portlet.forums.impl.ForumsModuleImpl.createPost(ForumsModul
      eImpl.java:477)
      ... 79 more
      Caused by: java.sql.SQLException: You cannot commit during a managed transaction
      !
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcComm
      it(BaseWrapperManagedConnection.java:519)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConne
      ction.java:451)
      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
      :95)
      ... 80 more



      third one:When i TRY (that don't work, and contrary to the other post[ in your forum], i still have:Second forum - 1 - 1 - Edit - etc ) to delete a post( just after clicking the YES button), i have that:


      16:07:47,581 INFO [STDOUT] INTERVAL:752
      16:07:51,146 WARN [JDBCExceptionReporter] SQL Error: 2292, SQLState: 23000
      16:07:51,176 ERROR [JDBCExceptionReporter] ORA-02292: violation de contrainte (J
      BOSS.FK54374318C1B3E31F) d'intÚgritÚ - enregistrement fils existant

      16:07:51,286 WARN [JDBCExceptionReporter] SQL Error: 2292, SQLState: 23000
      16:08:18,755 ERROR [JDBCExceptionReporter] ORA-02292: violation de contrainte (J
      BOSS.FK54374318C1B3E31F) d'intÚgritÚ - enregistrement fils existant

      16:08:18,856 ERROR [AbstractFlushingEventListener] Could not synchronize databas
      e state with session
      org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch updat
      e
      at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificExceptio
      n(ErrorCodeConverter.java:92)
      at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter
      .java:80)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
      er.java:43)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
      179)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)

      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)

      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
      ns(AbstractFlushingEventListener.java:274)
      at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
      aultAutoFlushEventListener.java:48)
      at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:6
      97)
      at org.hibernate.impl.SessionImpl.prepareQueries(SessionImpl.java:881)
      at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:871)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:820)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
      at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.j
      ava:603)
      at org.jboss.portlet.forums.impl.ForumsModuleImpl.findLastPost(ForumsMod
      uleImpl.java:941)
      at org.jboss.portlet.forums.commands.post.DeletePostCommand.__execute(De
      letePostCommand.java:109)
      at org.jboss.portlet.forums.commands.post.ForumCommand.execute(ForumComm
      and.java:163)
      at org.jboss.portal.common.command.filter.ExecuteFilter.filter(ExecuteFi
      lter.java:25)
      at org.jboss.portlet.forums.interceptors.FloodControlInterceptor.filter(
      FloodControlInterceptor.java:87)
      at org.jboss.portlet.forums.interceptors.NotificationInterceptor.filter(
      NotificationInterceptor.java:122)
      at org.jboss.portal.common.command.filter.CompositeFilter.filter(Composi
      teFilter.java:41)
      at org.jboss.portlet.forums.ForumsPortlet.posting(ForumsPortlet.java:576
      )
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:140)
      at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:96)
      at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:342)
      at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeActio
      n(DispatcherInterceptor.java:110)
      at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(Disp
      atcherInterceptor.java:191)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(Pre
      ferencesInterceptor.java:93)
      at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(Inv
      ocationImpl.java:213)
      at org.jboss.portal.server.invocation.component.ContextDispatcherInterce
      ptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:94)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.j
      ava:49)
      at org.jboss.portal.server.servlet.CommandServlet.doPost(CommandServlet.
      java:98)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
      icationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
      ilterChain.java:173)
      at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
      atcher.java:672)


      I can also tell that if i click on the NO button when the forum ask me i'm sure for deleting, that make nothing( don't go back to the last screen or back to the forum..).

      I have also noticed that when i create or delete a watched forum, there were some errors, but it works well... :-)

      I don't make all the test on the forum, but if i can delete a post, it would be a big step in all my problems.

      I have also this when i enter in the forum, is it normal or is an error too???
      15:47:43,139 WARN [PARSER] *** WARNING: Keyword 'order' is being intepreted as
      an identifier due to: expecting IDENT, found 'order'
      15:47:43,189 WARN [PARSER] *** WARNING: Keyword 'order' is being intepreted as
      an identifier due to: expecting IDENT, found 'order'


      i have these errors too with hsqldb( with the bundle pack) so i don't think it's the fault of Oracle...


      Well, sorry for making only reproch... whereas I find the portal works well... unfortunately, i'm sad that the forum portlet (an usefull one!!) don't work totally with me...

      Sorry too for my basic english... i wish that everyone will understand what i try to explain...

      It the first time i post in a forum... so i wish it'll be usefull... and attempt really some help plz...

      Thanks.

      Flo.

        • 1. Re: Some bugs in the forum portal
          Florian Gogon Newbie

          Well ... the title of my topic should be "some bugs in the forum portlet" and not forum portal... sorry...

          Plz answer me if i'm alone to have these troubles in the ForumPortlet or if it's normal that the forum don't work completely.
          It'll be good for me to know...

          Thanks.
          Flo.

          • 2. Re: Some bugs in the forum portal
            peter Apprentice

            Anybody can help?

            I also have similar problem for forum portlet.

            My system is linux+AS4.0.2+PostgreSQL 8.

            When i delete a post, the deletion always fail! But i can post/reply. Only delete post doesn't work.


            2005-07-30 13:20:17,479 DEBUG [org.hibernate.SQL] delete from jbp_forums_topics where jbp_id=?
            2005-07-30 13:20:17,479 DEBUG [org.hibernate.jdbc.AbstractBatcher] preparing statement
            2005-07-30 13:20:17,479 DEBUG [org.hibernate.type.IntegerType] binding '20' to parameter: 1
            2005-07-30 13:20:17,480 DEBUG [org.hibernate.jdbc.AbstractBatcher] Adding to batch
            2005-07-30 13:20:17,480 DEBUG [org.hibernate.jdbc.AbstractBatcher] Executing batch size: 1
            2005-07-30 13:20:17,481 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements
            : 1, globally: 1)
            2005-07-30 13:20:17,481 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement
            2005-07-30 13:20:17,481 DEBUG [org.hibernate.util.JDBCExceptionReporter] Could not execute JDBC batch update [delete from jb
            p_forums_topics where jbp_id=?]
            java.sql.BatchUpdateException: Batch entry 0 delete from jbp_forums_topics where jbp_id=20 was aborted. Call getNextExcepti
            on to see the cause.
            at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2387)
            at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1257)
            at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:334)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2446)
            at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:701)
            at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
            at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:172)
            at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
            at org.hibernate.engine

            ......................
            .......................

            2005-07-30 13:20:17,485 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null
            2005-07-30 13:20:17,505 ERROR [org.hibernate.util.JDBCExceptionReporter] Batch entry 0 delete from jbp_forums_topics where j
            bp_id=20 was aborted. Call getNextException to see the cause.
            2005-07-30 13:20:17,505 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 23503
            2005-07-30 13:20:17,505 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: update or delete on "jbp_forums_topics" viol
            ates foreign key constraint "fkf2c0436dbfb64ffa" on "jbp_forums_posts"
            2005-07-30 13:20:17,505 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state w
            ith session
            org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
            at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:63)
            at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
            at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:179)
            at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
            at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
            at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
            at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:48)
            at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:697)
            at org.hibernate.impl.SessionImpl.prepareQueries(SessionImpl.java:881)
            at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:871)
            at org.hibernate.impl.SessionImpl.list(SessionImpl.java:820)
            at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)



            • 3. Re: Some bugs in the forum portal
              peter Apprentice

              Through reading the db schema, the deletion failure could be due to the the foreign key constrains betwen jbp_forum_topics and jbp_forum_posts.

              Please comments.



              jbossportal=# \d jbp_forums_topics;
              Table "public.jbp_forums_topics"
              Column | Type | Modifiers
              --------------------+-----------------------------+-----------
              jbp_id | integer | not null
              jbp_forum_id | integer |
              jbp_view_count | integer |
              jbp_replies | integer |
              jbp_first_post_id | integer |
              jbp_last_post_id | integer |
              jbp_last_post_date | timestamp without time zone |
              jbp_poster | integer |
              jbp_type | integer |
              jbp_status | integer |
              jbp_subject | character varying(255) |
              Indexes:
              "jbp_forums_topics_pkey" PRIMARY KEY, btree (jbp_id)
              Foreign-key constraints:
              "fk6c1a04ca7892a9ba" FOREIGN KEY (jbp_forum_id) REFERENCES jbp_forums_forums(jbp_id)
              "fk6c1a04ca577068cb" FOREIGN KEY (jbp_first_post_id) REFERENCES jbp_forums_posts(jbp_id)
              "fk6c1a04ca145469a8" FOREIGN KEY (jbp_poster) REFERENCES jbp_forums_posters(jbp_id)
              "fk6c1a04cac1b3e31f" FOREIGN KEY (jbp_last_post_id) REFERENCES jbp_forums_posts(jbp_id)

              jbossportal=# \d jbp_forums_posts
              Table "public.jbp_forums_posts"
              Column | Type | Modifiers
              -----------------+-----------------------------+-----------
              jbp_id | integer | not null
              jbp_topic_id | integer |
              jbp_edit_count | integer |
              jbp_edit_date | timestamp without time zone |
              jbp_create_date | timestamp without time zone |
              jbp_subject | character varying(255) |
              jbp_text | character varying(255) |
              jbp_poster_id | integer |
              Indexes:
              "jbp_forums_posts_pkey" PRIMARY KEY, btree (jbp_id)
              Foreign-key constraints:
              "fkf2c0436d499bfc7a" FOREIGN KEY (jbp_poster_id) REFERENCES jbp_forums_posters(jbp_id)
              "fkf2c0436dbfb64ffa" FOREIGN KEY (jbp_topic_id) REFERENCES jbp_forums_topics(jbp_id)




              Yang