Author: tolusha
Date: 2011-11-17 13:07:48 -0500 (Thu, 17 Nov 2011)
New Revision: 5201
Modified:
jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/clean/rdbms/DBCleanService.java
Log:
EXOJCR-1644: Wrong rollback scripts of the DBCleaner for some DBs: DB2 on
connection.rollback() restores all removed constrains
Modified:
jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/clean/rdbms/DBCleanService.java
===================================================================
---
jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/clean/rdbms/DBCleanService.java 2011-11-17
15:38:50 UTC (rev 5200)
+++
jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/clean/rdbms/DBCleanService.java 2011-11-17
18:07:48 UTC (rev 5201)
@@ -897,8 +897,10 @@
"CONSTRAINT " + constraintName + " FOREIGN KEY(PARENT_ID)
REFERENCES JCR_" + multiDb + "ITEM(ID)";
commitScripts.add("ALTER TABLE JCR_" + multiDb + "ITEM ADD "
+ constraint);
- // PostgreSQL on connection.rollback() restores all removed constrains
- if (!dialect.equalsIgnoreCase(DBConstants.DB_DIALECT_PGSQL))
+ // PostgreSQL, DB2 on connection.rollback() restore all removed constrains
+ if (!dialect.equalsIgnoreCase(DBConstants.DB_DIALECT_PGSQL)
+ && !dialect.equalsIgnoreCase(DBConstants.DB_DIALECT_DB2)
+ && !dialect.equalsIgnoreCase(DBConstants.DB_DIALECT_DB2V8))
{
rollbackScripts.add("ALTER TABLE JCR_" + multiDb + "ITEM ADD
" + constraint);
}
Show replies by date