Metacat

      //bind value

      pStmt.setString(1, docId);

      //excute the query

      pStmt.execute();

      pStmt.close();

    }//try

                {

                  insertStatement.setString(6, null);

                }

                insertStatement.execute();

                hasRecord=rs.next();

              }//while

            pstmt = conn.prepareStatement(

                    "DELETE FROM xml_access WHERE accessfileid = ?");

            pstmt.setString(1, docid);

            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);

            pstmt = conn.prepareStatement(

                    "DELETE FROM xml_queryresult WHERE docid = ?");

            pstmt.setString(1, docid);

            pstmt.execute();

            pstmt.close();

            conn.increaseUsageCount(1);

                    "DELETE FROM xml_relation WHERE docid = ?");

            //increase usage count

            pstmt.setString(1, docid);

            pstmt.execute();

            pstmt.close();

            conn.increaseUsageCount(1);

                    "DELETE FROM xml_path_index WHERE docid = ?");

            //increase usage count

            pstmt.setString(1, docid);

            pstmt.execute();

            pstmt.close();

            conn.increaseUsageCount(1);

                    "DELETE FROM xml_accesssubtree WHERE docid = ?");

            //increase usage count

            pstmt.setString(1, docid);

            pstmt.execute();

            pstmt.close();

            conn.increaseUsageCount(1);

            pstmt = conn.prepareStatement(

                    "DELETE FROM xml_documents WHERE docid = ?");

            pstmt.setString(1, docid);

            pstmt.execute();

            pstmt.close();

            //Usaga count increase 1

                   conn.increaseUsageCount(1);

                   // Bind the values to the query and execute it

                   pstmt.setString(1, docid);

                   pstmt.execute();

                   pstmt.close();

                   pstmt.setString(2, prName);

                   logMetacat.info("Principal in accesstable: "

                           + prName);

                   pstmt.execute();

               }//for

           }//for

            logMetacat.info("Start node id is: " + startNodeId);

            pstmt.setLong(6, endNodeId);

            logMetacat.info("End node id is: " + endNodeId);

            pstmt.execute();

            pstmt.close();

        }//try

            // delete all acl records for resources related to @aclid if any

            stmt = connection.createStatement();

            // Increase DBConnection usage count

            stmt.execute("DELETE FROM xml_accesssubtree WHERE docid = '"

                    + docId + "'");

                    pstmt.setString(2, prName);

                    logMetacat.info("Principal in accesstable: "

                            + prName);

                    pstmt.execute();

                }//for

            }//for

                    pstmt.setString(2, prName);

                    logMetacat.info("Principal in accesstable: "

                            + prName);

                    pstmt.execute();

                }//for

            }//for

            stmt = connection.createStatement();

            // Increase DBConnection usage count

            connection.increaseUsageCount(1);

            stmt.execute("DELETE FROM xml_access WHERE accessfileid = '"

                    + aclid + "'");

            logMetacat.info("Start node id is: " + startNodeId);

            pstmt.setLong(6, endNodeId);

            logMetacat.info("End node id is: " + endNodeId);

            pstmt.execute();

            pstmt.close();

        }//try

            stmt = connection.createStatement();

            // Increase DBConnection usage count

            connection.increaseUsageCount(1);

            stmt.execute("DELETE FROM xml_accesssubtree WHERE docid = '"

                    + docId + "'");

import java.net.URL;

import java.net.MalformedURLException;

import org.xml.sax.Attributes;

import org.xml.sax.InputSource;

import org.xml.sax.ContentHandler;

  private Vector aclObjects = new Vector();

  private boolean instarttag = true;

  private String tagName = "";

  /**

   * Construct an instance of the AccessControlList class.

   * It is used by the permission check up from DBQuery or DocumentImpl

      stmt = connection.createStatement();

      // Increase DBConnection usage count

      connection.increaseUsageCount(1);

      stmt.execute("DELETE FROM xml_access WHERE accessfileid = '" + aclid 

                                                                      + "'");

      //increase usageCount!!!!!!

      for ( int j = 0; j < principal.size(); j++ ) {

        prName = (String)principal.elementAt(j);

        pstmt.setString(2, prName);

        pstmt.execute();

      /*    

        // check if there are conflict with permission's order

      pstmt.setString(1, docid);

      pstmt.setString(2, principal);

      pstmt.setString(3, permOrder);

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      boolean hasRow = rs.next();

              "ORDER BY accessfileid, perm_order, perm_type, permission");

      // Bind the values to the query

      pstmt.setString(1, docid);

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      boolean hasRows = rs.next();