Migración de 6.3.2 a 6.3.3

Preliminares

¡Haga una copia de seguridad!!!

Migración

Vaya a Administration > Database query y ejecute:

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;

Detener Tomcat
Edite OpenKM.cfg y establezca hibernate.hbm2ddl en update.
Edite OpenKM.xml y modifique

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

por

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

Sustituya el OpenKM.war
Y vuelva a iniciar Tomcat.