Changeset 8771

Timestamp:

2004-12-09T16:30:32+13:00 (19 years ago)

Author:

schweer

Message:

bugfix; calling getString() without calling next() before that results in an SQLException...

File:

• trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/notifier/NotifierManager.java (modified) (2 diffs)

trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/notifier/NotifierManager.java

@@ -153 +153 @@
     private String getDocumentTitle(String documentID, GS3SQLConnection database) {
         Statement statement = database.createStatement();
+
         ResultSet results;
         try {
@@ -166 +167 @@
                     "                                 AND m.docID = s.docid;";
             results = statement.executeQuery(sqlString);
-            return results.getString(0);
+            if (results.next()) {
+                return results.getString(0);
+            }
         } catch (SQLException e) {
-            return "";
         }
+        return "";
     }