From 2beafbe22820de3c47e8c1128452c85ef6aeae33 Mon Sep 17 00:00:00 2001
From: Dennis Kao <ulysseskao@ximple.com.tw>
Date: Fri, 27 Sep 2013 18:06:41 +0800
Subject: [PATCH] update for distid
---
xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/AbstractOracleDatabaseJob.java | 13 +++++++------
1 files changed, 7 insertions(+), 6 deletions(-)
diff --git a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/AbstractOracleDatabaseJob.java b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/AbstractOracleDatabaseJob.java
index 3e1839e..75e8283 100644
--- a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/AbstractOracleDatabaseJob.java
+++ b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/AbstractOracleDatabaseJob.java
@@ -497,16 +497,17 @@
try {
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery(AbstractOracleJobContext.FETCH_TPDATA);
- short disId = rs.getShort(1);
- jobContext.setDistId(disId);
+ if (rs.next()) {
+ short disId = rs.getShort(1);
+ jobContext.setDistId(disId);
- String distName = rs.getString(2);
- jobContext.setDistName(distName);
-
+ String distName = rs.getString(2);
+ jobContext.setDistName(distName);
+ }
rs.close();
stmt.close();
} catch (SQLException e) {
- getLogger().warn("HIBERNATE_SEQUENCE is already exist.");
+ getLogger().warn("Fetch TPDATA Error.", e);
}
}
--
Gitblit v0.0.0-SNAPSHOT