Metacat

                // Save the old document publicaccessentry in a backup table

                String accNumber = docid+MetaCatUtil.getOption("accNumSeparator")+thisrev;

                thisdoc = new DocumentImpl(accNumber, false);

                MetaCatUtil.debugMessage("after archiveDoc", 30);

                //if the updated vesion is not greater than current one,

                //throw it into a exception

            pstmt.close();

            if(action.equals("UPDATE")){

                pstmt = connection.prepareStatement("DELETE FROM xml_nodes "

                                                + "WHERE rootnodeid = ?");

                // Increase dbconnection usage count

                // Bind the values to the query and execute it

                pstmt.setLong(1, thisdoc.getRootNodeID());

                pstmt.execute();

            }

        } catch (SQLException sqle) {

        // insert into xml_nodes table

        XMLReader parser = null;

        try {

            if (tableName.equals(REVISIONTABLE))

            {

                isRevision = true;

        // run write into access db base on relation table and access rule

        try {

            {

               runRelationAndAccessHandler(accnum, user, groups, serverCode);

            }

              // we need to move nodes from xml_nodes to xml_nodes_revision and register the record

            	// into xml_revision table

               moveNodesToNodesRevision(conn, rootId);

               writeDocumentToRevisionTable(conn, docid, rev, docType, docName, user, 

                       catalogId, serverCode, rootId, createDate, updateDate);

            }

        } catch (Exception ee) {

        	conn.rollback();

            {

                // because we couldn't register the table into xml_revsion

                // we need to delete the nodes in xml_ndoes.

            }

            MetacatReplication.replErrorLog("Failed to " + "create access "

                    + "rule for package: " + accnum + " because "

            conn.setAutoCommit(false);

            // Copy the record to the xml_revisions table

            // Now delete it from the xml_index table

            boolean useXMLIndex = (new Boolean(MetaCatUtil

    }

    /**

     * paramter is in order to rollback feature

     */

            String user, DocumentImpl doc)

    {

    private static void moveNodesToNodesRevision(DBConnection dbconn,

                                       long rootNodeId) throws Exception

    {

        PreparedStatement pstmt = null;

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

        pstmt = dbconn.prepareStatement("INSERT INTO xml_nodes_revisions "

        pstmt.setLong(1, rootNodeId);

        pstmt.execute();

        pstmt.close();

    }

        try 

        {

            if (createDate == null)

            {

                createDate = dbAdapter.getDateTimeFunction();

            {

                createDate = dbAdapter.toDate(createDate, "YYYY-MM-DD HH24:MI:SS");

            }

            if (updateDate == null)

            {

                updateDate = dbAdapter.getDateTimeFunction();

            {

                updateDate = dbAdapter.toDate(updateDate, "YYYY-MM-DD HH24:MI:SS");

            }

            PreparedStatement pstmt = null;

            String sql = null;

            if (rootNodeId <= 0)

            {

            	// this is for data file, not rootnodeid need

            // Bind the values to the query

            pstmt.setString(1, docId);

            pstmt.setString(2, docName);

            pstmt.setString(3, docType);

            pstmt.setString(4, user);

            pstmt.setString(5, user);

            pstmt.setInt(6, 0);

            pstmt.setInt(7, (new Integer(catalogid)).intValue());

            pstmt.setInt(8, serverCode);

            pstmt.setInt(9, Integer.parseInt(rev));

            if (rootNodeId >0 )

            {

              pstmt.setLong(10, rootNodeId);

            }

            // Do the insertion

            pstmt.execute();

            pstmt.close();

        } 

        catch (SQLException sqle) 

        } 

        catch (Exception e) 

        {

            throw e;

        }

    }

     * if in the second step some error happend, we need to delete the

     * node in xml_nodes table as roll back

     */

    {

        //MetaCatUtil util = new MetaCatUtil();

        AccessionNumber ac;

        PreparedStatement pstmt = null;

    }

}