forked from geodmms/xdgnjobs

Dennis Kao
2013-11-21 1889b39b6111eb55904195813febadbf77b75e5e
update for color and owner
2 files modified
14 ■■■■■ changed files
xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs.xml 8 ●●●● patch | view | raw | blame | history
xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleTransformColorOwnerJob.java 6 ●●●●● patch | view | raw | blame | history
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>
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();
    }