Metacat

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