Metacat

     partOfDoclist = addRelationship(partOfDoclist, qspec, dbconn, useXMLIndex);

    /*

    * A method to add relationship to return doclist hash table

    */

   private ResultDocumentSet addRelationship(ResultDocumentSet docListResult,

                                     QuerySpecification qspec,

                                     DBConnection dbconn, boolean useXMLIndex )

                                     throws Exception

  {

    PreparedStatement pstmt = null;

    ResultSet rs = null;

    StringBuffer document = null;

    double startRelation = System.currentTimeMillis() / 1000;

    Iterator docidkeys = docListResult.getDocids();

    while (docidkeys.hasNext())

    {

      //String connstring =

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

      String connstring = "%docid=";

      String docidkey;

      synchronized(docListResult)

      {

        docidkey = (String) docidkeys.next();

      }

      pstmt = dbconn.prepareStatement(QuerySpecification

                      .printRelationSQL(docidkey));

      pstmt.execute();

      rs = pstmt.getResultSet();

      boolean tableHasRows = rs.next();

      while (tableHasRows)

      {

        String sub = rs.getString(1);

        String rel = rs.getString(2);

        String obj = rs.getString(3);

        String subDT = rs.getString(4);

        String objDT = rs.getString(5);

        document = new StringBuffer();

        document.append("<triple>");

        document.append("<subject>").append(MetaCatUtil.normalize(sub));

        document.append("</subject>");

        if (subDT != null)

        {

          document.append("<subjectdoctype>").append(subDT);

          document.append("</subjectdoctype>");

        }

        document.append("<relationship>").append(MetaCatUtil.normalize(rel));

        document.append("</relationship>");

        document.append("<object>").append(MetaCatUtil.normalize(obj));

        document.append("</object>");

        if (objDT != null)

        {

          document.append("<objectdoctype>").append(objDT);

          document.append("</objectdoctype>");

        }

        document.append("</triple>");

        String removedelement = (String) docListResult.get(docidkey);

        docListResult.set(docidkey, removedelement+ document.toString());

        tableHasRows = rs.next();

      }//while

      rs.close();

      pstmt.close();

    }//while

    double endRelation = System.currentTimeMillis() / 1000;

    logMetacat.warn("Time to add relationship to return fields (part 3 in return fields): "

                             + (endRelation - startRelation));

    MetaCatUtil.writeDebugToFile("-----------------------------------------Add relationship to return field(part3 in return fields): "

            + (endRelation - startRelation));

    MetaCatUtil.writeDebugToDelimiteredFile(" "+ (endRelation - startRelation), false);

    return docListResult;

  }//addRelation