[jboss-jira] [JBoss JIRA] Created: (JBPORTAL-2258) Create file in CMS not working for several databases

[Viliam Rockai (JIRA)]

Create file in CMS not working for several databases
----------------------------------------------------

                 Key: JBPORTAL-2258
                 URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
             Project: JBoss Portal
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: Portal CMS
    Affects Versions: 2.7.0 Final
            Reporter: Viliam Rockai
            Assignee: Sohil Shah
             Fix For: 2.7.1 Final


there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these steps on clean database.

create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English

and type "test content" into the content textarea. 

4. click create

after clicking create you see and error page dependent on used database. 
for oracle 9i:
exception

javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085) violated

	org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

root cause

java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085) violated

	oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
	oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
	org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)

-----

for oracle 10g:

exception

javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442) violated

	org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

root cause

java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442) violated

	oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
	oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
	org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)

-----------

for postgres:

exception

javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values (6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}language, <stream of 28 bytes>, 33) was aborted.  Call getNextException to see the cause.
	org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	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 (6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}language, <stream of 28 bytes>, 33) 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)

------------

when the browsers back button is pressed, trying to click the create button again lead into new error (same for each db):

ERROR
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:879)
	at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
	at org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
	at org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)


------------------------------

the interesting part is that i.e. creation of a directory in cms is working fine at the start, but once you try to create file, you have this exception and you cannot create even the folder anymore.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira