Changeset 9874 for trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/doctypes/DocumentFactory.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/doctypes/DocumentFactory.java (modified) (2 diffs)

trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/doctypes/DocumentFactory.java

@@ -2 +2 @@
 
 import java.sql.SQLException;
+import java.sql.Statement;
 import java.sql.ResultSet;
 import java.net.URL;
@@ -61 +62 @@
   {
     String query = "SELECT * FROM document WHERE DocID=\""+id.toString()+"\";";
-    connection.execute(query);
-
     try {
-      ResultSet results = connection.getResultSet();
-      if (results != null && results.first()) {
-    return AbstractDocument.readSQL(connection, results);
-      }
+    Statement statement = connection.createStatement();
+    ResultSet results = statement.executeQuery(query);
+    
+    DocumentInterface di = null;
+    if (results.first()) {
+        di = AbstractDocument.readSQL(connection, results);
+    }
+    statement.close();
+    return di;
     }
     catch (SQLException sqlEx) {
-      System.err.println(sqlEx);
+      System.err.println("AbstractDocument.readSQLDocument():"+sqlEx);
     }
     return null;