1   /**
2    * Copyright (c) 2000-2010 Liferay, Inc. All rights reserved.
3    *
4    * This library is free software; you can redistribute it and/or modify it under
5    * the terms of the GNU Lesser General Public License as published by the Free
6    * Software Foundation; either version 2.1 of the License, or (at your option)
7    * any later version.
8    *
9    * This library is distributed in the hope that it will be useful, but WITHOUT
10   * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
11   * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
12   * details.
13   */
14  
15  package com.liferay.portal.service.persistence;
16  
17  import com.liferay.portal.NoSuchMembershipRequestException;
18  import com.liferay.portal.NoSuchModelException;
19  import com.liferay.portal.kernel.annotation.BeanReference;
20  import com.liferay.portal.kernel.cache.CacheRegistry;
21  import com.liferay.portal.kernel.dao.orm.EntityCacheUtil;
22  import com.liferay.portal.kernel.dao.orm.FinderCacheUtil;
23  import com.liferay.portal.kernel.dao.orm.FinderPath;
24  import com.liferay.portal.kernel.dao.orm.Query;
25  import com.liferay.portal.kernel.dao.orm.QueryPos;
26  import com.liferay.portal.kernel.dao.orm.QueryUtil;
27  import com.liferay.portal.kernel.dao.orm.Session;
28  import com.liferay.portal.kernel.exception.SystemException;
29  import com.liferay.portal.kernel.log.Log;
30  import com.liferay.portal.kernel.log.LogFactoryUtil;
31  import com.liferay.portal.kernel.util.GetterUtil;
32  import com.liferay.portal.kernel.util.OrderByComparator;
33  import com.liferay.portal.kernel.util.StringBundler;
34  import com.liferay.portal.kernel.util.StringPool;
35  import com.liferay.portal.kernel.util.StringUtil;
36  import com.liferay.portal.model.MembershipRequest;
37  import com.liferay.portal.model.ModelListener;
38  import com.liferay.portal.model.impl.MembershipRequestImpl;
39  import com.liferay.portal.model.impl.MembershipRequestModelImpl;
40  import com.liferay.portal.service.persistence.impl.BasePersistenceImpl;
41  
42  import java.io.Serializable;
43  
44  import java.util.ArrayList;
45  import java.util.Collections;
46  import java.util.List;
47  
48  /**
49   * <a href="MembershipRequestPersistenceImpl.java.html"><b><i>View Source</i></b></a>
50   *
51   * <p>
52   * ServiceBuilder generated this class. Modifications in this class will be
53   * overwritten the next time is generated.
54   * </p>
55   *
56   * @author    Brian Wing Shun Chan
57   * @see       MembershipRequestPersistence
58   * @see       MembershipRequestUtil
59   * @generated
60   */
61  public class MembershipRequestPersistenceImpl extends BasePersistenceImpl<MembershipRequest>
62      implements MembershipRequestPersistence {
63      public static final String FINDER_CLASS_NAME_ENTITY = MembershipRequestImpl.class.getName();
64      public static final String FINDER_CLASS_NAME_LIST = FINDER_CLASS_NAME_ENTITY +
65          ".List";
66      public static final FinderPath FINDER_PATH_FIND_BY_GROUPID = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
67              MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
68              FINDER_CLASS_NAME_LIST, "findByGroupId",
69              new String[] { Long.class.getName() });
70      public static final FinderPath FINDER_PATH_FIND_BY_OBC_GROUPID = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
71              MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
72              FINDER_CLASS_NAME_LIST, "findByGroupId",
73              new String[] {
74                  Long.class.getName(),
75                  
76              "java.lang.Integer", "java.lang.Integer",
77                  "com.liferay.portal.kernel.util.OrderByComparator"
78              });
79      public static final FinderPath FINDER_PATH_COUNT_BY_GROUPID = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
80              MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
81              FINDER_CLASS_NAME_LIST, "countByGroupId",
82              new String[] { Long.class.getName() });
83      public static final FinderPath FINDER_PATH_FIND_BY_USERID = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
84              MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
85              FINDER_CLASS_NAME_LIST, "findByUserId",
86              new String[] { Long.class.getName() });
87      public static final FinderPath FINDER_PATH_FIND_BY_OBC_USERID = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
88              MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
89              FINDER_CLASS_NAME_LIST, "findByUserId",
90              new String[] {
91                  Long.class.getName(),
92                  
93              "java.lang.Integer", "java.lang.Integer",
94                  "com.liferay.portal.kernel.util.OrderByComparator"
95              });
96      public static final FinderPath FINDER_PATH_COUNT_BY_USERID = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
97              MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
98              FINDER_CLASS_NAME_LIST, "countByUserId",
99              new String[] { Long.class.getName() });
100     public static final FinderPath FINDER_PATH_FIND_BY_G_S = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
101             MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
102             FINDER_CLASS_NAME_LIST, "findByG_S",
103             new String[] { Long.class.getName(), Integer.class.getName() });
104     public static final FinderPath FINDER_PATH_FIND_BY_OBC_G_S = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
105             MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
106             FINDER_CLASS_NAME_LIST, "findByG_S",
107             new String[] {
108                 Long.class.getName(), Integer.class.getName(),
109                 
110             "java.lang.Integer", "java.lang.Integer",
111                 "com.liferay.portal.kernel.util.OrderByComparator"
112             });
113     public static final FinderPath FINDER_PATH_COUNT_BY_G_S = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
114             MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
115             FINDER_CLASS_NAME_LIST, "countByG_S",
116             new String[] { Long.class.getName(), Integer.class.getName() });
117     public static final FinderPath FINDER_PATH_FIND_ALL = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
118             MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
119             FINDER_CLASS_NAME_LIST, "findAll", new String[0]);
120     public static final FinderPath FINDER_PATH_COUNT_ALL = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
121             MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
122             FINDER_CLASS_NAME_LIST, "countAll", new String[0]);
123 
124     public void cacheResult(MembershipRequest membershipRequest) {
125         EntityCacheUtil.putResult(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
126             MembershipRequestImpl.class, membershipRequest.getPrimaryKey(),
127             membershipRequest);
128     }
129 
130     public void cacheResult(List<MembershipRequest> membershipRequests) {
131         for (MembershipRequest membershipRequest : membershipRequests) {
132             if (EntityCacheUtil.getResult(
133                         MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
134                         MembershipRequestImpl.class,
135                         membershipRequest.getPrimaryKey(), this) == null) {
136                 cacheResult(membershipRequest);
137             }
138         }
139     }
140 
141     public void clearCache() {
142         CacheRegistry.clear(MembershipRequestImpl.class.getName());
143         EntityCacheUtil.clearCache(MembershipRequestImpl.class.getName());
144         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_ENTITY);
145         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
146     }
147 
148     public MembershipRequest create(long membershipRequestId) {
149         MembershipRequest membershipRequest = new MembershipRequestImpl();
150 
151         membershipRequest.setNew(true);
152         membershipRequest.setPrimaryKey(membershipRequestId);
153 
154         return membershipRequest;
155     }
156 
157     public MembershipRequest remove(Serializable primaryKey)
158         throws NoSuchModelException, SystemException {
159         return remove(((Long)primaryKey).longValue());
160     }
161 
162     public MembershipRequest remove(long membershipRequestId)
163         throws NoSuchMembershipRequestException, SystemException {
164         Session session = null;
165 
166         try {
167             session = openSession();
168 
169             MembershipRequest membershipRequest = (MembershipRequest)session.get(MembershipRequestImpl.class,
170                     new Long(membershipRequestId));
171 
172             if (membershipRequest == null) {
173                 if (_log.isWarnEnabled()) {
174                     _log.warn(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
175                         membershipRequestId);
176                 }
177 
178                 throw new NoSuchMembershipRequestException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
179                     membershipRequestId);
180             }
181 
182             return remove(membershipRequest);
183         }
184         catch (NoSuchMembershipRequestException nsee) {
185             throw nsee;
186         }
187         catch (Exception e) {
188             throw processException(e);
189         }
190         finally {
191             closeSession(session);
192         }
193     }
194 
195     public MembershipRequest remove(MembershipRequest membershipRequest)
196         throws SystemException {
197         for (ModelListener<MembershipRequest> listener : listeners) {
198             listener.onBeforeRemove(membershipRequest);
199         }
200 
201         membershipRequest = removeImpl(membershipRequest);
202 
203         for (ModelListener<MembershipRequest> listener : listeners) {
204             listener.onAfterRemove(membershipRequest);
205         }
206 
207         return membershipRequest;
208     }
209 
210     protected MembershipRequest removeImpl(MembershipRequest membershipRequest)
211         throws SystemException {
212         membershipRequest = toUnwrappedModel(membershipRequest);
213 
214         Session session = null;
215 
216         try {
217             session = openSession();
218 
219             if (membershipRequest.isCachedModel() ||
220                     BatchSessionUtil.isEnabled()) {
221                 Object staleObject = session.get(MembershipRequestImpl.class,
222                         membershipRequest.getPrimaryKeyObj());
223 
224                 if (staleObject != null) {
225                     session.evict(staleObject);
226                 }
227             }
228 
229             session.delete(membershipRequest);
230 
231             session.flush();
232         }
233         catch (Exception e) {
234             throw processException(e);
235         }
236         finally {
237             closeSession(session);
238         }
239 
240         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
241 
242         EntityCacheUtil.removeResult(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
243             MembershipRequestImpl.class, membershipRequest.getPrimaryKey());
244 
245         return membershipRequest;
246     }
247 
248     public MembershipRequest updateImpl(
249         com.liferay.portal.model.MembershipRequest membershipRequest,
250         boolean merge) throws SystemException {
251         membershipRequest = toUnwrappedModel(membershipRequest);
252 
253         Session session = null;
254 
255         try {
256             session = openSession();
257 
258             BatchSessionUtil.update(session, membershipRequest, merge);
259 
260             membershipRequest.setNew(false);
261         }
262         catch (Exception e) {
263             throw processException(e);
264         }
265         finally {
266             closeSession(session);
267         }
268 
269         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
270 
271         EntityCacheUtil.putResult(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
272             MembershipRequestImpl.class, membershipRequest.getPrimaryKey(),
273             membershipRequest);
274 
275         return membershipRequest;
276     }
277 
278     protected MembershipRequest toUnwrappedModel(
279         MembershipRequest membershipRequest) {
280         if (membershipRequest instanceof MembershipRequestImpl) {
281             return membershipRequest;
282         }
283 
284         MembershipRequestImpl membershipRequestImpl = new MembershipRequestImpl();
285 
286         membershipRequestImpl.setNew(membershipRequest.isNew());
287         membershipRequestImpl.setPrimaryKey(membershipRequest.getPrimaryKey());
288 
289         membershipRequestImpl.setMembershipRequestId(membershipRequest.getMembershipRequestId());
290         membershipRequestImpl.setCompanyId(membershipRequest.getCompanyId());
291         membershipRequestImpl.setUserId(membershipRequest.getUserId());
292         membershipRequestImpl.setCreateDate(membershipRequest.getCreateDate());
293         membershipRequestImpl.setGroupId(membershipRequest.getGroupId());
294         membershipRequestImpl.setComments(membershipRequest.getComments());
295         membershipRequestImpl.setReplyComments(membershipRequest.getReplyComments());
296         membershipRequestImpl.setReplyDate(membershipRequest.getReplyDate());
297         membershipRequestImpl.setReplierUserId(membershipRequest.getReplierUserId());
298         membershipRequestImpl.setStatusId(membershipRequest.getStatusId());
299 
300         return membershipRequestImpl;
301     }
302 
303     public MembershipRequest findByPrimaryKey(Serializable primaryKey)
304         throws NoSuchModelException, SystemException {
305         return findByPrimaryKey(((Long)primaryKey).longValue());
306     }
307 
308     public MembershipRequest findByPrimaryKey(long membershipRequestId)
309         throws NoSuchMembershipRequestException, SystemException {
310         MembershipRequest membershipRequest = fetchByPrimaryKey(membershipRequestId);
311 
312         if (membershipRequest == null) {
313             if (_log.isWarnEnabled()) {
314                 _log.warn(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
315                     membershipRequestId);
316             }
317 
318             throw new NoSuchMembershipRequestException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
319                 membershipRequestId);
320         }
321 
322         return membershipRequest;
323     }
324 
325     public MembershipRequest fetchByPrimaryKey(Serializable primaryKey)
326         throws SystemException {
327         return fetchByPrimaryKey(((Long)primaryKey).longValue());
328     }
329 
330     public MembershipRequest fetchByPrimaryKey(long membershipRequestId)
331         throws SystemException {
332         MembershipRequest membershipRequest = (MembershipRequest)EntityCacheUtil.getResult(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
333                 MembershipRequestImpl.class, membershipRequestId, this);
334 
335         if (membershipRequest == null) {
336             Session session = null;
337 
338             try {
339                 session = openSession();
340 
341                 membershipRequest = (MembershipRequest)session.get(MembershipRequestImpl.class,
342                         new Long(membershipRequestId));
343             }
344             catch (Exception e) {
345                 throw processException(e);
346             }
347             finally {
348                 if (membershipRequest != null) {
349                     cacheResult(membershipRequest);
350                 }
351 
352                 closeSession(session);
353             }
354         }
355 
356         return membershipRequest;
357     }
358 
359     public List<MembershipRequest> findByGroupId(long groupId)
360         throws SystemException {
361         Object[] finderArgs = new Object[] { new Long(groupId) };
362 
363         List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_GROUPID,
364                 finderArgs, this);
365 
366         if (list == null) {
367             Session session = null;
368 
369             try {
370                 session = openSession();
371 
372                 StringBundler query = new StringBundler(3);
373 
374                 query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
375 
376                 query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
377 
378                 query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
379 
380                 String sql = query.toString();
381 
382                 Query q = session.createQuery(sql);
383 
384                 QueryPos qPos = QueryPos.getInstance(q);
385 
386                 qPos.add(groupId);
387 
388                 list = q.list();
389             }
390             catch (Exception e) {
391                 throw processException(e);
392             }
393             finally {
394                 if (list == null) {
395                     list = new ArrayList<MembershipRequest>();
396                 }
397 
398                 cacheResult(list);
399 
400                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_GROUPID,
401                     finderArgs, list);
402 
403                 closeSession(session);
404             }
405         }
406 
407         return list;
408     }
409 
410     public List<MembershipRequest> findByGroupId(long groupId, int start,
411         int end) throws SystemException {
412         return findByGroupId(groupId, start, end, null);
413     }
414 
415     public List<MembershipRequest> findByGroupId(long groupId, int start,
416         int end, OrderByComparator orderByComparator) throws SystemException {
417         Object[] finderArgs = new Object[] {
418                 new Long(groupId),
419                 
420                 String.valueOf(start), String.valueOf(end),
421                 String.valueOf(orderByComparator)
422             };
423 
424         List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_GROUPID,
425                 finderArgs, this);
426 
427         if (list == null) {
428             Session session = null;
429 
430             try {
431                 session = openSession();
432 
433                 StringBundler query = null;
434 
435                 if (orderByComparator != null) {
436                     query = new StringBundler(3 +
437                             (orderByComparator.getOrderByFields().length * 3));
438                 }
439                 else {
440                     query = new StringBundler(3);
441                 }
442 
443                 query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
444 
445                 query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
446 
447                 if (orderByComparator != null) {
448                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
449                         orderByComparator);
450                 }
451 
452                 else {
453                     query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
454                 }
455 
456                 String sql = query.toString();
457 
458                 Query q = session.createQuery(sql);
459 
460                 QueryPos qPos = QueryPos.getInstance(q);
461 
462                 qPos.add(groupId);
463 
464                 list = (List<MembershipRequest>)QueryUtil.list(q, getDialect(),
465                         start, end);
466             }
467             catch (Exception e) {
468                 throw processException(e);
469             }
470             finally {
471                 if (list == null) {
472                     list = new ArrayList<MembershipRequest>();
473                 }
474 
475                 cacheResult(list);
476 
477                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_GROUPID,
478                     finderArgs, list);
479 
480                 closeSession(session);
481             }
482         }
483 
484         return list;
485     }
486 
487     public MembershipRequest findByGroupId_First(long groupId,
488         OrderByComparator orderByComparator)
489         throws NoSuchMembershipRequestException, SystemException {
490         List<MembershipRequest> list = findByGroupId(groupId, 0, 1,
491                 orderByComparator);
492 
493         if (list.isEmpty()) {
494             StringBundler msg = new StringBundler(4);
495 
496             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
497 
498             msg.append("groupId=");
499             msg.append(groupId);
500 
501             msg.append(StringPool.CLOSE_CURLY_BRACE);
502 
503             throw new NoSuchMembershipRequestException(msg.toString());
504         }
505         else {
506             return list.get(0);
507         }
508     }
509 
510     public MembershipRequest findByGroupId_Last(long groupId,
511         OrderByComparator orderByComparator)
512         throws NoSuchMembershipRequestException, SystemException {
513         int count = countByGroupId(groupId);
514 
515         List<MembershipRequest> list = findByGroupId(groupId, count - 1, count,
516                 orderByComparator);
517 
518         if (list.isEmpty()) {
519             StringBundler msg = new StringBundler(4);
520 
521             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
522 
523             msg.append("groupId=");
524             msg.append(groupId);
525 
526             msg.append(StringPool.CLOSE_CURLY_BRACE);
527 
528             throw new NoSuchMembershipRequestException(msg.toString());
529         }
530         else {
531             return list.get(0);
532         }
533     }
534 
535     public MembershipRequest[] findByGroupId_PrevAndNext(
536         long membershipRequestId, long groupId,
537         OrderByComparator orderByComparator)
538         throws NoSuchMembershipRequestException, SystemException {
539         MembershipRequest membershipRequest = findByPrimaryKey(membershipRequestId);
540 
541         int count = countByGroupId(groupId);
542 
543         Session session = null;
544 
545         try {
546             session = openSession();
547 
548             StringBundler query = null;
549 
550             if (orderByComparator != null) {
551                 query = new StringBundler(3 +
552                         (orderByComparator.getOrderByFields().length * 3));
553             }
554             else {
555                 query = new StringBundler(3);
556             }
557 
558             query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
559 
560             query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
561 
562             if (orderByComparator != null) {
563                 appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
564                     orderByComparator);
565             }
566 
567             else {
568                 query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
569             }
570 
571             String sql = query.toString();
572 
573             Query q = session.createQuery(sql);
574 
575             QueryPos qPos = QueryPos.getInstance(q);
576 
577             qPos.add(groupId);
578 
579             Object[] objArray = QueryUtil.getPrevAndNext(q, count,
580                     orderByComparator, membershipRequest);
581 
582             MembershipRequest[] array = new MembershipRequestImpl[3];
583 
584             array[0] = (MembershipRequest)objArray[0];
585             array[1] = (MembershipRequest)objArray[1];
586             array[2] = (MembershipRequest)objArray[2];
587 
588             return array;
589         }
590         catch (Exception e) {
591             throw processException(e);
592         }
593         finally {
594             closeSession(session);
595         }
596     }
597 
598     public List<MembershipRequest> findByUserId(long userId)
599         throws SystemException {
600         Object[] finderArgs = new Object[] { new Long(userId) };
601 
602         List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_USERID,
603                 finderArgs, this);
604 
605         if (list == null) {
606             Session session = null;
607 
608             try {
609                 session = openSession();
610 
611                 StringBundler query = new StringBundler(3);
612 
613                 query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
614 
615                 query.append(_FINDER_COLUMN_USERID_USERID_2);
616 
617                 query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
618 
619                 String sql = query.toString();
620 
621                 Query q = session.createQuery(sql);
622 
623                 QueryPos qPos = QueryPos.getInstance(q);
624 
625                 qPos.add(userId);
626 
627                 list = q.list();
628             }
629             catch (Exception e) {
630                 throw processException(e);
631             }
632             finally {
633                 if (list == null) {
634                     list = new ArrayList<MembershipRequest>();
635                 }
636 
637                 cacheResult(list);
638 
639                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_USERID,
640                     finderArgs, list);
641 
642                 closeSession(session);
643             }
644         }
645 
646         return list;
647     }
648 
649     public List<MembershipRequest> findByUserId(long userId, int start, int end)
650         throws SystemException {
651         return findByUserId(userId, start, end, null);
652     }
653 
654     public List<MembershipRequest> findByUserId(long userId, int start,
655         int end, OrderByComparator orderByComparator) throws SystemException {
656         Object[] finderArgs = new Object[] {
657                 new Long(userId),
658                 
659                 String.valueOf(start), String.valueOf(end),
660                 String.valueOf(orderByComparator)
661             };
662 
663         List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_USERID,
664                 finderArgs, this);
665 
666         if (list == null) {
667             Session session = null;
668 
669             try {
670                 session = openSession();
671 
672                 StringBundler query = null;
673 
674                 if (orderByComparator != null) {
675                     query = new StringBundler(3 +
676                             (orderByComparator.getOrderByFields().length * 3));
677                 }
678                 else {
679                     query = new StringBundler(3);
680                 }
681 
682                 query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
683 
684                 query.append(_FINDER_COLUMN_USERID_USERID_2);
685 
686                 if (orderByComparator != null) {
687                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
688                         orderByComparator);
689                 }
690 
691                 else {
692                     query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
693                 }
694 
695                 String sql = query.toString();
696 
697                 Query q = session.createQuery(sql);
698 
699                 QueryPos qPos = QueryPos.getInstance(q);
700 
701                 qPos.add(userId);
702 
703                 list = (List<MembershipRequest>)QueryUtil.list(q, getDialect(),
704                         start, end);
705             }
706             catch (Exception e) {
707                 throw processException(e);
708             }
709             finally {
710                 if (list == null) {
711                     list = new ArrayList<MembershipRequest>();
712                 }
713 
714                 cacheResult(list);
715 
716                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_USERID,
717                     finderArgs, list);
718 
719                 closeSession(session);
720             }
721         }
722 
723         return list;
724     }
725 
726     public MembershipRequest findByUserId_First(long userId,
727         OrderByComparator orderByComparator)
728         throws NoSuchMembershipRequestException, SystemException {
729         List<MembershipRequest> list = findByUserId(userId, 0, 1,
730                 orderByComparator);
731 
732         if (list.isEmpty()) {
733             StringBundler msg = new StringBundler(4);
734 
735             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
736 
737             msg.append("userId=");
738             msg.append(userId);
739 
740             msg.append(StringPool.CLOSE_CURLY_BRACE);
741 
742             throw new NoSuchMembershipRequestException(msg.toString());
743         }
744         else {
745             return list.get(0);
746         }
747     }
748 
749     public MembershipRequest findByUserId_Last(long userId,
750         OrderByComparator orderByComparator)
751         throws NoSuchMembershipRequestException, SystemException {
752         int count = countByUserId(userId);
753 
754         List<MembershipRequest> list = findByUserId(userId, count - 1, count,
755                 orderByComparator);
756 
757         if (list.isEmpty()) {
758             StringBundler msg = new StringBundler(4);
759 
760             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
761 
762             msg.append("userId=");
763             msg.append(userId);
764 
765             msg.append(StringPool.CLOSE_CURLY_BRACE);
766 
767             throw new NoSuchMembershipRequestException(msg.toString());
768         }
769         else {
770             return list.get(0);
771         }
772     }
773 
774     public MembershipRequest[] findByUserId_PrevAndNext(
775         long membershipRequestId, long userId,
776         OrderByComparator orderByComparator)
777         throws NoSuchMembershipRequestException, SystemException {
778         MembershipRequest membershipRequest = findByPrimaryKey(membershipRequestId);
779 
780         int count = countByUserId(userId);
781 
782         Session session = null;
783 
784         try {
785             session = openSession();
786 
787             StringBundler query = null;
788 
789             if (orderByComparator != null) {
790                 query = new StringBundler(3 +
791                         (orderByComparator.getOrderByFields().length * 3));
792             }
793             else {
794                 query = new StringBundler(3);
795             }
796 
797             query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
798 
799             query.append(_FINDER_COLUMN_USERID_USERID_2);
800 
801             if (orderByComparator != null) {
802                 appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
803                     orderByComparator);
804             }
805 
806             else {
807                 query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
808             }
809 
810             String sql = query.toString();
811 
812             Query q = session.createQuery(sql);
813 
814             QueryPos qPos = QueryPos.getInstance(q);
815 
816             qPos.add(userId);
817 
818             Object[] objArray = QueryUtil.getPrevAndNext(q, count,
819                     orderByComparator, membershipRequest);
820 
821             MembershipRequest[] array = new MembershipRequestImpl[3];
822 
823             array[0] = (MembershipRequest)objArray[0];
824             array[1] = (MembershipRequest)objArray[1];
825             array[2] = (MembershipRequest)objArray[2];
826 
827             return array;
828         }
829         catch (Exception e) {
830             throw processException(e);
831         }
832         finally {
833             closeSession(session);
834         }
835     }
836 
837     public List<MembershipRequest> findByG_S(long groupId, int statusId)
838         throws SystemException {
839         Object[] finderArgs = new Object[] {
840                 new Long(groupId), new Integer(statusId)
841             };
842 
843         List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_G_S,
844                 finderArgs, this);
845 
846         if (list == null) {
847             Session session = null;
848 
849             try {
850                 session = openSession();
851 
852                 StringBundler query = new StringBundler(4);
853 
854                 query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
855 
856                 query.append(_FINDER_COLUMN_G_S_GROUPID_2);
857 
858                 query.append(_FINDER_COLUMN_G_S_STATUSID_2);
859 
860                 query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
861 
862                 String sql = query.toString();
863 
864                 Query q = session.createQuery(sql);
865 
866                 QueryPos qPos = QueryPos.getInstance(q);
867 
868                 qPos.add(groupId);
869 
870                 qPos.add(statusId);
871 
872                 list = q.list();
873             }
874             catch (Exception e) {
875                 throw processException(e);
876             }
877             finally {
878                 if (list == null) {
879                     list = new ArrayList<MembershipRequest>();
880                 }
881 
882                 cacheResult(list);
883 
884                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_G_S, finderArgs,
885                     list);
886 
887                 closeSession(session);
888             }
889         }
890 
891         return list;
892     }
893 
894     public List<MembershipRequest> findByG_S(long groupId, int statusId,
895         int start, int end) throws SystemException {
896         return findByG_S(groupId, statusId, start, end, null);
897     }
898 
899     public List<MembershipRequest> findByG_S(long groupId, int statusId,
900         int start, int end, OrderByComparator orderByComparator)
901         throws SystemException {
902         Object[] finderArgs = new Object[] {
903                 new Long(groupId), new Integer(statusId),
904                 
905                 String.valueOf(start), String.valueOf(end),
906                 String.valueOf(orderByComparator)
907             };
908 
909         List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_G_S,
910                 finderArgs, this);
911 
912         if (list == null) {
913             Session session = null;
914 
915             try {
916                 session = openSession();
917 
918                 StringBundler query = null;
919 
920                 if (orderByComparator != null) {
921                     query = new StringBundler(4 +
922                             (orderByComparator.getOrderByFields().length * 3));
923                 }
924                 else {
925                     query = new StringBundler(4);
926                 }
927 
928                 query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
929 
930                 query.append(_FINDER_COLUMN_G_S_GROUPID_2);
931 
932                 query.append(_FINDER_COLUMN_G_S_STATUSID_2);
933 
934                 if (orderByComparator != null) {
935                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
936                         orderByComparator);
937                 }
938 
939                 else {
940                     query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
941                 }
942 
943                 String sql = query.toString();
944 
945                 Query q = session.createQuery(sql);
946 
947                 QueryPos qPos = QueryPos.getInstance(q);
948 
949                 qPos.add(groupId);
950 
951                 qPos.add(statusId);
952 
953                 list = (List<MembershipRequest>)QueryUtil.list(q, getDialect(),
954                         start, end);
955             }
956             catch (Exception e) {
957                 throw processException(e);
958             }
959             finally {
960                 if (list == null) {
961                     list = new ArrayList<MembershipRequest>();
962                 }
963 
964                 cacheResult(list);
965 
966                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_G_S,
967                     finderArgs, list);
968 
969                 closeSession(session);
970             }
971         }
972 
973         return list;
974     }
975 
976     public MembershipRequest findByG_S_First(long groupId, int statusId,
977         OrderByComparator orderByComparator)
978         throws NoSuchMembershipRequestException, SystemException {
979         List<MembershipRequest> list = findByG_S(groupId, statusId, 0, 1,
980                 orderByComparator);
981 
982         if (list.isEmpty()) {
983             StringBundler msg = new StringBundler(6);
984 
985             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
986 
987             msg.append("groupId=");
988             msg.append(groupId);
989 
990             msg.append(", statusId=");
991             msg.append(statusId);
992 
993             msg.append(StringPool.CLOSE_CURLY_BRACE);
994 
995             throw new NoSuchMembershipRequestException(msg.toString());
996         }
997         else {
998             return list.get(0);
999         }
1000    }
1001
1002    public MembershipRequest findByG_S_Last(long groupId, int statusId,
1003        OrderByComparator orderByComparator)
1004        throws NoSuchMembershipRequestException, SystemException {
1005        int count = countByG_S(groupId, statusId);
1006
1007        List<MembershipRequest> list = findByG_S(groupId, statusId, count - 1,
1008                count, orderByComparator);
1009
1010        if (list.isEmpty()) {
1011            StringBundler msg = new StringBundler(6);
1012
1013            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1014
1015            msg.append("groupId=");
1016            msg.append(groupId);
1017
1018            msg.append(", statusId=");
1019            msg.append(statusId);
1020
1021            msg.append(StringPool.CLOSE_CURLY_BRACE);
1022
1023            throw new NoSuchMembershipRequestException(msg.toString());
1024        }
1025        else {
1026            return list.get(0);
1027        }
1028    }
1029
1030    public MembershipRequest[] findByG_S_PrevAndNext(long membershipRequestId,
1031        long groupId, int statusId, OrderByComparator orderByComparator)
1032        throws NoSuchMembershipRequestException, SystemException {
1033        MembershipRequest membershipRequest = findByPrimaryKey(membershipRequestId);
1034
1035        int count = countByG_S(groupId, statusId);
1036
1037        Session session = null;
1038
1039        try {
1040            session = openSession();
1041
1042            StringBundler query = null;
1043
1044            if (orderByComparator != null) {
1045                query = new StringBundler(4 +
1046                        (orderByComparator.getOrderByFields().length * 3));
1047            }
1048            else {
1049                query = new StringBundler(4);
1050            }
1051
1052            query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
1053
1054            query.append(_FINDER_COLUMN_G_S_GROUPID_2);
1055
1056            query.append(_FINDER_COLUMN_G_S_STATUSID_2);
1057
1058            if (orderByComparator != null) {
1059                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
1060                    orderByComparator);
1061            }
1062
1063            else {
1064                query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
1065            }
1066
1067            String sql = query.toString();
1068
1069            Query q = session.createQuery(sql);
1070
1071            QueryPos qPos = QueryPos.getInstance(q);
1072
1073            qPos.add(groupId);
1074
1075            qPos.add(statusId);
1076
1077            Object[] objArray = QueryUtil.getPrevAndNext(q, count,
1078                    orderByComparator, membershipRequest);
1079
1080            MembershipRequest[] array = new MembershipRequestImpl[3];
1081
1082            array[0] = (MembershipRequest)objArray[0];
1083            array[1] = (MembershipRequest)objArray[1];
1084            array[2] = (MembershipRequest)objArray[2];
1085
1086            return array;
1087        }
1088        catch (Exception e) {
1089            throw processException(e);
1090        }
1091        finally {
1092            closeSession(session);
1093        }
1094    }
1095
1096    public List<MembershipRequest> findAll() throws SystemException {
1097        return findAll(QueryUtil.ALL_POS, QueryUtil.ALL_POS, null);
1098    }
1099
1100    public List<MembershipRequest> findAll(int start, int end)
1101        throws SystemException {
1102        return findAll(start, end, null);
1103    }
1104
1105    public List<MembershipRequest> findAll(int start, int end,
1106        OrderByComparator orderByComparator) throws SystemException {
1107        Object[] finderArgs = new Object[] {
1108                String.valueOf(start), String.valueOf(end),
1109                String.valueOf(orderByComparator)
1110            };
1111
1112        List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_ALL,
1113                finderArgs, this);
1114
1115        if (list == null) {
1116            Session session = null;
1117
1118            try {
1119                session = openSession();
1120
1121                StringBundler query = null;
1122                String sql = null;
1123
1124                if (orderByComparator != null) {
1125                    query = new StringBundler(2 +
1126                            (orderByComparator.getOrderByFields().length * 3));
1127
1128                    query.append(_SQL_SELECT_MEMBERSHIPREQUEST);
1129
1130                    appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
1131                        orderByComparator);
1132
1133                    sql = query.toString();
1134                }
1135
1136                else {
1137                    sql = _SQL_SELECT_MEMBERSHIPREQUEST.concat(MembershipRequestModelImpl.ORDER_BY_JPQL);
1138                }
1139
1140                Query q = session.createQuery(sql);
1141
1142                if (orderByComparator == null) {
1143                    list = (List<MembershipRequest>)QueryUtil.list(q,
1144                            getDialect(), start, end, false);
1145
1146                    Collections.sort(list);
1147                }
1148                else {
1149                    list = (List<MembershipRequest>)QueryUtil.list(q,
1150                            getDialect(), start, end);
1151                }
1152            }
1153            catch (Exception e) {
1154                throw processException(e);
1155            }
1156            finally {
1157                if (list == null) {
1158                    list = new ArrayList<MembershipRequest>();
1159                }
1160
1161                cacheResult(list);
1162
1163                FinderCacheUtil.putResult(FINDER_PATH_FIND_ALL, finderArgs, list);
1164
1165                closeSession(session);
1166            }
1167        }
1168
1169        return list;
1170    }
1171
1172    public void removeByGroupId(long groupId) throws SystemException {
1173        for (MembershipRequest membershipRequest : findByGroupId(groupId)) {
1174            remove(membershipRequest);
1175        }
1176    }
1177
1178    public void removeByUserId(long userId) throws SystemException {
1179        for (MembershipRequest membershipRequest : findByUserId(userId)) {
1180            remove(membershipRequest);
1181        }
1182    }
1183
1184    public void removeByG_S(long groupId, int statusId)
1185        throws SystemException {
1186        for (MembershipRequest membershipRequest : findByG_S(groupId, statusId)) {
1187            remove(membershipRequest);
1188        }
1189    }
1190
1191    public void removeAll() throws SystemException {
1192        for (MembershipRequest membershipRequest : findAll()) {
1193            remove(membershipRequest);
1194        }
1195    }
1196
1197    public int countByGroupId(long groupId) throws SystemException {
1198        Object[] finderArgs = new Object[] { new Long(groupId) };
1199
1200        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_GROUPID,
1201                finderArgs, this);
1202
1203        if (count == null) {
1204            Session session = null;
1205
1206            try {
1207                session = openSession();
1208
1209                StringBundler query = new StringBundler(2);
1210
1211                query.append(_SQL_COUNT_MEMBERSHIPREQUEST_WHERE);
1212
1213                query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
1214
1215                String sql = query.toString();
1216
1217                Query q = session.createQuery(sql);
1218
1219                QueryPos qPos = QueryPos.getInstance(q);
1220
1221                qPos.add(groupId);
1222
1223                count = (Long)q.uniqueResult();
1224            }
1225            catch (Exception e) {
1226                throw processException(e);
1227            }
1228            finally {
1229                if (count == null) {
1230                    count = Long.valueOf(0);
1231                }
1232
1233                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_GROUPID,
1234                    finderArgs, count);
1235
1236                closeSession(session);
1237            }
1238        }
1239
1240        return count.intValue();
1241    }
1242
1243    public int countByUserId(long userId) throws SystemException {
1244        Object[] finderArgs = new Object[] { new Long(userId) };
1245
1246        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_USERID,
1247                finderArgs, this);
1248
1249        if (count == null) {
1250            Session session = null;
1251
1252            try {
1253                session = openSession();
1254
1255                StringBundler query = new StringBundler(2);
1256
1257                query.append(_SQL_COUNT_MEMBERSHIPREQUEST_WHERE);
1258
1259                query.append(_FINDER_COLUMN_USERID_USERID_2);
1260
1261                String sql = query.toString();
1262
1263                Query q = session.createQuery(sql);
1264
1265                QueryPos qPos = QueryPos.getInstance(q);
1266
1267                qPos.add(userId);
1268
1269                count = (Long)q.uniqueResult();
1270            }
1271            catch (Exception e) {
1272                throw processException(e);
1273            }
1274            finally {
1275                if (count == null) {
1276                    count = Long.valueOf(0);
1277                }
1278
1279                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_USERID,
1280                    finderArgs, count);
1281
1282                closeSession(session);
1283            }
1284        }
1285
1286        return count.intValue();
1287    }
1288
1289    public int countByG_S(long groupId, int statusId) throws SystemException {
1290        Object[] finderArgs = new Object[] {
1291                new Long(groupId), new Integer(statusId)
1292            };
1293
1294        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_G_S,
1295                finderArgs, this);
1296
1297        if (count == null) {
1298            Session session = null;
1299
1300            try {
1301                session = openSession();
1302
1303                StringBundler query = new StringBundler(3);
1304
1305                query.append(_SQL_COUNT_MEMBERSHIPREQUEST_WHERE);
1306
1307                query.append(_FINDER_COLUMN_G_S_GROUPID_2);
1308
1309                query.append(_FINDER_COLUMN_G_S_STATUSID_2);
1310
1311                String sql = query.toString();
1312
1313                Query q = session.createQuery(sql);
1314
1315                QueryPos qPos = QueryPos.getInstance(q);
1316
1317                qPos.add(groupId);
1318
1319                qPos.add(statusId);
1320
1321                count = (Long)q.uniqueResult();
1322            }
1323            catch (Exception e) {
1324                throw processException(e);
1325            }
1326            finally {
1327                if (count == null) {
1328                    count = Long.valueOf(0);
1329                }
1330
1331                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_G_S, finderArgs,
1332                    count);
1333
1334                closeSession(session);
1335            }
1336        }
1337
1338        return count.intValue();
1339    }
1340
1341    public int countAll() throws SystemException {
1342        Object[] finderArgs = new Object[0];
1343
1344        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL,
1345                finderArgs, this);
1346
1347        if (count == null) {
1348            Session session = null;
1349
1350            try {
1351                session = openSession();
1352
1353                Query q = session.createQuery(_SQL_COUNT_MEMBERSHIPREQUEST);
1354
1355                count = (Long)q.uniqueResult();
1356            }
1357            catch (Exception e) {
1358                throw processException(e);
1359            }
1360            finally {
1361                if (count == null) {
1362                    count = Long.valueOf(0);
1363                }
1364
1365                FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, finderArgs,
1366                    count);
1367
1368                closeSession(session);
1369            }
1370        }
1371
1372        return count.intValue();
1373    }
1374
1375    public void afterPropertiesSet() {
1376        String[] listenerClassNames = StringUtil.split(GetterUtil.getString(
1377                    com.liferay.portal.util.PropsUtil.get(
1378                        "value.object.listener.com.liferay.portal.model.MembershipRequest")));
1379
1380        if (listenerClassNames.length > 0) {
1381            try {
1382                List<ModelListener<MembershipRequest>> listenersList = new ArrayList<ModelListener<MembershipRequest>>();
1383
1384                for (String listenerClassName : listenerClassNames) {
1385                    listenersList.add((ModelListener<MembershipRequest>)Class.forName(
1386                            listenerClassName).newInstance());
1387                }
1388
1389                listeners = listenersList.toArray(new ModelListener[listenersList.size()]);
1390            }
1391            catch (Exception e) {
1392                _log.error(e);
1393            }
1394        }
1395    }
1396
1397    @BeanReference(type = AccountPersistence.class)
1398    protected AccountPersistence accountPersistence;
1399    @BeanReference(type = AddressPersistence.class)
1400    protected AddressPersistence addressPersistence;
1401    @BeanReference(type = BrowserTrackerPersistence.class)
1402    protected BrowserTrackerPersistence browserTrackerPersistence;
1403    @BeanReference(type = ClassNamePersistence.class)
1404    protected ClassNamePersistence classNamePersistence;
1405    @BeanReference(type = CompanyPersistence.class)
1406    protected CompanyPersistence companyPersistence;
1407    @BeanReference(type = ContactPersistence.class)
1408    protected ContactPersistence contactPersistence;
1409    @BeanReference(type = CountryPersistence.class)
1410    protected CountryPersistence countryPersistence;
1411    @BeanReference(type = EmailAddressPersistence.class)
1412    protected EmailAddressPersistence emailAddressPersistence;
1413    @BeanReference(type = GroupPersistence.class)
1414    protected GroupPersistence groupPersistence;
1415    @BeanReference(type = ImagePersistence.class)
1416    protected ImagePersistence imagePersistence;
1417    @BeanReference(type = LayoutPersistence.class)
1418    protected LayoutPersistence layoutPersistence;
1419    @BeanReference(type = LayoutPrototypePersistence.class)
1420    protected LayoutPrototypePersistence layoutPrototypePersistence;
1421    @BeanReference(type = LayoutSetPersistence.class)
1422    protected LayoutSetPersistence layoutSetPersistence;
1423    @BeanReference(type = LayoutSetPrototypePersistence.class)
1424    protected LayoutSetPrototypePersistence layoutSetPrototypePersistence;
1425    @BeanReference(type = ListTypePersistence.class)
1426    protected ListTypePersistence listTypePersistence;
1427    @BeanReference(type = LockPersistence.class)
1428    protected LockPersistence lockPersistence;
1429    @BeanReference(type = MembershipRequestPersistence.class)
1430    protected MembershipRequestPersistence membershipRequestPersistence;
1431    @BeanReference(type = OrganizationPersistence.class)
1432    protected OrganizationPersistence organizationPersistence;
1433    @BeanReference(type = OrgGroupPermissionPersistence.class)
1434    protected OrgGroupPermissionPersistence orgGroupPermissionPersistence;
1435    @BeanReference(type = OrgGroupRolePersistence.class)
1436    protected OrgGroupRolePersistence orgGroupRolePersistence;
1437    @BeanReference(type = OrgLaborPersistence.class)
1438    protected OrgLaborPersistence orgLaborPersistence;
1439    @BeanReference(type = PasswordPolicyPersistence.class)
1440    protected PasswordPolicyPersistence passwordPolicyPersistence;
1441    @BeanReference(type = PasswordPolicyRelPersistence.class)
1442    protected PasswordPolicyRelPersistence passwordPolicyRelPersistence;
1443    @BeanReference(type = PasswordTrackerPersistence.class)
1444    protected PasswordTrackerPersistence passwordTrackerPersistence;
1445    @BeanReference(type = PermissionPersistence.class)
1446    protected PermissionPersistence permissionPersistence;
1447    @BeanReference(type = PhonePersistence.class)
1448    protected PhonePersistence phonePersistence;
1449    @BeanReference(type = PluginSettingPersistence.class)
1450    protected PluginSettingPersistence pluginSettingPersistence;
1451    @BeanReference(type = PortletPersistence.class)
1452    protected PortletPersistence portletPersistence;
1453    @BeanReference(type = PortletItemPersistence.class)
1454    protected PortletItemPersistence portletItemPersistence;
1455    @BeanReference(type = PortletPreferencesPersistence.class)
1456    protected PortletPreferencesPersistence portletPreferencesPersistence;
1457    @BeanReference(type = RegionPersistence.class)
1458    protected RegionPersistence regionPersistence;
1459    @BeanReference(type = ReleasePersistence.class)
1460    protected ReleasePersistence releasePersistence;
1461    @BeanReference(type = ResourcePersistence.class)
1462    protected ResourcePersistence resourcePersistence;
1463    @BeanReference(type = ResourceActionPersistence.class)
1464    protected ResourceActionPersistence resourceActionPersistence;
1465    @BeanReference(type = ResourceCodePersistence.class)
1466    protected ResourceCodePersistence resourceCodePersistence;
1467    @BeanReference(type = ResourcePermissionPersistence.class)
1468    protected ResourcePermissionPersistence resourcePermissionPersistence;
1469    @BeanReference(type = RolePersistence.class)
1470    protected RolePersistence rolePersistence;
1471    @BeanReference(type = ServiceComponentPersistence.class)
1472    protected ServiceComponentPersistence serviceComponentPersistence;
1473    @BeanReference(type = ShardPersistence.class)
1474    protected ShardPersistence shardPersistence;
1475    @BeanReference(type = SubscriptionPersistence.class)
1476    protected SubscriptionPersistence subscriptionPersistence;
1477    @BeanReference(type = TeamPersistence.class)
1478    protected TeamPersistence teamPersistence;
1479    @BeanReference(type = UserPersistence.class)
1480    protected UserPersistence userPersistence;
1481    @BeanReference(type = UserGroupPersistence.class)
1482    protected UserGroupPersistence userGroupPersistence;
1483    @BeanReference(type = UserGroupGroupRolePersistence.class)
1484    protected UserGroupGroupRolePersistence userGroupGroupRolePersistence;
1485    @BeanReference(type = UserGroupRolePersistence.class)
1486    protected UserGroupRolePersistence userGroupRolePersistence;
1487    @BeanReference(type = UserIdMapperPersistence.class)
1488    protected UserIdMapperPersistence userIdMapperPersistence;
1489    @BeanReference(type = UserTrackerPersistence.class)
1490    protected UserTrackerPersistence userTrackerPersistence;
1491    @BeanReference(type = UserTrackerPathPersistence.class)
1492    protected UserTrackerPathPersistence userTrackerPathPersistence;
1493    @BeanReference(type = WebDAVPropsPersistence.class)
1494    protected WebDAVPropsPersistence webDAVPropsPersistence;
1495    @BeanReference(type = WebsitePersistence.class)
1496    protected WebsitePersistence websitePersistence;
1497    @BeanReference(type = WorkflowDefinitionLinkPersistence.class)
1498    protected WorkflowDefinitionLinkPersistence workflowDefinitionLinkPersistence;
1499    @BeanReference(type = WorkflowInstanceLinkPersistence.class)
1500    protected WorkflowInstanceLinkPersistence workflowInstanceLinkPersistence;
1501    private static final String _SQL_SELECT_MEMBERSHIPREQUEST = "SELECT membershipRequest FROM MembershipRequest membershipRequest";
1502    private static final String _SQL_SELECT_MEMBERSHIPREQUEST_WHERE = "SELECT membershipRequest FROM MembershipRequest membershipRequest WHERE ";
1503    private static final String _SQL_COUNT_MEMBERSHIPREQUEST = "SELECT COUNT(membershipRequest) FROM MembershipRequest membershipRequest";
1504    private static final String _SQL_COUNT_MEMBERSHIPREQUEST_WHERE = "SELECT COUNT(membershipRequest) FROM MembershipRequest membershipRequest WHERE ";
1505    private static final String _FINDER_COLUMN_GROUPID_GROUPID_2 = "membershipRequest.groupId = ?";
1506    private static final String _FINDER_COLUMN_USERID_USERID_2 = "membershipRequest.userId = ?";
1507    private static final String _FINDER_COLUMN_G_S_GROUPID_2 = "membershipRequest.groupId = ? AND ";
1508    private static final String _FINDER_COLUMN_G_S_STATUSID_2 = "membershipRequest.statusId = ?";
1509    private static final String _ORDER_BY_ENTITY_ALIAS = "membershipRequest.";
1510    private static final String _NO_SUCH_ENTITY_WITH_PRIMARY_KEY = "No MembershipRequest exists with the primary key ";
1511    private static final String _NO_SUCH_ENTITY_WITH_KEY = "No MembershipRequest exists with the key {";
1512    private static Log _log = LogFactoryUtil.getLog(MembershipRequestPersistenceImpl.class);
1513}