From be3f6f9762dd15177477a7bcf6e11a2e27c70e57 Mon Sep 17 00:00:00 2001
From: unknown <yuanhung@ximple.com.tw>
Date: Mon, 04 Aug 2014 18:16:17 +0800
Subject: [PATCH] bug fix a.error @ geometry column not exist b.error @ drop table
---
xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/DMMSNddUpdateJob.java | 9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)
diff --git a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/DMMSNddUpdateJob.java b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/DMMSNddUpdateJob.java
index c35dcbb..fe42bf4 100644
--- a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/DMMSNddUpdateJob.java
+++ b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/DMMSNddUpdateJob.java
@@ -598,6 +598,15 @@
yy,mm,dd,t0,t1
) ,
new String[]{});
+
+ String strSQLDeletePast="delete ndd.currdata where yy<>'%s' and mm<> '%s' and dd<> '%s' and tt<>'%s%s' where sr=2";
+
+ sqlExec(postsql,
+ String.format(strSQLDeletePast,
+ yy,mm,dd,t0,t1
+ ) ,
+ new String[]{});
+
logger.info(String.format("next xml"));
}
logger.info(String.format("done"));
--
Gitblit v0.0.0-SNAPSHOT