changeset 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 2ed77f7e1bab
children b46c5b13ac94
files ChangeLog artifact-database/src/main/resources/sql/org-h2-driver.properties
diffstat 2 files changed, 6 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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:
--- 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