Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-25807

UpgradeJournal and UpgradeCommunityProperties cause data corruption in certain databases

    Details

      Description

      Due to the fix for LPS-20920, the update process for journal structures and community properties will truncate the data to different lengths in certain databases (DB2, Derby, Oracle, SQL Server, Sybase), causing data corruption for those databases if the data in those columns is longer than the CAST_TEXT length in Liferay.

      To work around the issue, run the normal replace() without a cast, and in order to address the issue in LPS-20920, catch the exception that gets thrown for databases that do not support the replace without a cast, and replace each row individually.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  6 years, 48 weeks, 1 day ago