Eric notes that in Oracle empty string is NUL. So needs to be nullable or the code needs to be updated.
KualiHttpSessionListener.sessionDestroyed(..) assumes only one document locked by user
PessimisticLockServiceTest mysql fails with Column 'SESN_ID' cannot be null
Oracle treats empty strings like null values. Change the default value to "undefined".
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.
This wiki page should also be updated: https://wiki.kuali.org/display/KULRICE/Upgrade+Troubleshooting