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}last...,
<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}last...,
<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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...