Metacat

import java.util.HashMap;

import java.util.Map;

	/**

	 * Returns a Map of serverCode=serverName 

	 * @return Map of server codes to names (URIs)

	 */

	public static Map<Integer, String> getServerCodes() throws ServiceException {

		DBConnection dbConn = null;

		int serialNumber = -1;

		PreparedStatement pstmt = null;

		Map<Integer, String> codes = new HashMap<Integer, String>();

		try {

			dbConn = DBConnectionPool.getDBConnection("MetacatReplication.getServerCodes");

			serialNumber = dbConn.getCheckOutSerialNumber();

			pstmt = dbConn.prepareStatement("SELECT serverid, server FROM xml_replication ");

			pstmt.execute();

			ResultSet rs = pstmt.getResultSet();

			while (rs.next()) {

				int serverCode = rs.getInt(1);

				String server = rs.getString(2);

				codes.put(serverCode, server);

			}

			pstmt.close();

		} catch (SQLException sqle) {

			throw new ServiceException("ReplicationService.getServerCodes - " 

					+ "SQL error when getting server map: " + sqle.getMessage());

		} finally {

			try {

				pstmt.close();

			}//try

			catch (Exception ee) {

				logMetacat.error("ReplicationService.getServerCodes - " + ReplicationService.METACAT_REPL_ERROR_MSG);                         

				logReplication.error("ReplicationService.getServerCodes - Error in MetacatReplicatio.getServerCodes: "

						+ ee.getMessage());

			}//catch

			finally {

				DBConnectionPool.returnDBConnection(dbConn, serialNumber);

			}//finally

		}//finally

		return codes;

	}

import java.util.Arrays;

import java.util.Iterator;

import java.util.Map;

import edu.ucsb.nceas.metacat.replication.ReplicationService;

		Map<Integer, String> serverCodes = ReplicationService.getServerCodes();

		// select the metadata ids we want to summarize

		boolean includeReplicas = true;

		Iterator<Integer> codeIter = Arrays.asList(new Integer[] {1}).iterator();

		if (includeReplicas ) {

			codeIter = serverCodes.keySet().iterator();

		}

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

		while (codeIter.hasNext()) {

			int serverLocation = codeIter.next();

			Vector<String> idList0 = DBUtil.getAllDocidsByType(DocumentImpl.EML2_0_0NAMESPACE, false, serverLocation);

			Vector<String> idList1 = DBUtil.getAllDocidsByType(DocumentImpl.EML2_0_1NAMESPACE, false, serverLocation);

			Vector<String> idList2 = DBUtil.getAllDocidsByType(DocumentImpl.EML2_1_0NAMESPACE, false, serverLocation);

			Vector<String> idList3 = DBUtil.getAllDocidsByType(DocumentImpl.EML2_1_1NAMESPACE, false, serverLocation);

			idList.addAll(idList0);

			idList.addAll(idList1);

			idList.addAll(idList2);

			idList.addAll(idList3);

		}

		// go through all the identifiers now