From df3eeecca134aa3199f9a111e67da9e213e10e18 Mon Sep 17 00:00:00 2001
From: ?? ? <ulysseskao@ximple.com.tw>
Date: Tue, 04 May 2010 11:29:37 +0800
Subject: [PATCH] support edb
---
xdgnjobs/ximple-jobcarrier/pom.xml | 3 ++-
xdgnjobs/ximple-jobcarrier/src/main/resources/quartz.properties | 2 +-
xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs_edb.xml | 2 +-
xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2EdbGeoJob.java | 11 +++++++++--
4 files changed, 13 insertions(+), 5 deletions(-)
diff --git a/xdgnjobs/ximple-jobcarrier/pom.xml b/xdgnjobs/ximple-jobcarrier/pom.xml
index fffc6a9..08cdc08 100644
--- a/xdgnjobs/ximple-jobcarrier/pom.xml
+++ b/xdgnjobs/ximple-jobcarrier/pom.xml
@@ -290,8 +290,9 @@
<includes>
<include>log4j.properties</include>
<include>quartz.properties</include>
- <!--<include>quartz_jobs.xml</include>-->
+ <include>quartz_jobs.xml</include>
<include>quartz_jobs_edb.xml</include>
+ <include>quartz_jobs_sharpefiles.xml</include>
</includes>
<!--
<excludes>
diff --git a/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz.properties b/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz.properties
index 9a605e9..f91a64f 100644
--- a/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz.properties
+++ b/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz.properties
@@ -25,7 +25,7 @@
#org.quartz.plugin.jobInitializer.class = org.quartz.plugins.xml.JobInitializationPlugin
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_edb.xml
#org.quartz.plugin.jobInitializer.overWriteExistingJobs = true
org.quartz.plugin.jobInitializer.failOnFileNotFound = true
diff --git a/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs_edb.xml b/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs_edb.xml
index e37fb37..623bced 100644
--- a/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs_edb.xml
+++ b/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs_edb.xml
@@ -32,7 +32,7 @@
<job-data-map>
<entry>
<key>JOBDATA_DIR</key>
- <value>C:\Usr\Projects\XDCAD\nstpcjobs</value>
+ <value>C:\Usr\Projects\XDCAD\nstpcjobs\jobdata</value>
</entry>
<entry>
<key>EDBHOST</key>
diff --git a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2EdbGeoJob.java b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2EdbGeoJob.java
index 69633a4..a021f70 100644
--- a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2EdbGeoJob.java
+++ b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2EdbGeoJob.java
@@ -1230,11 +1230,18 @@
connection = targetDataStore.getConnection(Transaction.AUTO_COMMIT);
rs = connection.getMetaData().getTables(null, _edbSchema, DataReposVersionManager.XGVERSIONTABLE_NAME, new String[]{"TABLE"});
if (!rs.next()) needCreate = true;
- if (needCreate)
- createXGeosVersionTable(connection, _edbSchema);
rs.close();
rs = null;
+ stmt = connection.createStatement();
+ stmt.execute("SET edb_redwood_date TO OFF");
+ stmt.execute("SET edb_redwood_strings TO OFF");
+ // stmt.execute("SET edb_stmt_level_tx TO OFF");
+ stmt.close();
+
+ if (needCreate)
+ createXGeosVersionTable(connection, _edbSchema);
+
StringBuilder sbSQL = new StringBuilder("SELECT ");
sbSQL.append("vsschema, vsstatus FROM ");
sbSQL.append(encodeSchemaTableName(_edbSchema, DataReposVersionManager.XGVERSIONTABLE_NAME)).append(' ');
--
Gitblit v0.0.0-SNAPSHOT