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/OracleConvertDgn2ShpJob.java |   11 +++++------
 1 files changed, 5 insertions(+), 6 deletions(-)

diff --git a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2ShpJob.java b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2ShpJob.java
index 35a4de6..6e62e7a 100644
--- a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2ShpJob.java
+++ b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2ShpJob.java
@@ -264,10 +264,10 @@
         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++)
@@ -309,12 +309,11 @@
         Statement stmt = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
 
         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++)
@@ -350,12 +349,12 @@
         stmtSrc.setFetchSize(FETCHSIZE);
 
         ResultSet rsSrc = stmtSrc.executeQuery(fetchSrcStmt);
-
+        int igdsMetaType = rsSrc.getMetaData().getColumnType(1);
         while (rsSrc.next())
         {
-            byte[] raw = null;
+            byte[] raw;
 
-            if (rsSrc.getMetaData().getColumnType(1) == Types.BLOB)
+            if (igdsMetaType == Types.BLOB)
             {
                 BLOB blob = (BLOB) rsSrc.getBlob(1);
 

--
Gitblit v0.0.0-SNAPSHOT