Metacat

          tableHasRows = rs.next();

        }

        rs.close();

        if (qspec.containsExtendedSQL())

        {

            doclist.append("',");

          }

          doclist.deleteCharAt(doclist.length()-1); //remove the last comma

          pstmt = dbconn.prepareStatement(qspec.printExtendedSQL(

                                        doclist.toString()));

          pstmt.execute();

          }

          rs.close();

        }

        //this loop adds the relation data to the resultdoc

        //this code might be able to be added to the backtracking code above

        Enumeration docidkeys = docListResult.keys();

          //String connstring = "metacat://"+util.getOption("server")+"?docid=";

          String connstring = "%docid=";

          String docidkey = (String)docidkeys.nextElement();

          pstmt = dbconn.prepareStatement(qspec.printRelationSQL(docidkey));

          pstmt.execute();

          rs = pstmt.getResultSet();

        this.publicaccess   = rs.getString(9);

        this.rev            = rs.getInt(10);

      } 

      if (this.doctype != null) {

        pstmt =

          conn.prepareStatement("SELECT system_id " +

        if (tableHasRows) {

          this.system_id  = rs.getString(1);

        } 

      }

    } catch (SQLException e) {

      System.out.println("error in DocumentImpl.getDocumentInfo: " + 

        pstmt = conn.prepareStatement(

                "DELETE FROM xml_index WHERE docid='" + this.docid + "'");

        pstmt.execute();

        // Update the new document to reflect the new node tree

        pstmt = conn.prepareStatement(