Metacat

      //the following while loop construct checks to make sure that the docid

      //of the document that we are trying to index is already

      //in the xml_documents table.  if this is not the case, the foreign

      //key relationship between xml_documents and xml_index is temporarily

      //broken causing multiple problems.

      boolean inxmldoc = false;

      while(!inxmldoc)

      {

        String xmlDocumentsCheck = "select distinct docid from xml_documents";

        PreparedStatement xmlDocCheck = dbconn.prepareStatement(xmlDocumentsCheck);

        xmlDocCheck.execute();

        ResultSet doccheckRS = xmlDocCheck.getResultSet();

        boolean tableHasRows = doccheckRS.next();

        Vector docids = new Vector();

        while(tableHasRows) 

        {

          docids.add(doccheckRS.getString(1).trim());

          tableHasRows = doccheckRS.next();

        }

        for(int i=0; i<docids.size(); i++)

        {

          String d = ((String)docids.elementAt(i)).trim();

          if(docid.trim().equals(d))

          {

            inxmldoc = true;

          }

        }

        xmlDocCheck.close();

      }