From 6dad7ef53ebc83b4dc81af67079f3290c27fca98 Mon Sep 17 00:00:00 2001
From: ?? ? <neonhuang@hotmail.com>
Date: Thu, 10 Apr 2008 21:01:10 +0800
Subject: [PATCH]
---
xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/AbstractOracleJobContext.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/AbstractOracleJobContext.java b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/AbstractOracleJobContext.java
index 1cf6f27..4be207f 100644
--- a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/AbstractOracleJobContext.java
+++ b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/AbstractOracleJobContext.java
@@ -170,6 +170,35 @@
+ " SET XLOW = :new.XLOW, YLOW = :new.YLOW, XHIGH = :new.XHIGH, YHIGH = :new.YHIGH\n"
+ " WHERE FSC = :new.FSC AND UFID = :new.UFID AND COMPID = :new.COMPID AND OCCID = :new.OCCID;\n"
+ " END IF;\n" + " END;";
+
+ /**
+ * copy connectivity to connectivity_webcheck sql
+ */
+ protected static final String TRUNCATE_CONNECTIVITY_WEBCHECK = "TRUNCATE TABLE BASEDB.CONNECTIVITY_WEBCHECK";
+ protected static final String CREATE_CONNECTIVITY_WEBCHECK = "CREATE TABLE BASEDB.CONNECTIVITY_WEBCHECK\n" +
+ "( FSC NUMBER(5) NOT NULL," +
+ " UFID NUMBER(10) NOT NULL," +
+ " N1 NUMBER(10)," +
+ " N2 NUMBER(10)," +
+ " FDR1 NUMBER(5)," +
+ " FDR2 NUMBER(5)," +
+ " DIR NUMBER(3)," +
+ " OHUG NUMBER(3)," +
+ " OSTATUS NUMBER(3)," +
+ " PHASE NUMBER(3)," +
+ " X NUMBER(10,3) NOT NULL," +
+ " Y NUMBER(10,3) NOT NULL" +
+ ")\n" +
+ "TABLESPACE BASE_DATA PCTUSED 40 PCTFREE 10 INITRANS 1 MAXTRANS 255\n" +
+ "STORAGE (INITIAL 19120K MINEXTENTS 1 MAXEXTENTS 2147483645 \n" +
+ "PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT )\n" +
+ "LOGGING NOCOMPRESS NOCACHE NOPARALLEL MONITORING;";
+
+ protected static final String COPY_CONNECTIVITY_TO_WEBCHECK = "INSERT /*+ APPEND */ INTO BASEDB.CONNECTIVITY_WEBCHECK\n" +
+ "(FSC, UFID, N1, N2, FDR1, FDR2, DIR, OHUG,OSTATUS, PHASE, X, Y)\n" +
+ "SELECT FSC, UFID, N1, N2, FDR1, FDR2, DIR, OHUG, OSTATUS, PHASE, X, Y FROM BASEDB.CONNECTIVITY ";
+
+
/**
*
*/
--
Gitblit v0.0.0-SNAPSHOT