[jboss-jira] [JBoss JIRA] Created: (JBPORTAL-2023) Modify/Approve of CMS content with activated ApprovePublish workflow fails on Postgres 8.3.1

[Martin Putz (JIRA)]

Modify/Approve of CMS content with activated ApprovePublish workflow fails on Postgres 8.3.1
--------------------------------------------------------------------------------------------

                 Key: JBPORTAL-2023
                 URL: http://jira.jboss.com/jira/browse/JBPORTAL-2023
             Project: JBoss Portal
          Issue Type: Bug
      Security Level: Public (Everyone can see)
    Affects Versions: 2.6.5 Final, 2.6.4 Final
         Environment: Fedora Core 9, JBoss EAP 4.3, Postgresql 8.3.1
            Reporter: Martin Putz


With activated ApprovePublish workflow, hitting the 'Modify/Approve' button after a pending item is in the 'Preview' mode leads to an excpetion:

2008-05-22 13:39:20,559 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 22001
2008-05-22 13:39:20,559 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: value too long for type character varying(255)

This will only show if the content of the previewed file is larger than 255 characters, eg.:

1. open default/index.html
2. make a little modification, hit 'Create'
3. for the newly created item in the 'Pending Approval Queue' hit 'Preview'
4. make another little modification and hit 'Modify/Approve'

The SQL insert for JBPM_VARIABLEINSTANCE table fails because the STRINGVALUE_ column is set up with varchar(255).

The same works with the out-of-the-box Hypersonic DB.


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