From 48add6d667065ac8d50ef3fc70bfae4e78e3620f Mon Sep 17 00:00:00 2001
From: Dennis Kao <ulysseskao@gmail.com>
Date: Sun, 04 May 2014 01:03:19 +0800
Subject: [PATCH] fix bug
---
xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2PostGISJob.java | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2PostGISJob.java b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2PostGISJob.java
index 93b1a89..e8cd4c9 100644
--- a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2PostGISJob.java
+++ b/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 {
--
Gitblit v0.0.0-SNAPSHOT