Metacat

            btBuf.append("%docid=").append(docid).append("'");

            //System.out.println("sql: " + btBuf.toString());

            boolean hasBtRows = btrs.next();

            if(hasBtRows)

            { //there was a backtrackable document found

              //                   " doctitle: " + doctitle + " createdate: " +

              //                   createDate + " updatedate: " + updateDate);

            }

            btrs.close();

          }

        }

        System.out.println("rs1.close");

        rs.close();

        if(qspec.containsExtendedSQL())

        {

/**

 *   '$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;