Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 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 | 8065295ae255 |
| children | 3fbabd4803d7 |
comparison
equal
deleted
inserted
replaced
| 843:4bae3081eb1e | 844:74608c12b4fe |
|---|---|
| 1400 geometry_type = select geometry_type \ | 1400 geometry_type = select geometry_type \ |
| 1401 from sde.geometry_columns \ | 1401 from sde.geometry_columns \ |
| 1402 where f_table_schema = '?' and \ | 1402 where f_table_schema = '?' and \ |
| 1403 f_table_name = '?' and \ | 1403 f_table_name = '?' and \ |
| 1404 f_geometry_column='SHAPE' | 1404 f_geometry_column='SHAPE' |
| 1405 | |
| 1406 updated_tables = SELECT FULLTABLENAME \ | |
| 1407 FROM MEDIAN.LASTUPDATED \ | |
| 1408 WHERE LASTUPDATE >= to_date('?', 'YYYY.MM.DD HH24:MI:SS') |