Errors with Jboss Portal and Postgres

[mclaugs]

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)

[roth]

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

[mclaugs]

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