# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1253783756 0
# Node ID b8516aa3d8a10ec2ad107cbb670f9e4bb36ad7c0
# Parent  5fbd8e65bdf55e70aeb375e7687bded6ea4de23a
Time delta calculation in SQL statement to figure out outdated artifacts
in H2 database was broken.


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

diff -r 5fbd8e65bdf5 -r b8516aa3d8a1 Changelog
--- a/Changelog	Thu Sep 24 08:45:23 2009 +0000
+++ b/Changelog	Thu Sep 24 09:15:56 2009 +0000
@@ -1,3 +1,9 @@
+2009-09-24	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* artifact-database/src/main/resources/sql/org-h2-driver.properties:
+	Time delta calculation in SQL statement to figure out outdated artifacts
+	was broken.
+
 2009-09-24	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* artifact-database/src/main/java/de/intevation/artifactdatabase/DefaultArtifact.java:
diff -r 5fbd8e65bdf5 -r b8516aa3d8a1 artifact-database/src/main/resources/sql/org-h2-driver.properties
--- a/artifact-database/src/main/resources/sql/org-h2-driver.properties	Thu Sep 24 08:45:23 2009 +0000
+++ b/artifact-database/src/main/resources/sql/org-h2-driver.properties	Thu Sep 24 09:15:56 2009 +0000
@@ -10,7 +10,7 @@
 artifacts.touch=UPDATE artifacts SET last_access = CURRENT_TIMESTAMP WHERE id = ?
 
 artifacts.outdated=SELECT id, factory, data FROM artifacts WHERE ttl IS NOT NULL \
-    AND CURRENT_TIMESTAMP - last_access > ttl LIMIT 50
+    AND DATEDIFF('MILLISECOND', last_access, CURRENT_TIMESTAMP) > ttl LIMIT 50
 
 artifacts.select.gid=SELECT id, last_access, ttl, factory, data FROM artifacts WHERE gid = ?