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-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleTransformColorOwnerJob.java | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
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