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

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

@@ -19 +19 @@
     update.addDate("IndexedDate", new java.sql.Timestamp(touchTime));
     update.addDate("ModifiedDate", new java.sql.Timestamp(modTime));
-    connection.execute(update.toString());
+    try {
+    Statement statement = connection.createStatement();
+    statement.execute(update.toString());
+    statement.close();
+    } catch (SQLException e) {
+    System.err.println("DocumentSQLWriter.touchDocument() Error: "+ e);
+    return false;
+    }
     System.out.println(update.toString());
     return true;
@@ -39 +46 @@
     select.addField("*");
     select.setWhere(new GS3SQLWhere(new GS3SQLWhereItem("DocID", "=", document.getID().toString())));
-    connection.execute(select.toString());
     
-    ResultSet results = connection.getResultSet();
-
-    if (results == null ||
-        !results.first())
-    { GS3SQLInsert insert = new GS3SQLInsert("document");
+    Statement statement = connection.createStatement();
+    ResultSet results = statement.executeQuery(select.toString());
+    if (!results.first()) { // empty result
+      GS3SQLInsert insert = new GS3SQLInsert("document");
       insert.addValue("DocID", document.getID().toString());
       insert.addValue("DocType", document.getDocumentType());
@@ -53 +58 @@
       insert.addDate("ModifiedDate", new java.sql.Timestamp(document.getModifiedDatestamp()));
 
-      connection.execute(insert.toString());
+      statement.execute(insert.toString());
     }
     else {
@@ -61 +66 @@
       //      connection.execute(update.toString());
     }
+    statement.close();
       }
-    } catch (Exception ex) {
-    System.out.println(ex);
+    } catch (SQLException ex) {
+    System.out.println("DocumentSQLWriter.writeDocument() Error:"+ex);
     }
     //    output.println(tag);