Metacat

                        .getOption("usexmlindex"))).booleanValue();

                if (useXMLIndex) {

                    logMetacat.info("before delete");

                    // Delete index for the old version of docid

                    // The new index is inserting on the next calls to DBSAXNode

                    pstmt = connection

                            .prepareStatement("DELETE FROM xml_index WHERE docid='"

                                    + this.docid + "'");

                    // Increase dbconnection usage count

                    connection.increaseUsageCount(1);

                    pstmt.execute();

                    pstmt.close();

                }

                // Update the new document to reflect the new node tree

            }

            logMetacat.warn("Start deleting doc " + docid + "...");

            // check for 'write' permission for 'user' to delete this document

            if (!hasAllPermission(user, groups, accnum)) {

                if(!MetaCatUtil.isAdministrator(user, groups)){

            conn.setAutoCommit(false);

            // Copy the record to the xml_revisions table

            DocumentImpl.archiveDocAndNodesRevision(conn, docid, user, null);

            // Now delete it from the xml_index table

            boolean useXMLIndex = (new Boolean(MetaCatUtil

                    .getOption("usexmlindex"))).booleanValue();

            pstmt.close();

            conn.increaseUsageCount(1);

            //}

            // Now delete it from xml_access table

            pstmt = conn.prepareStatement(

                    "DELETE FROM xml_access WHERE accessfileid = ?");

            pstmt.execute();

            pstmt.close();

            conn.increaseUsageCount(1);

            pstmt = conn.prepareStatement(

                    "DELETE FROM xml_access WHERE docid = ?");

            pstmt.setString(1, docid);

            pstmt.execute();

            pstmt.close();

            conn.increaseUsageCount(1);

            // Delete enteries from xml_queryresult

            pstmt = conn.prepareStatement(

                    "DELETE FROM xml_queryresult WHERE docid = ?");

            pstmt.execute();

            pstmt.close();

            conn.increaseUsageCount(1);

            // Delete it from relation table

            pstmt = conn.prepareStatement(

                    "DELETE FROM xml_relation WHERE docid = ?");

            pstmt.execute();

            pstmt.close();

            conn.increaseUsageCount(1);

            // Delete it from xml_path_index table

            pstmt = conn.prepareStatement(

            pstmt.close();

            //Usaga count increase 1

            conn.increaseUsageCount(1);

            // Delete the old nodes in xml_nodes table...

                   pstmt = conn.prepareStatement("DELETE FROM xml_nodes "

                                                   + "WHERE docid = ?");

                   pstmt.execute();

                   pstmt.close();

            conn.commit();

            conn.setAutoCommit(true);

              //System.out.println("the string stored into cache is "+ resultsetBuffer.toString());

         	   DBQuery.clearQueryResultCache();

            }

        } catch (Exception e) {

            logMetacat.error("error in DocumentImpl.delete: "

        moveNodesToNodesRevision(dbconn, rootNodeId);

        //archiveDocRevision(docid, user);

        //Move the document information to xml_revisions table...

        pstmt = dbconn.prepareStatement("INSERT INTO xml_revisions "

                + "(docid, rootnodeid, docname, doctype, "

                + "user_owner, user_updated, date_created, date_updated, "

        pstmt.setString(3, docid);

        pstmt.execute();

        pstmt.close();

      } catch (SQLException e) {

        logMetacat.error(

        logMetacat.info("the root node id is "+rootNodeId+

                " will be moved from xml_nodes to xml_node_revision table");

        PreparedStatement pstmt = null;

        // Move the nodes from xml_nodes to xml_revisions table...

        pstmt = dbconn.prepareStatement("INSERT INTO xml_nodes_revisions "

                + "(nodeid, nodeindex, nodetype, nodename, nodeprefix, "

        pstmt.setLong(1, rootNodeId);

        pstmt.execute();

        pstmt.close();

    }

        //MetaCatUtil util = new MetaCatUtil();

        AccessionNumber ac;

        PreparedStatement pstmt = null;

        String sql = "DELETE FROM xml_nodes WHERE rootnodeid ="+ rootId;

        pstmt = dbconn.prepareStatement(sql);

        // Increase dbconnection usage count

        dbconn.increaseUsageCount(1);

        pstmt.execute();

        pstmt.close(); 

    }

}