diff artifact-database/src/main/resources/sql/org-h2-driver.properties @ 319:61017c6031b8

Fixed H2 SQL to set TTL of collection. artifacts/trunk@2467 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 08 Aug 2011 13:06:05 +0000
parents 824051dff018
children b46c5b13ac94
line wrap: on
line diff
--- 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 = ?
 

http://dive4elements.wald.intevation.org