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

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

@@ -6 +6 @@
 import java.util.Iterator;
 import java.sql.SQLException;
+import java.sql.Statement;
 import java.sql.ResultSet;
 
@@ -150 +151 @@
 
     // Execute the action
-    connection.execute(action.toString());
-
+    Statement statement = null;
+    try {
+        statement = connection.createStatement();
+        statement.execute(action.toString());
+    } catch (SQLException e) {
+        System.err.println("METSNamespace.writeSQL(): "+e);
+        return false;
+    }
     // then get the namespace reference number if needsbe...
     if (this.id == null) {
@@ -161 +168 @@
         where.add(where);
         try {
-        connection.execute(select.toString());
-      
-        ResultSet result = connection.getResultSet();
-        result.last();
-        this.id = Integer.toString(result.getInt("NamespaceRef"));
+        ResultSet result  = statement.executeQuery(select.toString());
+            if (result.last()) {
+            this.id = Integer.toString(result.getInt("NamespaceRef"));
+        }
+        statement.close();
         }
         catch (SQLException sqlex){
         this.id = null;
-        System.err.println(sqlex);
+        System.err.println("METSNamespace.writeSQL(): "+sqlex);
         return false;
         }
@@ -201 +208 @@
         select.setWhere(where);
 
-        connection.execute(select.toString());
-      
-        ResultSet valuesSet = connection.getResultSet();
-        if (valuesSet != null && valuesSet.first()) {
+        Statement statement = connection.createStatement();
+        ResultSet valuesSet = statement.executeQuery(select.toString());
+        if (valuesSet.first()) {
         do {
             String label = valuesSet.getString("Label");
@@ -213 +219 @@
         while (valuesSet.next());
         }
-
+        statement.close();
         return namespace;
     }
     catch (java.net.MalformedURLException urlEx){
-        System.out.println(urlEx);
+        System.err.println("METSNamespace.readSQL(): "+urlEx);
     }
     catch (SQLException sqlEx){
-        System.out.println(sqlEx);
+        System.err.println("METSNamespace.readSQL(): "+sqlEx);
     }    
     return null;