[jboss-user] [JBoss Portal] - Re: Errors with Jboss Portal and Postgres

sojoknuckle do-not-reply at jboss.com
Mon Jul 23 10:42:51 EDT 2007


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

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

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



More information about the jboss-user mailing list