Metacat

   * return all docids with a given doctype

   */

  public Vector getAllDocidsByType(String doctype, boolean includeRevs) throws SQLException {

		Vector<String> resultVector = new Vector<String>();

		String accnum = null;

		String sep = ".";

	    try {

	    	PropertyService.getProperty("document.accNumSeparator");

	    } catch (PropertyNotFoundException pnfe) {

	    	logMetacat.error("could not get property 'accNumSeparator'.  setting to '.': " 

	    			+ pnfe.getMessage());  	

	    }

		PreparedStatement pstmt = null;

		DBConnection dbConn = null;

		int serialNumber = -1;

		try {

			dbConn = DBConnectionPool.getDBConnection("DBUtil.getAllDocidsByType");

			serialNumber = dbConn.getCheckOutSerialNumber();

			StringBuffer sb = new StringBuffer();

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

					+ "FROM xml_documents ");

			if (doctype != null) {

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

			}

			if (includeRevs) {

				sb.append("UNION " + "SELECT docid, rev " + "FROM xml_revisions ");

				if (doctype != null) {

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

				}

			}

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

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

			if (doctype != null) {

				pstmt.setString(1, doctype);

				if (includeRevs) {

					pstmt.setString(2, doctype);

				}

			}

			pstmt.execute();

			ResultSet rs = pstmt.getResultSet();

			String id = null;

			String rev = null;

			while (rs.next()) {

				id = rs.getString(1);

				rev = rs.getString(2);

				if (id != null) {

					resultVector.addElement(id + sep + rev);

				}

			}

			pstmt.close();

		} catch (SQLException e) {

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

		} finally {

			try {

				pstmt.close();

			}// try

			finally {

				DBConnectionPool.returnDBConnection(dbConn, serialNumber);

			}// finally

		}// finally

		return resultVector;

	}

  /**