From 1889b39b6111eb55904195813febadbf77b75e5e Mon Sep 17 00:00:00 2001
From: Dennis Kao <ulysseskao@gmail.com>
Date: Thu, 21 Nov 2013 16:00:48 +0800
Subject: [PATCH] update for color and owner
---
xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs.xml | 8 ++++----
xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleTransformColorOwnerJob.java | 6 ++++--
2 files changed, 8 insertions(+), 6 deletions(-)
diff --git a/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs.xml b/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs.xml
index 722dd12..148770e 100644
--- a/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs.xml
+++ b/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs.xml
@@ -34,11 +34,11 @@
<job-data-map>
<entry>
<key>JOBDATA_DIR</key>
- <value>/Users/Shared/Public/Projects/XGeoDMMS/xjobrun/nntpcjobs/jobdata</value>
+ <value>/Users/Shared/Public/Projects/XGeoDMMS/xjobrun/nstpcjobs/jobdata</value>
</entry>
<entry>
<key>PGHOST</key>
- <value>10.10.1.7</value>
+ <value>10.10.1.9</value>
</entry>
<entry>
<key>PGDATBASE</key>
@@ -62,7 +62,7 @@
</entry>
<entry>
<key>ORAHOST</key>
- <value>10.10.1.7</value>
+ <value>10.10.1.9</value>
</entry>
<entry>
<key>ORAINST</key>
@@ -131,7 +131,7 @@
</entry>
<entry>
<key>GEOSERVER_URL</key>
- <value>http://10.10.1.7:8080/geoserver</value>
+ <value>http://10.10.1.9:8080/geoserver</value>
</entry>
<entry>
<key>GEOSERVER_USER</key>
diff --git a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleTransformColorOwnerJob.java b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleTransformColorOwnerJob.java
index 48b50e5..cad45cd 100644
--- a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleTransformColorOwnerJob.java
+++ b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleTransformColorOwnerJob.java
@@ -290,7 +290,8 @@
StringBuilder sb = new StringBuilder("UPDATE ");
sb.append(schemaName).append(".\"").append(t).append("\"");
sb.append(" SET fowner = ").append(ownerId);
- sb.append(" WHERE oid=").append(oid);
+ sb.append(" WHERE tid=").append(cid);
+ sb.append(" AND oid=").append(oid);
return sb.toString();
}
@@ -373,7 +374,8 @@
StringBuilder sb = new StringBuilder("UPDATE ");
sb.append(schemaName).append(".\"").append(t).append("\"");
sb.append(" SET dyncolor = '").append(colorText).append("'");
- sb.append(" WHERE oid=").append(oid);
+ sb.append(" WHERE tid=").append(cid);
+ sb.append(" AND oid=").append(oid);
return sb.toString();
}
--
Gitblit v0.0.0-SNAPSHOT