From aa92e40672e9ea2a6b55f528d5b986314d652a40 Mon Sep 17 00:00:00 2001
From: ?? ? <ulysseskao@ximple.com.tw>
Date: Mon, 16 Jun 2008 09:55:37 +0800
Subject: [PATCH] update for EOFM-122

---
 xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2OraSDOJob.java |   14 +++++---------
 1 files changed, 5 insertions(+), 9 deletions(-)

diff --git a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2OraSDOJob.java b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2OraSDOJob.java
index 8b1e3bf..3de3389 100644
--- a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2OraSDOJob.java
+++ b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2OraSDOJob.java
@@ -72,7 +72,6 @@
     private static final String USEWKB = "USEWKB";
 
     private static final int FETCHSIZE = 30;
-    private static final int BATCHSIZE = 25;
     private static final int COMMITSIZE = 20;
 
     class Pair
@@ -362,10 +361,9 @@
         try
         {
             rs = stmt.executeQuery(fetchStmt);
-
+            int size = rs.getMetaData().getColumnCount();
             while (rs.next())
             {
-                int size = rs.getMetaData().getColumnCount();
                 Object[] values = new Object[size];
 
                 for (int i = 0; i < size; i++)
@@ -409,10 +407,9 @@
         stmt.setFetchSize(FETCHSIZE);
 
         ResultSet rs = stmt.executeQuery(fetchStmt);
-
+        int size = rs.getMetaData().getColumnCount();
         while (rs.next())
         {
-            int size = rs.getMetaData().getColumnCount();
             Object[] values = new Object[size];
 
             for (int i = 0; i < size; i++)
@@ -448,12 +445,11 @@
         stmtSrc.setFetchSize(FETCHSIZE);
 
         ResultSet rsSrc = stmtSrc.executeQuery(fetchSrcStmt);
-
+        int igdsMetaType = rsSrc.getMetaData().getColumnType(1);
         while (rsSrc.next())
         {
-            byte[] raw = null;
-
-            if (rsSrc.getMetaData().getColumnType(1) == Types.BLOB)
+            byte[] raw;
+            if (igdsMetaType == Types.BLOB)
             {
                 BLOB blob = (BLOB) rsSrc.getBlob(1);
 

--
Gitblit v0.0.0-SNAPSHOT