Metacat

    /**

     * Build the index records for this document.  For each node, all absolute

     * and relative paths to the root of the document are created and inserted

     * database.

     *

     * @throws McdbException on error getting the node records for the document

            Long nodeId = new Long(currentNode.getNodeId());

            nodeRecordMap.put(nodeId, currentNode);

        }

        // XML Index -- be sure that it is all in one db transaction

        int serialNumber = -1;

        DBConnection dbConn = null;

            dbConn.setAutoCommit(false);

            //make sure record is done

            //checkDocumentTable();

            // Delete the previous index entries for this document

            deleteNodeIndex(dbConn);

            // Step through all of the node records we were given

            // and build the new index and update the database

            it = nodeRecordLists.iterator();

                if (currentNode.nodetype.equals("ELEMENT") ||

                    currentNode.nodetype.equals("ATTRIBUTE") ) {

                        currentNode.getNodeName() + " (" +

                        currentNode.getNodeType() + ")");

                    if (atRootElement) {

                        rootNodeId = currentNode.getNodeId();

                        atRootElement = false;

                    }

                            currentNode.getNodeId(),

                            currentNode.getNodeId(), "", pathList);

                    updateNodeIndex(dbConn, pathList);

                }

            }

            dbConn.commit();

        } catch (SQLException e) {

            MetaCatUtil.debugMessage(

                "SQL Exception while inserting path index in " +

                "DocumentImpl.buildIndex for document " + docid, 10);

            e.printStackTrace();

            try {

                dbConn.rollback();

            } catch (SQLException sqle) {

                    + "\n" + sqle.getMessage(), 10);

            }

        } finally {

        }

    }

     * @param children the string representation of all child nodes of this id

     * @param pathList the hash to which paths are added

     */

            String children, HashMap pathList) {

        Long nodeId = new Long(id);

        NodeRecord current = (NodeRecord)records.get(nodeId);

            String path = current.getNodeName() + children;

            if (!children.equals("")) {

                System.err.print("B: " + path +"\n");

                    doctype, parentId));

            }

            if (id == rootNodeId) {

                System.err.print("C: " + fullPath +"\n");

                pathList.put(fullPath, new PathIndexEntry(leafNodeId, fullPath,

                    docid, doctype, parentId));

            }

        }

    }

    /**

     * of a subsequent update.

     *

     * @param conn the database connection to use, keeping a single transaction

     * @throws SQLException if there is an error deleting from the db

     */

    {

        String familyId = MetaCatUtil.getDocIdFromString(docid);

        String sql = "DELETE FROM xml_index WHERE docid LIKE ?";

        MetaCatUtil.debugMessage(sql, 55);

        System.err.println("SQL is: " + sql);

        PreparedStatement pstmt = conn.prepareStatement(sql);

        // Increase usage count for the connection

        conn.increaseUsageCount(1);

        // Execute the delete and close the statement

        pstmt.setString(1, familyId);

        int rows = pstmt.executeUpdate();

        MetaCatUtil.debugMessage("Deleted " + rows + " rows from xml_index " +

            "for document " + docid, 55);

    }

    /**

     * database.

     *

     * @param conn the database connection to use, keeping a single transaction

     * @param pathList the hash of paths to insert

     * @throws SQLException if there is an error inserting into the db

     */

    {

        // Create an insert statement to reuse for all of the path

        // insertions

        String familyId = MetaCatUtil.getDocIdFromString(docid);

        pstmt.setString(3, familyId);

        pstmt.setString(4, doctype);

        // Step through the hashtable and insert each of the path values

        Iterator it = pathList.values().iterator();

        while (it.hasNext()) {

        // Close the database statement

        pstmt.close();

    }

    private boolean isRevisionOnly(DocumentIdentifier docid) throws Exception

    {

        //System.out.println("inRevisionOnly");