# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1302692265 0
# Node ID 4253995c970ea902bf13884958070aeda7bf84eb
# Parent  c0bc172ec7b2148df5eff450d9b5088d08810495
Fix for flys/issue8 (part 3)


artifacts/trunk@1676 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r c0bc172ec7b2 -r 4253995c970e ChangeLog
--- a/ChangeLog	Tue Apr 12 07:51:42 2011 +0000
+++ b/ChangeLog	Wed Apr 13 10:57:45 2011 +0000
@@ -1,3 +1,10 @@
+2011-04-13	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	Fix for flys/issue8 (part 3)
+
+	* artifact-database/src/main/java/de/intevation/artifactdatabase/DatabaseCleaner.java:
+	  'NOT IN (NULL)' does not work. Used 'NOT IN (-666)' instead.
+
 2011-04-12  Ingo Weinzierl <ingo@intevation.de>
 
 	* artifacts-common/src/main/java/de/intevation/artifacts/common/utils/ClientProtocolUtils.java:
diff -r c0bc172ec7b2 -r 4253995c970e artifact-database/src/main/java/de/intevation/artifactdatabase/DatabaseCleaner.java
--- a/artifact-database/src/main/java/de/intevation/artifactdatabase/DatabaseCleaner.java	Tue Apr 12 07:51:42 2011 +0000
+++ b/artifact-database/src/main/java/de/intevation/artifactdatabase/DatabaseCleaner.java	Wed Apr 13 10:57:45 2011 +0000
@@ -237,7 +237,7 @@
             : EMPTY_IDS;
 
         String questionMarks = lockedIds.isEmpty()
-            ? "NULL"
+            ? "-666" // XXX: A bit hackish.
             : StringUtils.repeat('?', lockedIds.size(), ',');
 
         try {