Author: tolusha
Date: 2011-11-21 02:08:51 -0500 (Mon, 21 Nov 2011)
New Revision: 5202
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: MSSQL 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
18:07:48 UTC (rev 5201)
+++
jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/clean/rdbms/DBCleanService.java 2011-11-21
07:08:51 UTC (rev 5202)
@@ -900,7 +900,8 @@
// 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))
+ && !dialect.equalsIgnoreCase(DBConstants.DB_DIALECT_DB2V8)
+ && !dialect.equalsIgnoreCase(DBConstants.DB_DIALECT_MSSQL))
{
rollbackScripts.add("ALTER TABLE JCR_" + multiDb + "ITEM ADD
" + constraint);
}
Show replies by date