Migrating from 6.3.2 to 6.3.3

Preliminars

• Make a backup!!!

Migration

• Go to Administration > Database query and execute:

HSQL:

-- ADD COLUMN NDC_ENCRYPTION
ALTER TABLE OKM_NODE_DOCUMENT ADD COLUMN NDC_ENCRYPTION CHAR(1);
UPDATE OKM_NODE_DOCUMENT SET NDC_ENCRYPTION='T';
ALTER TABLE OKM_NODE_DOCUMENT ALTER COLUMN NDC_ENCRYPTION SET NOT NULL;
-- ADD COLUMN NDC_SIGNED
ALTER TABLE OKM_NODE_DOCUMENT ADD COLUMN NDC_SIGNED CHAR(1);
UPDATE OKM_NODE_DOCUMENT SET NDC_SIGNED='T';
ALTER TABLE OKM_NODE_DOCUMENT ALTER COLUMN NDC_SIGNED SET NOT NULL;

MySQL:

-- ADD COLUMN NDC_ENCRYPTION
ALTER TABLE OKM_NODE_DOCUMENT ADD COLUMN NDC_ENCRYPTION CHAR(1);
UPDATE OKM_NODE_DOCUMENT SET NDC_ENCRYPTION='F';
ALTER TABLE OKM_NODE_DOCUMENT MODIFY COLUMN NDC_ENCRYPTION CHAR(1) NOT NULL;
-- ADD COLUMN NDC_SIGNED
ALTER TABLE OKM_NODE_DOCUMENT ADD COLUMN NDC_SIGNED CHAR(1);
UPDATE OKM_NODE_DOCUMENT SET NDC_SIGNED='F';
ALTER TABLE OKM_NODE_DOCUMENT MODIFY COLUMN NDC_SIGNED CHAR(1) NOT NULL;

PosgreSQL:

-- ADD COLUMN NDC_ENCRYPTION
ALTER TABLE OKM_NODE_DOCUMENT ADD COLUMN NDC_ENCRYPTION CHAR(1);
UPDATE OKM_NODE_DOCUMENT SET NDC_ENCRYPTION='F';
ALTER TABLE OKM_NODE_DOCUMENT ALTER COLUMN NDC_ENCRYPTION SET NOT NULL;
-- ADD COLUMN NDC_SIGNED
ALTER TABLE OKM_NODE_DOCUMENT ADD COLUMN NDC_SIGNED CHAR(1);
UPDATE OKM_NODE_DOCUMENT SET NDC_SIGNED='F';
ALTER TABLE OKM_NODE_DOCUMENT ALTER COLUMN NDC_SIGNED SET NOT NULL;

• Stop Tomcat
• Edit OpenKM.cfg and set hibernate.hbm2ddl to update.
• Edit OpenKM.xml and modify

http://www.springframework.org/schema/security/spring-security-3.1.xsd

to

http://www.springframework.org/schema/security/spring-security-3.2.xsd

• Replace the OpenKM.war
• And start Tomcat again.