2 Replies Latest reply on Jul 23, 2007 10:42 AM by Scott McLaughlin

    Errors with Jboss Portal and Postgres

    Scott McLaughlin Newbie

      I have installed Jboss Portal 2.6 GA(bundled with Jboss 4.0.5 GA)
      as I work with the different features of the portal, most of the errors are around the CMS portlet in the admin portal. below is one of the many errors I am curious if any one else has seen these type of errors.

      Configuration
      Jboss Portal 2.6 GA bundled with 4.0.5 GA (from download site)
      Postgresql 8.2.4
      Postgresql JDBC version (8.2-505 JDBC 3)
      JDK 1.5.0_07
      MacOSX 10.4.10 PPC

      Reading through the documentation it looks like postgres is a supported database server, I have used the portal-postgresql-ds.xml from the setup directory modified for my database configuration.

      Any one that can help would be wonderful.

      Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
      Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
      StackTrace:
      
      javax.portlet.PortletException: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
       at org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:631)
       at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:361)
       at org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl.invokeAction(PortletContainerImpl.java:458)
       at org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl.dispatch(PortletContainerImpl.java:401)
       at org.jboss.portal.portlet.container.PortletContainerInvoker$1.invoke(PortletContainerInvoker.java:86)
       at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
       at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.org$jboss$portal$core$aspects$portlet$TransactionInterceptor$invokeRequired$aop(TransactionInterceptor.java:106)
       at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeRequired_9103964459766407072.invokeNext(TransactionInterceptor$invokeRequired_9103964459766407072.java)
       at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
       at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
       at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeRequired_9103964459766407072.invokeNext(TransactionInterceptor$invokeRequired_9103964459766407072.java)
       at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
       at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
       at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeRequired_9103964459766407072.invokeNext(TransactionInterceptor$invokeRequired_9103964459766407072.java)
       at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.invokeRequired(TransactionInterceptor.java)
       at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.invoke(TransactionInterceptor.java:72)
       at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
       at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
       at org.jboss.portal.core.aspects.portlet.HeaderInterceptor.invoke(HeaderInterceptor.java:50)
       at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
       at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
       at org.jboss.portal.portlet.aspects.portlet.ProducerCacheInterceptor.invoke(ProducerCacheInterceptor.java:53)
       at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
      


        • 1. Re: Errors with Jboss Portal and Postgres
          roth Newbie

          I am using postgresql-8.2-504.jdbc2.jar and everything works just fine.

          • 2. Re: Errors with Jboss Portal and Postgres
            Scott McLaughlin Newbie

            Thanks roth, I have now install the postgresql-8.2-505.jdbc2.jar driver. I was using the jdbc3 driver. after I did this I still am seeing the same type of issues. in addition to this I am using the a fresh database that is owned by the portal user configured in the data source. Can you describe how you have setup your database/ data server. I am using a local server on the same physical machine as the Jboss server. the postgres server is configured for connections from both local pipe and also local network tcp. did you have to do anything as far as configuration to either the postgres server or the portal install other than the portal-postgresql-ds.xml file?

            At this point the portal works, but where I am finding problems is the cms related features. if I try to add files, delete files, edit documents ...

            Here is an example of another error.

            javax.servlet.ServletException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values (d0723d7a-d6ba-4042-a26a-4e95ee03d803/{http://jboss.org/jcr/portalcms}lastmodified, <stream of 56 bytes>, 51) was aborted. Call getNextException to see the cause.
             org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:406)
             javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
             org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
            
            root cause
            
            java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values (d0723d7a-d6ba-4042-a26a-4e95ee03d803/{http://jboss.org/jcr/portalcms}lastmodified, <stream of 56 bytes>, 51) was aborted. Call getNextException to see the cause.
             org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
             org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
             org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
             org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2592)
             org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:519)
             org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
             org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
             org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
             org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)


            Thanks in advance to anyone that can help ;)