Metacat

    // create a record in xml_revisions table 

    // for that document as selected from xml_documents

    PreparedStatement pstmt = conn.prepareStatement(

      "INSERT INTO xml_revisions " +

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

        "user_owner, user_updated, date_created, date_updated) " +

      "SELECT null, ?, rootnodeid, docname, doctype, doctitle," + 

        "user_owner, ?, sysdate, sysdate "+

      "FROM xml_documents " +

      "WHERE docid = ?");

    // Bind the values to the query and execute it

    pstmt.setString(1, docid);

    pstmt.setString(2, user);

    pstmt.setString(3, docid);

    pstmt.execute();

    pstmt.close();

  }

  /** Save a document entry in the xml_revisions table */

/*

  private static void archiveDocRevision(Connection conn, String docid,

                                         String user) throws SQLException {

*/