forked from geodmms/xdgnjobs

unknown
2014-08-22 b41029f6b31913bf67c72fd0743c106cd6c117e8
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);