Metacat

/**

 *   '$Author$'

 *     '$Date$'

 * '$Revision$'

        String object = rs.getString(3);

        //compare r to each relation in xml_relation

        pstmt = conn.prepareStatement("select subject, subdoctype, " +

                                      "relationship, object, objdoctype " +

                                      "from xml_relation");

        subDoc = new DocumentImpl(conn, subDocid);

        subDoctype = subDoc.getDoctype();

        DocumentImpl objDoc = new DocumentImpl(conn, objDocid);

        //now that the comparisons are done, the new relation can be put

        //into xml_relation

        insertStmt.append(relationship).append("', '");

        insertStmt.append(object).append("', '");

        insertStmt.append(objDoctype).append("')");

        pstmt = conn.prepareStatement(insertStmt.toString());

        pstmt.execute(); 

      }

      conn.commit();

      conn.close();

      btThread = null;