Metacat

  /**

   * Method to return a rev list in xml_revision for given docid.

   * @param docId

   * @return is a vector which contains Integer object

   * @throws SQLException

   */

  public static Vector getRevListFromRevisionTable(String docId) throws SQLException

  {

      Vector list = new Vector();

      int rev = 1;

      PreparedStatement pStmt = null;

      DBConnection dbConn = null;

      int serialNumber = -1;

      // get rid of rev

      docId = MetaCatUtil.getDocIdFromString(docId);

      try {

          //check out DBConnection

          dbConn = DBConnectionPool

                  .getDBConnection("getRevListFromRevisionTable");

          serialNumber = dbConn.getCheckOutSerialNumber();

          pStmt = dbConn

                  .prepareStatement("SELECT rev FROM xml_revisions WHERE docid='"

                          + docId + "'");

          pStmt.execute();

          ResultSet rs = pStmt.getResultSet();

          boolean hasRow = rs.next();

          while (hasRow) {

              rev = rs.getInt(1);

              MetaCatUtil.debugMessage("rev "+ rev +" is added to list", 20);

              list.add(new Integer(rev));

              hasRow = rs.next();

          }

          pStmt.close();

      }//try

      finally {

          try {

              pStmt.close();

          } catch (Exception ee) {

              MetaCatUtil.debugMessage("Error in DocumentImpl."

                      + "getLatestRevisionNumber: " + ee.getMessage(), 50);

          } finally {

              DBConnectionPool.returnDBConnection(dbConn, serialNumber);

          }

      }//finally

      return list;

  }//getLatestRevisionNumber