Metacat

   * Get the root node id for an XML document given a document id

   *

   * @param docid the document node contains the root of the document

   * @returns long the nodeid of the root node for this document

   */

  public long getRootNode(long docid) {

    // Now look up the root node id

    long rootnodeid = 0;

    try {

      PreparedStatement pstmt =

        conn.prepareStatement("SELECT rootnodeid " +

                "FROM xml_documents " +

                "WHERE docid = ?");

      // Bind the values to the query

      pstmt.setLong(1, docid);

      pstmt.execute();

      try {

        ResultSet rs = pstmt.getResultSet();

        try {

          boolean tableHasRows = rs.next();

          if (tableHasRows) {

            try {

              rootnodeid = rs.getLong(1);

            } catch (SQLException e) {

              System.out.println("Error with getLong: " + e.getMessage());

            }

          }

        } catch (SQLException e) {

          System.out.println("Error with next: " + e.getMessage());

        }

      } catch (SQLException e) {

        System.out.println("Error with getrset: " + e.getMessage());

      }

      pstmt.close();

    } catch (SQLException e) {

      System.out.println("Error getting id: " + e.getMessage());

    }

    return rootnodeid;

  }

  /**

   * @param docid the document that we want retrieved

  public String readXMLDocument(long docid) {

    ReaderElement element = new ReaderElement(conn, getRootNode(docid));