Uploaded image for project: 'Kuali Rice Development'
  1. Kuali Rice Development
  2. KULRICE-9288

org.kuali.rice.kns.service.impl.PessimisticLockServiceTest fails with Column 'SESN_ID' cannot be null

    Details

    • Type: Bug Fix
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.5, 2.2.3
    • Fix Version/s: 2.1.6, 2.2.4
    • Component/s: Development
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      Eric notes that in Oracle empty string is NUL. So needs to be nullable or the code needs to be updated.

        Attachments

          Issue Links

            Activity

            Hide
            cniesen Claus Niesen added a comment - - edited

            Oracle treats empty strings like null values. Change the default value to "undefined".

            Show
            cniesen Claus Niesen added a comment - - edited Oracle treats empty strings like null values. Change the default value to "undefined".
            Hide
            shahess Shannon Hess added a comment -

            Claus was thinking that these two SQL statements would work -

            mysql: ALTER TABLE KRNS_PESSIMISTIC_LOCK_T ALTER COLUMN SESN_ID SET DEFAULT 'undefined';

            oracle: ALTER TABLE KRNS_PESSIMISTIC_LOCK_T MODIFY (SESN_ID NOT NULL DEFAULT 'undefined');

            I also need to verify that just changing the column default will suffice or if all records that have an empty string (if that's actually possible with the old database definition) need to be updated.

            Show
            shahess Shannon Hess added a comment - Claus was thinking that these two SQL statements would work - mysql: ALTER TABLE KRNS_PESSIMISTIC_LOCK_T ALTER COLUMN SESN_ID SET DEFAULT 'undefined'; oracle: ALTER TABLE KRNS_PESSIMISTIC_LOCK_T MODIFY (SESN_ID NOT NULL DEFAULT 'undefined'); I also need to verify that just changing the column default will suffice or if all records that have an empty string (if that's actually possible with the old database definition) need to be updated.
            Hide
            gilesp Peter Giles (Inactive) added a comment -
            Show
            gilesp Peter Giles (Inactive) added a comment - This wiki page should also be updated: https://wiki.kuali.org/display/KULRICE/Upgrade+Troubleshooting

              People

              • Assignee:
                shahess Shannon Hess
                Reporter:
                eghm-kuali-m Erik Meade
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: