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

                relates to

                Bug Fix - A problem which impairs or prevents the functions of the product. KULRICE-8573 KualiHttpSessionListener.sessionDestroyed(..) assumes only one document locked by user

                • Major - Major loss of function.
                • Closed

                Bug Fix - A problem which impairs or prevents the functions of the product. KULRICE-9610 PessimisticLockServiceTest mysql fails with Column 'SESN_ID' cannot be null

                • Major - Major loss of function.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  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
                  Permalink
                  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
                  Permalink
                  gilesp Peter Giles (Inactive) added a comment -

                  This wiki page should also be updated: https://wiki.kuali.org/display/KULRICE/Upgrade+Troubleshooting

                  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: