From 88441292e5b8829a1c1c550cd2c2146962f59582 Mon Sep 17 00:00:00 2001
From: ?? ? <ulysseskao@ximple.com.tw>
Date: Wed, 27 Aug 2008 11:51:13 +0800
Subject: [PATCH] update for EOFM-152
---
xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2PostGISJob.java | 26 +++++++++++++-------------
1 files changed, 13 insertions(+), 13 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 0e67575..8bf847e 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
@@ -1166,7 +1166,7 @@
try
{
connection = targetDataStore.getConnection(Transaction.AUTO_COMMIT);
- rs = connection.getMetaData().getTables(null, _pgSchema, DataRepositoryVersionManger.XGVERSIONTABLE_NAME, new String[] {"TABLE"});
+ rs = connection.getMetaData().getTables(null, _pgSchema, DataReposVersionManager.XGVERSIONTABLE_NAME, new String[] {"TABLE"});
if (!rs.next()) needCreate = true;
if (needCreate)
createXGeosVersionTable(connection, _pgSchema);
@@ -1175,7 +1175,7 @@
StringBuilder sbSQL = new StringBuilder("SELECT ");
sbSQL.append("vsschema, vsstatus FROM ");
- sbSQL.append(encodeSchemaTableName(_pgSchema, DataRepositoryVersionManger.XGVERSIONTABLE_NAME)).append(' ');
+ sbSQL.append(encodeSchemaTableName(_pgSchema, DataReposVersionManager.XGVERSIONTABLE_NAME)).append(' ');
sbSQL.append("ORDER BY vsid");
stmt = connection.createStatement();
rs = stmt.executeQuery(sbSQL.toString());
@@ -1188,7 +1188,7 @@
values[0] = rs.getString("vsschema");
values[1] = rs.getShort("vsstatus");
tmpSchemas.add(values);
- if ((((Short)values[1]) & DataRepositoryVersionManger.VSSTATUS_USING) != 0)
+ if ((((Short)values[1]) & DataReposVersionManager.VSSTATUS_USING) != 0)
{
current = i;
}
@@ -1209,9 +1209,9 @@
}
sbSQL = new StringBuilder("UPDATE ");
- sbSQL.append(encodeSchemaTableName(_pgSchema, DataRepositoryVersionManger.XGVERSIONTABLE_NAME)).append(' ');
+ sbSQL.append(encodeSchemaTableName(_pgSchema, DataReposVersionManager.XGVERSIONTABLE_NAME)).append(' ');
sbSQL.append(" SET vsstatus = ");
- sbSQL.append(DataRepositoryVersionManger.VSSTATUS_COVERT);
+ sbSQL.append(DataReposVersionManager.VSSTATUS_COVERT);
sbSQL.append(" WHERE vsschema = '");
sbSQL.append(targetSchema).append("'");
int count = stmt.executeUpdate(sbSQL.toString());
@@ -1239,7 +1239,7 @@
{
Statement stmt = null;
StringBuilder sql = new StringBuilder("CREATE TABLE ");
- sql.append(encodeSchemaTableName(pgSchema, DataRepositoryVersionManger.XGVERSIONTABLE_NAME));
+ sql.append(encodeSchemaTableName(pgSchema, DataReposVersionManager.XGVERSIONTABLE_NAME));
sql.append(" ( vsid serial PRIMARY KEY, ");
sql.append(" vsschema character varying(64) NOT NULL, ");
sql.append(" vsstatus smallint NOT NULL, ");
@@ -1250,22 +1250,22 @@
stmt.executeUpdate(sql.toString());
sql = new StringBuilder("ALTER TABLE ");
- sql.append(encodeSchemaTableName(pgSchema, DataRepositoryVersionManger.XGVERSIONTABLE_NAME));
+ sql.append(encodeSchemaTableName(pgSchema, DataReposVersionManager.XGVERSIONTABLE_NAME));
sql.append(" OWNER TO spatialdb");
stmt.executeUpdate(sql.toString());
sql = new StringBuilder("GRANT ALL ON TABLE ");
- sql.append(encodeSchemaTableName(pgSchema, DataRepositoryVersionManger.XGVERSIONTABLE_NAME));
+ sql.append(encodeSchemaTableName(pgSchema, DataReposVersionManager.XGVERSIONTABLE_NAME));
sql.append(" TO public");
stmt.executeUpdate(sql.toString());
- for (String schemaName : DataRepositoryVersionManger.DEFAULTXGVERSIONSCHEMA_NAMES)
+ for (String schemaName : DataReposVersionManager.DEFAULTXGVERSIONSCHEMA_NAMES)
{
sql = new StringBuilder("INSERT INTO ");
- sql.append(encodeSchemaTableName(pgSchema, DataRepositoryVersionManger.XGVERSIONTABLE_NAME));
+ sql.append(encodeSchemaTableName(pgSchema, DataReposVersionManager.XGVERSIONTABLE_NAME));
sql.append(" (vsschema, vsstatus) VALUES ('");
sql.append(schemaName).append("', ");
- sql.append(DataRepositoryVersionManger.VSSTATUS_UNKNOWN).append(" )");
+ sql.append(DataReposVersionManager.VSSTATUS_UNKNOWN).append(" )");
stmt.executeUpdate(sql.toString());
createIfNotExistNewSchema(connection, schemaName);
@@ -1286,9 +1286,9 @@
try
{
StringBuilder sbSQL = new StringBuilder("UPDATE ");
- sbSQL.append(encodeSchemaTableName(_pgSchema, DataRepositoryVersionManger.XGVERSIONTABLE_NAME)).append(' ');
+ sbSQL.append(encodeSchemaTableName(_pgSchema, DataReposVersionManager.XGVERSIONTABLE_NAME)).append(' ');
sbSQL.append(" SET vsstatus = ");
- sbSQL.append(DataRepositoryVersionManger.VSSTATUS_READY);
+ sbSQL.append(DataReposVersionManager.VSSTATUS_READY);
sbSQL.append(" WHERE vsschema = '");
sbSQL.append(targetSchema).append("'");
--
Gitblit v0.0.0-SNAPSHOT