Changeset 9874 for trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/metadata/METSStructureSet.java

Timestamp:

2005-05-16T11:02:50+12:00 (19 years ago)

Author:

kjdon

Message:

merged from branch ant-install-branch: merge 1

File:

• trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/metadata/METSStructureSet.java (modified) (2 diffs)

trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/metadata/METSStructureSet.java

@@ -10 +10 @@
 
 import java.sql.SQLException;
+import java.sql.Statement;
 import java.sql.ResultSet;
 
@@ -157 +158 @@
     GS3SQLWhereItem whereItem = new GS3SQLWhereItem("DocID", "=", document.getID().toString());
     select.setWhere(new GS3SQLWhere(whereItem));
-    connection.execute(select.toString());
-
+    
     // start going through the matching metadata blocks
     try {
-        ResultSet resultSet = connection.getResultSet();
-        resultSet.first();
-        do {
-        METSStructure structure = METSStructure.readSQL(document, connection, resultSet);
-        if (structure != null) {
-            set.addStructure(structure);
-        }
-        } while (resultSet.next());
+        Statement statement = connection.createStatement();
+        ResultSet resultSet = statement.executeQuery(select.toString());
+        if (resultSet.first()) {
+        do {
+            METSStructure structure = METSStructure.readSQL(document, connection, resultSet);
+            if (structure != null) {
+            set.addStructure(structure);
+            }
+        } while (resultSet.next());
+        }
+        statement.close();
     }
     catch (SQLException sqlEx) {
-        System.out.println(sqlEx);
+        System.err.println("METSStructureSet.readSQL(): "+sqlEx);
         System.exit(1);
     }