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

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