Skip to content
Other versions

Loading…

Migrating from 6.3.2 to 6.3.3

Preliminars

Section titled “Preliminars”
  • Make a backup!!!

Migration

Section titled “Migration”

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.