forked from geodmms/xdgnjobs

Dennis Kao
2014-05-04 48add6d667065ac8d50ef3fc70bfae4e78e3620f
fix bug
5 files modified
26 ■■■■ changed files
xdgnjobs/ximple-jobcarrier/quartz.properties 3 ●●●● patch | view | raw | blame | history
xdgnjobs/ximple-jobcarrier/quartz_jobs_colowner.xml 8 ●●●● patch | view | raw | blame | history
xdgnjobs/ximple-jobcarrier/src/main/resources/quartz.properties 4 ●●●● patch | view | raw | blame | history
xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs_colowner.xml 8 ●●●● patch | view | raw | blame | history
xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2PostGISJob.java 3 ●●●● patch | view | raw | blame | history
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
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>
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
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>
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 {