Metacat

        "USAGE: java DBUtil <-dt | -ds [doctype] | -dg [doctype] | -dl user>");

          } else if ( args[0].equals("-dg") ) {

            String doctype = null;

            if ( args.length == 2 ) { doctype = args[1]; }

            String dataguide = dbutil.readDataGuide(doctype);

            System.out.println(dataguide);

   * read Data Guide for a given doctype from db connection in XML format

   * select all distinct absolute paths from xml_index table

   */

  public String readDataGuide( String doctype )

        throws SQLException  {

    Vector dataguide = new Vector();

    String path;

    PreparedStatement pstmt = null;

    DBConnection dbConn = null;

    int serialNumber = -1;

    try {

        dbConn=DBConnectionPool.

                  getDBConnection("DBUtil.readDataGuide");

        serialNumber=dbConn.getCheckOutSerialNumber();

        if ( doctype != null ) {

            pstmt = dbConn.prepareStatement("SELECT distinct path, nodeid " + 

                                          "FROM xml_index " +

                                          "WHERE path LIKE '/%' " + 

                                          "AND doctype LIKE ? " +

                                          "ORDER BY nodeid");

            pstmt.setString(1, doctype);

        } else {

            pstmt = 

            dbConn.prepareStatement("SELECT distinct path, doctype, nodeid " + 

                                          "FROM xml_index " +

                                          "WHERE path LIKE '/%' " + 

                                          "ORDER BY doctype, nodeid");

        }

        pstmt.execute();

        ResultSet rs = pstmt.getResultSet();

        boolean tableHasRows = rs.next();

        while (tableHasRows) {

            path = rs.getString(1);

            if ( dataguide.indexOf(path) == -1 ) {

                dataguide.addElement(path);

            }    

            tableHasRows = rs.next();

        }

        pstmt.close();

    } catch (SQLException e) {

      throw new SQLException("DBUtil.readDataGuide(). " + e.getMessage());

    }

    finally

    {

      try

      {

        pstmt.close();

      }//try

      finally

      {

        DBConnectionPool.returnDBConnection(dbConn, serialNumber);

      }//finally

    }//finally

    return formatToXML(dataguide);

  }

  /**