Metacat

	user_owner	VARCHAR2(100),	-- the user owned the document

	user_updated	VARCHAR2(100),	-- the user updated the document

  server_location NUMBER(20), -- the server on which this document resides

	date_created	DATE,

	date_updated	DATE,

	public_access	NUMBER(1) DEFAULT 1, -- flag for public access

   CONSTRAINT xml_documents_pk PRIMARY KEY (docid),

   CONSTRAINT xml_documents_rep_fk

    FOREIGN KEY (server_location) REFERENCES xml_replication, 

	user_owner	VARCHAR2(100),

	user_updated	VARCHAR2(100),

	server_location NUMBER(20),

	date_created	DATE,

	date_updated	DATE,

   CONSTRAINT xml_revisions_pk PRIMARY KEY (revisionid),

  private String system_id = null;

  private String userowner = null;

  private String userupdated = null;

  private int serverlocation;

  private int publicaccess; 

  private long rootnodeid;

  public int getPublicaccess() {

    return publicaccess;

  }

  /**

   * Print a string representation of the XML document

        conn.prepareStatement("SELECT docname, doctype, rootnodeid,doctitle, " +

                              "date_created, date_updated, " + 

                              "user_owner, user_updated, server_location, " +

                               "FROM xml_documents " +

                               "WHERE docid LIKE ?");

      // Bind the values to the query

        this.userupdated    = rs.getString(8);

        this.serverlocation = rs.getInt(9);

        this.publicaccess   = rs.getInt(10);

      } 

      pstmt.close();

        // Save the old document entry in a backup table

        DocumentImpl.archiveDocRevision( conn, docid, user );

        // Delete index for the old version of docid

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

        pstmt = conn.prepareStatement(

            "UPDATE xml_documents " +

            "SET rootnodeid = ?, docname = ?, doctype = ?, " +

            "user_updated = ?, date_updated = sysdate, " +

        // Bind the values to the query

        pstmt.setLong(1, rootnodeid);

        pstmt.setString(2, docname);

        pstmt.setString(3, doctype);

        pstmt.setString(4, user);

        pstmt.setInt(5, serverCode);

      } else {

        System.err.println("Action not supported: " + action);

      }

    PreparedStatement pstmt = conn.prepareStatement(

      "INSERT INTO xml_revisions " +

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

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

      "FROM xml_documents " +

      "WHERE docid = ?");

    // Bind the values to the query and execute it