Mercurial > dive4elements > gnv-client
changeset 844:74608c12b4fe
Added Query for the CacheCleaner that it use to determin which Tables has been updated.
gnv-artifacts/trunk@960 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 20 Apr 2010 12:53:00 +0000 |
| parents | 4bae3081eb1e |
| children | 797a6264b89b |
| files | gnv-artifacts/ChangeLog gnv-artifacts/doc/conf/queries.properties |
| diffstat | 2 files changed, 11 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/gnv-artifacts/ChangeLog Tue Apr 20 10:11:28 2010 +0000 +++ b/gnv-artifacts/ChangeLog Tue Apr 20 12:53:00 2010 +0000 @@ -1,3 +1,9 @@ +2010-04-20 Tim Englich <tim.englich@intevation.de> + + * doc/conf/queries.properties: + Added Query for the CacheCleaner that it use to determin which Tables has + been updated. + 2010-04-20 Ingo Weinzierl <ingo.weinzierl@intevation.de> * src/main/java/de/intevation/gnv/state/profile/horizontalcrosssection/HorizontalCrossSectionMeshOutputState.java:
--- a/gnv-artifacts/doc/conf/queries.properties Tue Apr 20 10:11:28 2010 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Tue Apr 20 12:53:00 2010 +0000 @@ -1401,4 +1401,8 @@ from sde.geometry_columns \ where f_table_schema = '?' and \ f_table_name = '?' and \ - f_geometry_column='SHAPE' \ No newline at end of file + f_geometry_column='SHAPE' + +updated_tables = SELECT FULLTABLENAME \ + FROM MEDIAN.LASTUPDATED \ + WHERE LASTUPDATE >= to_date('?', 'YYYY.MM.DD HH24:MI:SS') \ No newline at end of file