Metacat

   * get the lastest Accession Number from a particular scope

   */

  public Vector getAllDocids(String scope)

        throws SQLException  {

    Vector resultVector = new Vector();

    String accnum = null;

    String sep = MetaCatUtil.getOption("accNumSeparator");

    PreparedStatement pstmt = null;

    DBConnection dbConn = null;

    int serialNumber = -1;

    try 

    {

      dbConn=DBConnectionPool.

                getDBConnection("DBUtil.getAllDocids");

      serialNumber=dbConn.getCheckOutSerialNumber();

      StringBuffer sb = new StringBuffer();

      sb.append("SELECT docid, rev FROM " +

                "( " +

                "SELECT docid, rev " + 

                "FROM xml_documents ");

      if(scope != null)

      {

        sb.append("WHERE docid LIKE ? ");

      }

      sb.append("UNION " + 

                "SELECT docid, rev " + 

                "FROM xml_revisions ");

      if(scope != null)

      {

        sb.append("WHERE docid LIKE ?");

      }

      sb.append(") subquery GROUP BY docid, rev");

      pstmt = dbConn.prepareStatement(sb.toString());

      if(scope != null)

      {

        pstmt.setString(1,scope + sep + "%");

        pstmt.setString(2,scope + sep + "%");

      }

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      long max = 0;

      String id = null;

      String rev = null;

      while(rs.next()){

    	  id = rs.getString(1);

        rev = rs.getString(2);

    	  if(id != null){

    		  //temp = temp.substring(id.indexOf(scope) + scope.length() + 1);

          resultVector.addElement(id + sep + rev);

        }

      }

      pstmt.close();

    } catch (SQLException e) {

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

    }

    finally

    {

      try

      {

        pstmt.close();

      }//try

      finally

      {

        DBConnectionPool.returnDBConnection(dbConn, serialNumber);

      }//finally

    }//finally

    return resultVector;

  }

  /**