From b41029f6b31913bf67c72fd0743c106cd6c117e8 Mon Sep 17 00:00:00 2001
From: unknown <yuanhung@ximple.com.tw>
Date: Fri, 22 Aug 2014 14:28:27 +0800
Subject: [PATCH] release tpc0822
---
xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2PostGISJob.java | 6 +++---
1 files changed, 3 insertions(+), 3 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 01b045e..dcf49bf 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
@@ -1704,7 +1704,7 @@
try {
rs = connection.getMetaData().getTables(null, _pgSchema, tableName, new String[]{"TABLE"});
if (rs.next()) {
- stmt.execute("DROP TABLE " + encodeSchemaTableName(_pgSchema, tableName) + "CASCADE");
+ stmt.execute("DROP TABLE " + encodeSchemaTableName(_pgSchema, tableName) + " CASCADE");
}
stmt.executeUpdate("CREATE TABLE " + encodeSchemaTableName(_pgSchema, tableName) + " " + sql);
@@ -1900,7 +1900,7 @@
try {
rs = connection.getMetaData().getTables(null, null, tableName, new String[]{"TABLE"});
if (rs.next()) {
- stmt.execute("DROP TABLE " + encodeSchemaTableName(null, tableName) + "CASCADE");
+ stmt.execute("DROP TABLE " + encodeSchemaTableName(null, tableName) + " CASCADE");
}
stmt.executeUpdate("CREATE TEMP TABLE " + encodeSchemaTableName(null, tableName) + " " + sql);
@@ -1933,7 +1933,7 @@
// stmt.execute("SELECT * INTO " + tableName + " FROM " + tempTable);
stmt.execute("INSERT INTO " + tableName + " SELECT * FROM " + tempTable);
}
- stmt.execute("DROP TABLE " + tempTable);
+ stmt.execute("DROP TABLE " + tempTable + " CASCADE");
} finally {
JDBCUtils.close(rs);
JDBCUtils.close(stmt);
--
Gitblit v0.0.0-SNAPSHOT