# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1312808765 0
# Node ID 61017c6031b8639a45277c53d1940afc58e1f5da
# Parent  2ed77f7e1bab7ead09caab9f76a623eb9d2f328a
Fixed H2 SQL to set TTL of collection.

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

diff -r 2ed77f7e1bab -r 61017c6031b8 ChangeLog
--- a/ChangeLog	Tue Aug 02 14:13:20 2011 +0000
+++ b/ChangeLog	Mon Aug 08 13:06:05 2011 +0000
@@ -1,3 +1,8 @@
+2011-08-08	Sascha L. Teichmann	<teichmann@intevation.de>
+
+	* artifact-database/src/main/resources/sql/org-h2-driver.properties:
+	  Fixed H2 SQL to set TTL of collection.
+
 2011-08-02	Sascha L. Teichmann	<teichmann@intevation.de>
 
 	* artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java:
diff -r 2ed77f7e1bab -r 61017c6031b8 artifact-database/src/main/resources/sql/org-h2-driver.properties
--- a/artifact-database/src/main/resources/sql/org-h2-driver.properties	Tue Aug 02 14:13:20 2011 +0000
+++ b/artifact-database/src/main/resources/sql/org-h2-driver.properties	Mon Aug 08 13:06:05 2011 +0000
@@ -98,7 +98,7 @@
             AND DATEDIFF('MILLISECOND', c.last_access, CURRENT_TIMESTAMP) > c.ttl \
             AND a.id NOT IN ($LOCKED_IDS$)
 
-collections.update.ttl=UPDATE collections SET ttl = ? WHERE id = ?
+collections.update.ttl=UPDATE collections SET ttl = ? WHERE gid = ?
 
 collections.update.name=UPDATE collections SET name = ? WHERE gid = ?