The SQL for Upgrade version 21 to 22 is wrong:
// add columns for SASL SCRAM-SHA-1
ALTER TABLE ofUser ADD COLUMN storedKey VARCHAR(32);
ALTER TABLE ofUser ADD COLUMN serverKey VARCHAR(32);
ALTER TABLE ofUser ADD COLUMN salt VARCHAR(32);
ALTER TABLE ofUser ADD COLUMN iterations INTEGER; UPDATE ofVersion SET version = 22 WHERE name = 'openfire'; COMMIT;
should better be:
ALTER TABLE pjabber.ofUser ADD ( storedKey VARCHAR2(32));
ALTER TABLE pjabber.ofUser ADD (serverKey VARCHAR2(32));
ALTER TABLE pjabber.ofUser ADD ( salt VARCHAR2(32));
ALTER TABLE pjabber.ofUser ADD ( iterations INTEGER); UPDATE ofVersion SET version = 22 WHERE name = 'openfire'; COMMIT;
Cheers
Christian