From 48add6d667065ac8d50ef3fc70bfae4e78e3620f Mon Sep 17 00:00:00 2001
From: Dennis Kao <ulysseskao@gmail.com>
Date: Sun, 04 May 2014 01:03:19 +0800
Subject: [PATCH] fix bug
---
xdgnjobs/ximple-jobcarrier/quartz.properties | 3 ++-
xdgnjobs/ximple-jobcarrier/src/main/resources/quartz.properties | 4 ++--
xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2PostGISJob.java | 3 ++-
xdgnjobs/ximple-jobcarrier/quartz_jobs_colowner.xml | 8 ++++----
xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs_colowner.xml | 8 ++++----
5 files changed, 14 insertions(+), 12 deletions(-)
diff --git a/xdgnjobs/ximple-jobcarrier/quartz.properties b/xdgnjobs/ximple-jobcarrier/quartz.properties
index 132f0f6..59577df 100644
--- a/xdgnjobs/ximple-jobcarrier/quartz.properties
+++ b/xdgnjobs/ximple-jobcarrier/quartz.properties
@@ -24,10 +24,11 @@
org.quartz.plugin.jobInitializer.class: org.quartz.plugins.xml.XMLSchedulingDataProcessorPlugin
#org.quartz.plugin.jobInitializer.fileNames = quartz_jobs_dmmsroadfee.xml
-org.quartz.plugin.jobInitializer.fileNames = quartz_jobs.xml
+#org.quartz.plugin.jobInitializer.fileNames = quartz_jobs.xml
#org.quartz.plugin.jobInitializer.fileNames = quartz_jobs_inc.xml
#org.quartz.plugin.jobInitializer.fileNames = quartz_jobs_edb.xml
#org.quartz.plugin.jobInitializer.fileNames = quartz_jobs_colowner.xml
+org.quartz.plugin.jobInitializer.fileNames = quartz_jobs_resetview.xml
org.quartz.plugin.jobInitializer.failOnFileNotFound = true
org.quartz.plugin.jobInitializer.scanInterval = 10
diff --git a/xdgnjobs/ximple-jobcarrier/quartz_jobs_colowner.xml b/xdgnjobs/ximple-jobcarrier/quartz_jobs_colowner.xml
index 30d36a9..9db802d 100644
--- a/xdgnjobs/ximple-jobcarrier/quartz_jobs_colowner.xml
+++ b/xdgnjobs/ximple-jobcarrier/quartz_jobs_colowner.xml
@@ -30,12 +30,12 @@
<job-data-map>
<entry>
<key>JOBDATA_DIR</key>
- <value>/Users/ulysseskao/Projects/XGeoDMMS/xjobrun/tctpcjobs/jobdata</value>
+ <value>/Users/ulysseskao/Projects/XGeoDMMS/xjobrun/nntpcjobs/jobdata</value>
<!--value>/mnt/hdisk/home.data/private/projects/xdcad/xjobrun/nntpcjobs/jobdata</value-->
</entry>
<entry>
<key>PGHOST</key>
- <value>10.10.1.17</value>
+ <value>10.10.1.19</value>
</entry>
<entry>
<key>PGDATBASE</key>
@@ -59,7 +59,7 @@
</entry>
<entry>
<key>ORAHOST</key>
- <value>10.10.1.17</value>
+ <value>10.10.1.19</value>
</entry>
<entry>
<key>ORAINST</key>
@@ -75,7 +75,7 @@
</entry>
<entry>
<key>ORAPASS</key>
- <value>simple000</value>
+ <value>SYSTEM000</value>
</entry>
<entry>
<key>ORGSCHEMA</key>
diff --git a/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz.properties b/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz.properties
index b638d69..9017116 100644
--- a/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz.properties
+++ b/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz.properties
@@ -24,10 +24,10 @@
org.quartz.plugin.jobInitializer.class = org.quartz.plugins.xml.XMLSchedulingDataProcessorPlugin
-org.quartz.plugin.jobInitializer.fileNames = quartz_jobs.xml
+#org.quartz.plugin.jobInitializer.fileNames = quartz_jobs.xml
#org.quartz.plugin.jobInitializer.fileNames = quartz_jobs_inc.xml
#org.quartz.plugin.jobInitializer.fileNames = quartz_jobs_edb.xml
-#org.quartz.plugin.jobInitializer.fileNames = quartz_jobs_colowner.xml
+org.quartz.plugin.jobInitializer.fileNames = quartz_jobs_colowner.xml
#org.quartz.plugin.jobInitializer.fileNames = quartz_jobs_dmmsroadfee.xml
org.quartz.plugin.jobInitializer.failOnFileNotFound = true
diff --git a/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs_colowner.xml b/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs_colowner.xml
index 30d36a9..9db802d 100644
--- a/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs_colowner.xml
+++ b/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs_colowner.xml
@@ -30,12 +30,12 @@
<job-data-map>
<entry>
<key>JOBDATA_DIR</key>
- <value>/Users/ulysseskao/Projects/XGeoDMMS/xjobrun/tctpcjobs/jobdata</value>
+ <value>/Users/ulysseskao/Projects/XGeoDMMS/xjobrun/nntpcjobs/jobdata</value>
<!--value>/mnt/hdisk/home.data/private/projects/xdcad/xjobrun/nntpcjobs/jobdata</value-->
</entry>
<entry>
<key>PGHOST</key>
- <value>10.10.1.17</value>
+ <value>10.10.1.19</value>
</entry>
<entry>
<key>PGDATBASE</key>
@@ -59,7 +59,7 @@
</entry>
<entry>
<key>ORAHOST</key>
- <value>10.10.1.17</value>
+ <value>10.10.1.19</value>
</entry>
<entry>
<key>ORAINST</key>
@@ -75,7 +75,7 @@
</entry>
<entry>
<key>ORAPASS</key>
- <value>simple000</value>
+ <value>SYSTEM000</value>
</entry>
<entry>
<key>ORGSCHEMA</key>
diff --git a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2PostGISJob.java b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2PostGISJob.java
index 93b1a89..e8cd4c9 100644
--- a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2PostGISJob.java
+++ b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2PostGISJob.java
@@ -1939,7 +1939,8 @@
}
} else {
stmt.execute("TRUNCATE "+ tableName + " CASCADE");
- stmt.execute("SELECT * INTO " + tableName + " FROM " + tempTable);
+ // stmt.execute("SELECT * INTO " + tableName + " FROM " + tempTable);
+ stmt.execute("INSERT INTO " + tableName + " SELECT * FROM " + tempTable);
}
stmt.execute("DROP TABLE " + tempTable);
} finally {
--
Gitblit v0.0.0-SNAPSHOT