Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-37677 oracle error for lesson builder tables
  3. SAK-38270

Fix up Lesson Builder CLOB mappings for Hibernate 3.6

    Details

    • Type: Sub-task
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.0
    • Component/s: Lessons
    • Labels:
      None

      Description

      After upgrading Hibernate to 3.6, the "text" type columns used here are mapped as LONG columns. Oracle only allows one LONG column in a table, while it allows multiple CLOBs, which was the actual intended data type of the change. Since Hibernate 3.5, the ambiguity around text types has been clarified, and when a String is desired on a Java object with a CLOB in the database, the "materialized_clob" type should now be used, regardless of any length limits.

      See also: KNL-515 and https://community.jboss.org/wiki/HibernateCoreMigrationGuide35

      The Hibernate upgrade will not be backported to 2.9.x, so the "text" type is still appropriate there, assuming that it is confirmed that all desired columns are created as CLOBs.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  hedrick Charles Hedrick
                  Reporter:
                  noahbotimer Noah Botimer
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration