public int getRetireeCount(String mucServiceName) {
        Long serviceID = getMultiUserChatServiceID(mucServiceName);

        Connection con = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        int count = 0;
        try {
            con = DbConnectionManager.getConnection();
            pstmt = con.prepareStatement(COUNT_RETIREE);
            pstmt.setLong(1, serviceID);
            rs = pstmt.executeQuery();
            if (rs.next()) {
                count = rs.getInt(1);
            }
        } catch (SQLException e) {
            Log.error("An unexpected exception occurred while trying to count the number of MUC room retirees for serviceID '{}'", serviceID , e);
        } finally {
            DbConnectionManager.closeConnection(rs, pstmt, con);
        }
        return count;
    }
Gets the number of MUC room retirees.

@return the number of MUC room retirees.
xmppserver/src/main/java/org/jivesoftware/openfire/muc/MultiUserChatManager.java