Changeset 9850

Timestamp:

2005-05-10T15:51:29+12:00 (19 years ago)

Author:

kjdon

Message:

cloned the connection for processing each document

File:

• branches/ant-install-branch/gsdl3/src/java/org/greenstone/gsdl3/gs3build/doctypes/DocumentList.java (modified) (1 diff)

branches/ant-install-branch/gsdl3/src/java/org/greenstone/gsdl3/gs3build/doctypes/DocumentList.java

@@ -456 +456 @@
     ResultSet documents;
     try {
-      connection.execute(select.toString());
-      documents = connection.getResultSet();
-
-      if (documents.first())
-      { do
-    { DocumentInterface document = AbstractDocument.readSQL(connection, documents);
-          list.addDocument(document);
-    }
-    while (documents.next());
-      }
-    }
-    catch (java.sql.SQLException ex)
-    { System.out.println(ex);
-      return null;
+    connection.execute(select.toString());
+    documents = connection.getResultSet();
+
+      
+    if (documents.first()) { 
+        // clone the connection cos we are still usign the old result set
+        GS3SQLConnection cloned_connection = connection.cloneConnection();
+        
+        do {
+        DocumentInterface document = AbstractDocument.readSQL(cloned_connection, documents);
+        list.addDocument(document);
+        }
+        while (documents.next());
+        cloned_connection.close();
+        cloned_connection = null;
+    }
+    }
+    catch (java.sql.SQLException ex) {
+    System.out.println(ex);
+    ex.printStackTrace();
+    return null;
     }