1   /**
2    * Copyright (c) 2000-2010 Liferay, Inc. All rights reserved.
3    *
4    * The contents of this file are subject to the terms of the Liferay Enterprise
5    * Subscription License ("License"). You may not use this file except in
6    * compliance with the License. You can obtain a copy of the License by
7    * contacting Liferay, Inc. See the License for the specific language governing
8    * permissions and limitations under the License, including but not limited to
9    * distribution rights of the Software.
10   *
11   *
12   * 
13   */
14  
15  package com.liferay.portal.service.persistence;
16  
17  import com.liferay.portal.NoSuchEmailAddressException;
18  import com.liferay.portal.NoSuchModelException;
19  import com.liferay.portal.SystemException;
20  import com.liferay.portal.kernel.annotation.BeanReference;
21  import com.liferay.portal.kernel.cache.CacheRegistry;
22  import com.liferay.portal.kernel.dao.orm.DynamicQuery;
23  import com.liferay.portal.kernel.dao.orm.EntityCacheUtil;
24  import com.liferay.portal.kernel.dao.orm.FinderCacheUtil;
25  import com.liferay.portal.kernel.dao.orm.FinderPath;
26  import com.liferay.portal.kernel.dao.orm.Query;
27  import com.liferay.portal.kernel.dao.orm.QueryPos;
28  import com.liferay.portal.kernel.dao.orm.QueryUtil;
29  import com.liferay.portal.kernel.dao.orm.Session;
30  import com.liferay.portal.kernel.log.Log;
31  import com.liferay.portal.kernel.log.LogFactoryUtil;
32  import com.liferay.portal.kernel.util.GetterUtil;
33  import com.liferay.portal.kernel.util.OrderByComparator;
34  import com.liferay.portal.kernel.util.StringBundler;
35  import com.liferay.portal.kernel.util.StringPool;
36  import com.liferay.portal.kernel.util.StringUtil;
37  import com.liferay.portal.model.EmailAddress;
38  import com.liferay.portal.model.ModelListener;
39  import com.liferay.portal.model.impl.EmailAddressImpl;
40  import com.liferay.portal.model.impl.EmailAddressModelImpl;
41  import com.liferay.portal.service.persistence.impl.BasePersistenceImpl;
42  
43  import java.io.Serializable;
44  
45  import java.util.ArrayList;
46  import java.util.Collections;
47  import java.util.List;
48  
49  /**
50   * <a href="EmailAddressPersistenceImpl.java.html"><b><i>View Source</i></b></a>
51   *
52   * <p>
53   * ServiceBuilder generated this class. Modifications in this class will be
54   * overwritten the next time is generated.
55   * </p>
56   *
57   * @author    Brian Wing Shun Chan
58   * @see       EmailAddressPersistence
59   * @see       EmailAddressUtil
60   * @generated
61   */
62  public class EmailAddressPersistenceImpl extends BasePersistenceImpl<EmailAddress>
63      implements EmailAddressPersistence {
64      public static final String FINDER_CLASS_NAME_ENTITY = EmailAddressImpl.class.getName();
65      public static final String FINDER_CLASS_NAME_LIST = FINDER_CLASS_NAME_ENTITY +
66          ".List";
67      public static final FinderPath FINDER_PATH_FIND_BY_COMPANYID = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
68              EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
69              "findByCompanyId", new String[] { Long.class.getName() });
70      public static final FinderPath FINDER_PATH_FIND_BY_OBC_COMPANYID = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
71              EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
72              "findByCompanyId",
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_COMPANYID = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
80              EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
81              "countByCompanyId", new String[] { Long.class.getName() });
82      public static final FinderPath FINDER_PATH_FIND_BY_USERID = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
83              EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
84              "findByUserId", new String[] { Long.class.getName() });
85      public static final FinderPath FINDER_PATH_FIND_BY_OBC_USERID = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
86              EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
87              "findByUserId",
88              new String[] {
89                  Long.class.getName(),
90                  
91              "java.lang.Integer", "java.lang.Integer",
92                  "com.liferay.portal.kernel.util.OrderByComparator"
93              });
94      public static final FinderPath FINDER_PATH_COUNT_BY_USERID = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
95              EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
96              "countByUserId", new String[] { Long.class.getName() });
97      public static final FinderPath FINDER_PATH_FIND_BY_C_C = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
98              EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
99              "findByC_C",
100             new String[] { Long.class.getName(), Long.class.getName() });
101     public static final FinderPath FINDER_PATH_FIND_BY_OBC_C_C = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
102             EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
103             "findByC_C",
104             new String[] {
105                 Long.class.getName(), Long.class.getName(),
106                 
107             "java.lang.Integer", "java.lang.Integer",
108                 "com.liferay.portal.kernel.util.OrderByComparator"
109             });
110     public static final FinderPath FINDER_PATH_COUNT_BY_C_C = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
111             EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
112             "countByC_C",
113             new String[] { Long.class.getName(), Long.class.getName() });
114     public static final FinderPath FINDER_PATH_FIND_BY_C_C_C = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
115             EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
116             "findByC_C_C",
117             new String[] {
118                 Long.class.getName(), Long.class.getName(), Long.class.getName()
119             });
120     public static final FinderPath FINDER_PATH_FIND_BY_OBC_C_C_C = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
121             EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
122             "findByC_C_C",
123             new String[] {
124                 Long.class.getName(), Long.class.getName(), Long.class.getName(),
125                 
126             "java.lang.Integer", "java.lang.Integer",
127                 "com.liferay.portal.kernel.util.OrderByComparator"
128             });
129     public static final FinderPath FINDER_PATH_COUNT_BY_C_C_C = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
130             EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
131             "countByC_C_C",
132             new String[] {
133                 Long.class.getName(), Long.class.getName(), Long.class.getName()
134             });
135     public static final FinderPath FINDER_PATH_FIND_BY_C_C_C_P = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
136             EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
137             "findByC_C_C_P",
138             new String[] {
139                 Long.class.getName(), Long.class.getName(), Long.class.getName(),
140                 Boolean.class.getName()
141             });
142     public static final FinderPath FINDER_PATH_FIND_BY_OBC_C_C_C_P = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
143             EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
144             "findByC_C_C_P",
145             new String[] {
146                 Long.class.getName(), Long.class.getName(), Long.class.getName(),
147                 Boolean.class.getName(),
148                 
149             "java.lang.Integer", "java.lang.Integer",
150                 "com.liferay.portal.kernel.util.OrderByComparator"
151             });
152     public static final FinderPath FINDER_PATH_COUNT_BY_C_C_C_P = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
153             EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
154             "countByC_C_C_P",
155             new String[] {
156                 Long.class.getName(), Long.class.getName(), Long.class.getName(),
157                 Boolean.class.getName()
158             });
159     public static final FinderPath FINDER_PATH_FIND_ALL = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
160             EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
161             "findAll", new String[0]);
162     public static final FinderPath FINDER_PATH_COUNT_ALL = new FinderPath(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
163             EmailAddressModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
164             "countAll", new String[0]);
165 
166     public void cacheResult(EmailAddress emailAddress) {
167         EntityCacheUtil.putResult(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
168             EmailAddressImpl.class, emailAddress.getPrimaryKey(), emailAddress);
169     }
170 
171     public void cacheResult(List<EmailAddress> emailAddresses) {
172         for (EmailAddress emailAddress : emailAddresses) {
173             if (EntityCacheUtil.getResult(
174                         EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
175                         EmailAddressImpl.class, emailAddress.getPrimaryKey(),
176                         this) == null) {
177                 cacheResult(emailAddress);
178             }
179         }
180     }
181 
182     public void clearCache() {
183         CacheRegistry.clear(EmailAddressImpl.class.getName());
184         EntityCacheUtil.clearCache(EmailAddressImpl.class.getName());
185         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_ENTITY);
186         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
187     }
188 
189     public EmailAddress create(long emailAddressId) {
190         EmailAddress emailAddress = new EmailAddressImpl();
191 
192         emailAddress.setNew(true);
193         emailAddress.setPrimaryKey(emailAddressId);
194 
195         return emailAddress;
196     }
197 
198     public EmailAddress remove(Serializable primaryKey)
199         throws NoSuchModelException, SystemException {
200         return remove(((Long)primaryKey).longValue());
201     }
202 
203     public EmailAddress remove(long emailAddressId)
204         throws NoSuchEmailAddressException, SystemException {
205         Session session = null;
206 
207         try {
208             session = openSession();
209 
210             EmailAddress emailAddress = (EmailAddress)session.get(EmailAddressImpl.class,
211                     new Long(emailAddressId));
212 
213             if (emailAddress == null) {
214                 if (_log.isWarnEnabled()) {
215                     _log.warn(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
216                         emailAddressId);
217                 }
218 
219                 throw new NoSuchEmailAddressException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
220                     emailAddressId);
221             }
222 
223             return remove(emailAddress);
224         }
225         catch (NoSuchEmailAddressException nsee) {
226             throw nsee;
227         }
228         catch (Exception e) {
229             throw processException(e);
230         }
231         finally {
232             closeSession(session);
233         }
234     }
235 
236     public EmailAddress remove(EmailAddress emailAddress)
237         throws SystemException {
238         for (ModelListener<EmailAddress> listener : listeners) {
239             listener.onBeforeRemove(emailAddress);
240         }
241 
242         emailAddress = removeImpl(emailAddress);
243 
244         for (ModelListener<EmailAddress> listener : listeners) {
245             listener.onAfterRemove(emailAddress);
246         }
247 
248         return emailAddress;
249     }
250 
251     protected EmailAddress removeImpl(EmailAddress emailAddress)
252         throws SystemException {
253         emailAddress = toUnwrappedModel(emailAddress);
254 
255         Session session = null;
256 
257         try {
258             session = openSession();
259 
260             if (emailAddress.isCachedModel() || BatchSessionUtil.isEnabled()) {
261                 Object staleObject = session.get(EmailAddressImpl.class,
262                         emailAddress.getPrimaryKeyObj());
263 
264                 if (staleObject != null) {
265                     session.evict(staleObject);
266                 }
267             }
268 
269             session.delete(emailAddress);
270 
271             session.flush();
272         }
273         catch (Exception e) {
274             throw processException(e);
275         }
276         finally {
277             closeSession(session);
278         }
279 
280         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
281 
282         EntityCacheUtil.removeResult(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
283             EmailAddressImpl.class, emailAddress.getPrimaryKey());
284 
285         return emailAddress;
286     }
287 
288     /**
289      * @deprecated Use {@link BasePersistence#update(com.liferay.portal.model.BaseModel, boolean)}.
290      */
291     public EmailAddress update(EmailAddress emailAddress)
292         throws SystemException {
293         if (_log.isWarnEnabled()) {
294             _log.warn(
295                 "Using the deprecated update(EmailAddress emailAddress) method. Use update(EmailAddress emailAddress, boolean merge) instead.");
296         }
297 
298         return update(emailAddress, false);
299     }
300 
301     public EmailAddress updateImpl(
302         com.liferay.portal.model.EmailAddress emailAddress, boolean merge)
303         throws SystemException {
304         emailAddress = toUnwrappedModel(emailAddress);
305 
306         Session session = null;
307 
308         try {
309             session = openSession();
310 
311             BatchSessionUtil.update(session, emailAddress, merge);
312 
313             emailAddress.setNew(false);
314         }
315         catch (Exception e) {
316             throw processException(e);
317         }
318         finally {
319             closeSession(session);
320         }
321 
322         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
323 
324         EntityCacheUtil.putResult(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
325             EmailAddressImpl.class, emailAddress.getPrimaryKey(), emailAddress);
326 
327         return emailAddress;
328     }
329 
330     protected EmailAddress toUnwrappedModel(EmailAddress emailAddress) {
331         if (emailAddress instanceof EmailAddressImpl) {
332             return emailAddress;
333         }
334 
335         EmailAddressImpl emailAddressImpl = new EmailAddressImpl();
336 
337         emailAddressImpl.setNew(emailAddress.isNew());
338         emailAddressImpl.setPrimaryKey(emailAddress.getPrimaryKey());
339 
340         emailAddressImpl.setEmailAddressId(emailAddress.getEmailAddressId());
341         emailAddressImpl.setCompanyId(emailAddress.getCompanyId());
342         emailAddressImpl.setUserId(emailAddress.getUserId());
343         emailAddressImpl.setUserName(emailAddress.getUserName());
344         emailAddressImpl.setCreateDate(emailAddress.getCreateDate());
345         emailAddressImpl.setModifiedDate(emailAddress.getModifiedDate());
346         emailAddressImpl.setClassNameId(emailAddress.getClassNameId());
347         emailAddressImpl.setClassPK(emailAddress.getClassPK());
348         emailAddressImpl.setAddress(emailAddress.getAddress());
349         emailAddressImpl.setTypeId(emailAddress.getTypeId());
350         emailAddressImpl.setPrimary(emailAddress.isPrimary());
351 
352         return emailAddressImpl;
353     }
354 
355     public EmailAddress findByPrimaryKey(Serializable primaryKey)
356         throws NoSuchModelException, SystemException {
357         return findByPrimaryKey(((Long)primaryKey).longValue());
358     }
359 
360     public EmailAddress findByPrimaryKey(long emailAddressId)
361         throws NoSuchEmailAddressException, SystemException {
362         EmailAddress emailAddress = fetchByPrimaryKey(emailAddressId);
363 
364         if (emailAddress == null) {
365             if (_log.isWarnEnabled()) {
366                 _log.warn(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY + emailAddressId);
367             }
368 
369             throw new NoSuchEmailAddressException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
370                 emailAddressId);
371         }
372 
373         return emailAddress;
374     }
375 
376     public EmailAddress fetchByPrimaryKey(Serializable primaryKey)
377         throws SystemException {
378         return fetchByPrimaryKey(((Long)primaryKey).longValue());
379     }
380 
381     public EmailAddress fetchByPrimaryKey(long emailAddressId)
382         throws SystemException {
383         EmailAddress emailAddress = (EmailAddress)EntityCacheUtil.getResult(EmailAddressModelImpl.ENTITY_CACHE_ENABLED,
384                 EmailAddressImpl.class, emailAddressId, this);
385 
386         if (emailAddress == null) {
387             Session session = null;
388 
389             try {
390                 session = openSession();
391 
392                 emailAddress = (EmailAddress)session.get(EmailAddressImpl.class,
393                         new Long(emailAddressId));
394             }
395             catch (Exception e) {
396                 throw processException(e);
397             }
398             finally {
399                 if (emailAddress != null) {
400                     cacheResult(emailAddress);
401                 }
402 
403                 closeSession(session);
404             }
405         }
406 
407         return emailAddress;
408     }
409 
410     public List<EmailAddress> findByCompanyId(long companyId)
411         throws SystemException {
412         Object[] finderArgs = new Object[] { new Long(companyId) };
413 
414         List<EmailAddress> list = (List<EmailAddress>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_COMPANYID,
415                 finderArgs, this);
416 
417         if (list == null) {
418             Session session = null;
419 
420             try {
421                 session = openSession();
422 
423                 StringBundler query = new StringBundler(3);
424 
425                 query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
426 
427                 query.append(_FINDER_COLUMN_COMPANYID_COMPANYID_2);
428 
429                 query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
430 
431                 String sql = query.toString();
432 
433                 Query q = session.createQuery(sql);
434 
435                 QueryPos qPos = QueryPos.getInstance(q);
436 
437                 qPos.add(companyId);
438 
439                 list = q.list();
440             }
441             catch (Exception e) {
442                 throw processException(e);
443             }
444             finally {
445                 if (list == null) {
446                     list = new ArrayList<EmailAddress>();
447                 }
448 
449                 cacheResult(list);
450 
451                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_COMPANYID,
452                     finderArgs, list);
453 
454                 closeSession(session);
455             }
456         }
457 
458         return list;
459     }
460 
461     public List<EmailAddress> findByCompanyId(long companyId, int start, int end)
462         throws SystemException {
463         return findByCompanyId(companyId, start, end, null);
464     }
465 
466     public List<EmailAddress> findByCompanyId(long companyId, int start,
467         int end, OrderByComparator obc) throws SystemException {
468         Object[] finderArgs = new Object[] {
469                 new Long(companyId),
470                 
471                 String.valueOf(start), String.valueOf(end), String.valueOf(obc)
472             };
473 
474         List<EmailAddress> list = (List<EmailAddress>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_COMPANYID,
475                 finderArgs, this);
476 
477         if (list == null) {
478             Session session = null;
479 
480             try {
481                 session = openSession();
482 
483                 StringBundler query = null;
484 
485                 if (obc != null) {
486                     query = new StringBundler(3 +
487                             (obc.getOrderByFields().length * 3));
488                 }
489                 else {
490                     query = new StringBundler(3);
491                 }
492 
493                 query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
494 
495                 query.append(_FINDER_COLUMN_COMPANYID_COMPANYID_2);
496 
497                 if (obc != null) {
498                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
499                 }
500 
501                 else {
502                     query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
503                 }
504 
505                 String sql = query.toString();
506 
507                 Query q = session.createQuery(sql);
508 
509                 QueryPos qPos = QueryPos.getInstance(q);
510 
511                 qPos.add(companyId);
512 
513                 list = (List<EmailAddress>)QueryUtil.list(q, getDialect(),
514                         start, end);
515             }
516             catch (Exception e) {
517                 throw processException(e);
518             }
519             finally {
520                 if (list == null) {
521                     list = new ArrayList<EmailAddress>();
522                 }
523 
524                 cacheResult(list);
525 
526                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_COMPANYID,
527                     finderArgs, list);
528 
529                 closeSession(session);
530             }
531         }
532 
533         return list;
534     }
535 
536     public EmailAddress findByCompanyId_First(long companyId,
537         OrderByComparator obc)
538         throws NoSuchEmailAddressException, SystemException {
539         List<EmailAddress> list = findByCompanyId(companyId, 0, 1, obc);
540 
541         if (list.isEmpty()) {
542             StringBundler msg = new StringBundler(4);
543 
544             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
545 
546             msg.append("companyId=");
547             msg.append(companyId);
548 
549             msg.append(StringPool.CLOSE_CURLY_BRACE);
550 
551             throw new NoSuchEmailAddressException(msg.toString());
552         }
553         else {
554             return list.get(0);
555         }
556     }
557 
558     public EmailAddress findByCompanyId_Last(long companyId,
559         OrderByComparator obc)
560         throws NoSuchEmailAddressException, SystemException {
561         int count = countByCompanyId(companyId);
562 
563         List<EmailAddress> list = findByCompanyId(companyId, count - 1, count,
564                 obc);
565 
566         if (list.isEmpty()) {
567             StringBundler msg = new StringBundler(4);
568 
569             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
570 
571             msg.append("companyId=");
572             msg.append(companyId);
573 
574             msg.append(StringPool.CLOSE_CURLY_BRACE);
575 
576             throw new NoSuchEmailAddressException(msg.toString());
577         }
578         else {
579             return list.get(0);
580         }
581     }
582 
583     public EmailAddress[] findByCompanyId_PrevAndNext(long emailAddressId,
584         long companyId, OrderByComparator obc)
585         throws NoSuchEmailAddressException, SystemException {
586         EmailAddress emailAddress = findByPrimaryKey(emailAddressId);
587 
588         int count = countByCompanyId(companyId);
589 
590         Session session = null;
591 
592         try {
593             session = openSession();
594 
595             StringBundler query = null;
596 
597             if (obc != null) {
598                 query = new StringBundler(3 +
599                         (obc.getOrderByFields().length * 3));
600             }
601             else {
602                 query = new StringBundler(3);
603             }
604 
605             query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
606 
607             query.append(_FINDER_COLUMN_COMPANYID_COMPANYID_2);
608 
609             if (obc != null) {
610                 appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
611             }
612 
613             else {
614                 query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
615             }
616 
617             String sql = query.toString();
618 
619             Query q = session.createQuery(sql);
620 
621             QueryPos qPos = QueryPos.getInstance(q);
622 
623             qPos.add(companyId);
624 
625             Object[] objArray = QueryUtil.getPrevAndNext(q, count, obc,
626                     emailAddress);
627 
628             EmailAddress[] array = new EmailAddressImpl[3];
629 
630             array[0] = (EmailAddress)objArray[0];
631             array[1] = (EmailAddress)objArray[1];
632             array[2] = (EmailAddress)objArray[2];
633 
634             return array;
635         }
636         catch (Exception e) {
637             throw processException(e);
638         }
639         finally {
640             closeSession(session);
641         }
642     }
643 
644     public List<EmailAddress> findByUserId(long userId)
645         throws SystemException {
646         Object[] finderArgs = new Object[] { new Long(userId) };
647 
648         List<EmailAddress> list = (List<EmailAddress>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_USERID,
649                 finderArgs, this);
650 
651         if (list == null) {
652             Session session = null;
653 
654             try {
655                 session = openSession();
656 
657                 StringBundler query = new StringBundler(3);
658 
659                 query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
660 
661                 query.append(_FINDER_COLUMN_USERID_USERID_2);
662 
663                 query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
664 
665                 String sql = query.toString();
666 
667                 Query q = session.createQuery(sql);
668 
669                 QueryPos qPos = QueryPos.getInstance(q);
670 
671                 qPos.add(userId);
672 
673                 list = q.list();
674             }
675             catch (Exception e) {
676                 throw processException(e);
677             }
678             finally {
679                 if (list == null) {
680                     list = new ArrayList<EmailAddress>();
681                 }
682 
683                 cacheResult(list);
684 
685                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_USERID,
686                     finderArgs, list);
687 
688                 closeSession(session);
689             }
690         }
691 
692         return list;
693     }
694 
695     public List<EmailAddress> findByUserId(long userId, int start, int end)
696         throws SystemException {
697         return findByUserId(userId, start, end, null);
698     }
699 
700     public List<EmailAddress> findByUserId(long userId, int start, int end,
701         OrderByComparator obc) throws SystemException {
702         Object[] finderArgs = new Object[] {
703                 new Long(userId),
704                 
705                 String.valueOf(start), String.valueOf(end), String.valueOf(obc)
706             };
707 
708         List<EmailAddress> list = (List<EmailAddress>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_USERID,
709                 finderArgs, this);
710 
711         if (list == null) {
712             Session session = null;
713 
714             try {
715                 session = openSession();
716 
717                 StringBundler query = null;
718 
719                 if (obc != null) {
720                     query = new StringBundler(3 +
721                             (obc.getOrderByFields().length * 3));
722                 }
723                 else {
724                     query = new StringBundler(3);
725                 }
726 
727                 query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
728 
729                 query.append(_FINDER_COLUMN_USERID_USERID_2);
730 
731                 if (obc != null) {
732                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
733                 }
734 
735                 else {
736                     query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
737                 }
738 
739                 String sql = query.toString();
740 
741                 Query q = session.createQuery(sql);
742 
743                 QueryPos qPos = QueryPos.getInstance(q);
744 
745                 qPos.add(userId);
746 
747                 list = (List<EmailAddress>)QueryUtil.list(q, getDialect(),
748                         start, end);
749             }
750             catch (Exception e) {
751                 throw processException(e);
752             }
753             finally {
754                 if (list == null) {
755                     list = new ArrayList<EmailAddress>();
756                 }
757 
758                 cacheResult(list);
759 
760                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_USERID,
761                     finderArgs, list);
762 
763                 closeSession(session);
764             }
765         }
766 
767         return list;
768     }
769 
770     public EmailAddress findByUserId_First(long userId, OrderByComparator obc)
771         throws NoSuchEmailAddressException, SystemException {
772         List<EmailAddress> list = findByUserId(userId, 0, 1, obc);
773 
774         if (list.isEmpty()) {
775             StringBundler msg = new StringBundler(4);
776 
777             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
778 
779             msg.append("userId=");
780             msg.append(userId);
781 
782             msg.append(StringPool.CLOSE_CURLY_BRACE);
783 
784             throw new NoSuchEmailAddressException(msg.toString());
785         }
786         else {
787             return list.get(0);
788         }
789     }
790 
791     public EmailAddress findByUserId_Last(long userId, OrderByComparator obc)
792         throws NoSuchEmailAddressException, SystemException {
793         int count = countByUserId(userId);
794 
795         List<EmailAddress> list = findByUserId(userId, count - 1, count, obc);
796 
797         if (list.isEmpty()) {
798             StringBundler msg = new StringBundler(4);
799 
800             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
801 
802             msg.append("userId=");
803             msg.append(userId);
804 
805             msg.append(StringPool.CLOSE_CURLY_BRACE);
806 
807             throw new NoSuchEmailAddressException(msg.toString());
808         }
809         else {
810             return list.get(0);
811         }
812     }
813 
814     public EmailAddress[] findByUserId_PrevAndNext(long emailAddressId,
815         long userId, OrderByComparator obc)
816         throws NoSuchEmailAddressException, SystemException {
817         EmailAddress emailAddress = findByPrimaryKey(emailAddressId);
818 
819         int count = countByUserId(userId);
820 
821         Session session = null;
822 
823         try {
824             session = openSession();
825 
826             StringBundler query = null;
827 
828             if (obc != null) {
829                 query = new StringBundler(3 +
830                         (obc.getOrderByFields().length * 3));
831             }
832             else {
833                 query = new StringBundler(3);
834             }
835 
836             query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
837 
838             query.append(_FINDER_COLUMN_USERID_USERID_2);
839 
840             if (obc != null) {
841                 appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
842             }
843 
844             else {
845                 query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
846             }
847 
848             String sql = query.toString();
849 
850             Query q = session.createQuery(sql);
851 
852             QueryPos qPos = QueryPos.getInstance(q);
853 
854             qPos.add(userId);
855 
856             Object[] objArray = QueryUtil.getPrevAndNext(q, count, obc,
857                     emailAddress);
858 
859             EmailAddress[] array = new EmailAddressImpl[3];
860 
861             array[0] = (EmailAddress)objArray[0];
862             array[1] = (EmailAddress)objArray[1];
863             array[2] = (EmailAddress)objArray[2];
864 
865             return array;
866         }
867         catch (Exception e) {
868             throw processException(e);
869         }
870         finally {
871             closeSession(session);
872         }
873     }
874 
875     public List<EmailAddress> findByC_C(long companyId, long classNameId)
876         throws SystemException {
877         Object[] finderArgs = new Object[] {
878                 new Long(companyId), new Long(classNameId)
879             };
880 
881         List<EmailAddress> list = (List<EmailAddress>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_C_C,
882                 finderArgs, this);
883 
884         if (list == null) {
885             Session session = null;
886 
887             try {
888                 session = openSession();
889 
890                 StringBundler query = new StringBundler(4);
891 
892                 query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
893 
894                 query.append(_FINDER_COLUMN_C_C_COMPANYID_2);
895 
896                 query.append(_FINDER_COLUMN_C_C_CLASSNAMEID_2);
897 
898                 query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
899 
900                 String sql = query.toString();
901 
902                 Query q = session.createQuery(sql);
903 
904                 QueryPos qPos = QueryPos.getInstance(q);
905 
906                 qPos.add(companyId);
907 
908                 qPos.add(classNameId);
909 
910                 list = q.list();
911             }
912             catch (Exception e) {
913                 throw processException(e);
914             }
915             finally {
916                 if (list == null) {
917                     list = new ArrayList<EmailAddress>();
918                 }
919 
920                 cacheResult(list);
921 
922                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_C_C, finderArgs,
923                     list);
924 
925                 closeSession(session);
926             }
927         }
928 
929         return list;
930     }
931 
932     public List<EmailAddress> findByC_C(long companyId, long classNameId,
933         int start, int end) throws SystemException {
934         return findByC_C(companyId, classNameId, start, end, null);
935     }
936 
937     public List<EmailAddress> findByC_C(long companyId, long classNameId,
938         int start, int end, OrderByComparator obc) throws SystemException {
939         Object[] finderArgs = new Object[] {
940                 new Long(companyId), new Long(classNameId),
941                 
942                 String.valueOf(start), String.valueOf(end), String.valueOf(obc)
943             };
944 
945         List<EmailAddress> list = (List<EmailAddress>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_C_C,
946                 finderArgs, this);
947 
948         if (list == null) {
949             Session session = null;
950 
951             try {
952                 session = openSession();
953 
954                 StringBundler query = null;
955 
956                 if (obc != null) {
957                     query = new StringBundler(4 +
958                             (obc.getOrderByFields().length * 3));
959                 }
960                 else {
961                     query = new StringBundler(4);
962                 }
963 
964                 query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
965 
966                 query.append(_FINDER_COLUMN_C_C_COMPANYID_2);
967 
968                 query.append(_FINDER_COLUMN_C_C_CLASSNAMEID_2);
969 
970                 if (obc != null) {
971                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
972                 }
973 
974                 else {
975                     query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
976                 }
977 
978                 String sql = query.toString();
979 
980                 Query q = session.createQuery(sql);
981 
982                 QueryPos qPos = QueryPos.getInstance(q);
983 
984                 qPos.add(companyId);
985 
986                 qPos.add(classNameId);
987 
988                 list = (List<EmailAddress>)QueryUtil.list(q, getDialect(),
989                         start, end);
990             }
991             catch (Exception e) {
992                 throw processException(e);
993             }
994             finally {
995                 if (list == null) {
996                     list = new ArrayList<EmailAddress>();
997                 }
998 
999                 cacheResult(list);
1000
1001                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_C_C,
1002                    finderArgs, list);
1003
1004                closeSession(session);
1005            }
1006        }
1007
1008        return list;
1009    }
1010
1011    public EmailAddress findByC_C_First(long companyId, long classNameId,
1012        OrderByComparator obc)
1013        throws NoSuchEmailAddressException, SystemException {
1014        List<EmailAddress> list = findByC_C(companyId, classNameId, 0, 1, obc);
1015
1016        if (list.isEmpty()) {
1017            StringBundler msg = new StringBundler(6);
1018
1019            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1020
1021            msg.append("companyId=");
1022            msg.append(companyId);
1023
1024            msg.append(", classNameId=");
1025            msg.append(classNameId);
1026
1027            msg.append(StringPool.CLOSE_CURLY_BRACE);
1028
1029            throw new NoSuchEmailAddressException(msg.toString());
1030        }
1031        else {
1032            return list.get(0);
1033        }
1034    }
1035
1036    public EmailAddress findByC_C_Last(long companyId, long classNameId,
1037        OrderByComparator obc)
1038        throws NoSuchEmailAddressException, SystemException {
1039        int count = countByC_C(companyId, classNameId);
1040
1041        List<EmailAddress> list = findByC_C(companyId, classNameId, count - 1,
1042                count, obc);
1043
1044        if (list.isEmpty()) {
1045            StringBundler msg = new StringBundler(6);
1046
1047            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1048
1049            msg.append("companyId=");
1050            msg.append(companyId);
1051
1052            msg.append(", classNameId=");
1053            msg.append(classNameId);
1054
1055            msg.append(StringPool.CLOSE_CURLY_BRACE);
1056
1057            throw new NoSuchEmailAddressException(msg.toString());
1058        }
1059        else {
1060            return list.get(0);
1061        }
1062    }
1063
1064    public EmailAddress[] findByC_C_PrevAndNext(long emailAddressId,
1065        long companyId, long classNameId, OrderByComparator obc)
1066        throws NoSuchEmailAddressException, SystemException {
1067        EmailAddress emailAddress = findByPrimaryKey(emailAddressId);
1068
1069        int count = countByC_C(companyId, classNameId);
1070
1071        Session session = null;
1072
1073        try {
1074            session = openSession();
1075
1076            StringBundler query = null;
1077
1078            if (obc != null) {
1079                query = new StringBundler(4 +
1080                        (obc.getOrderByFields().length * 3));
1081            }
1082            else {
1083                query = new StringBundler(4);
1084            }
1085
1086            query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
1087
1088            query.append(_FINDER_COLUMN_C_C_COMPANYID_2);
1089
1090            query.append(_FINDER_COLUMN_C_C_CLASSNAMEID_2);
1091
1092            if (obc != null) {
1093                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
1094            }
1095
1096            else {
1097                query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
1098            }
1099
1100            String sql = query.toString();
1101
1102            Query q = session.createQuery(sql);
1103
1104            QueryPos qPos = QueryPos.getInstance(q);
1105
1106            qPos.add(companyId);
1107
1108            qPos.add(classNameId);
1109
1110            Object[] objArray = QueryUtil.getPrevAndNext(q, count, obc,
1111                    emailAddress);
1112
1113            EmailAddress[] array = new EmailAddressImpl[3];
1114
1115            array[0] = (EmailAddress)objArray[0];
1116            array[1] = (EmailAddress)objArray[1];
1117            array[2] = (EmailAddress)objArray[2];
1118
1119            return array;
1120        }
1121        catch (Exception e) {
1122            throw processException(e);
1123        }
1124        finally {
1125            closeSession(session);
1126        }
1127    }
1128
1129    public List<EmailAddress> findByC_C_C(long companyId, long classNameId,
1130        long classPK) throws SystemException {
1131        Object[] finderArgs = new Object[] {
1132                new Long(companyId), new Long(classNameId), new Long(classPK)
1133            };
1134
1135        List<EmailAddress> list = (List<EmailAddress>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_C_C_C,
1136                finderArgs, this);
1137
1138        if (list == null) {
1139            Session session = null;
1140
1141            try {
1142                session = openSession();
1143
1144                StringBundler query = new StringBundler(5);
1145
1146                query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
1147
1148                query.append(_FINDER_COLUMN_C_C_C_COMPANYID_2);
1149
1150                query.append(_FINDER_COLUMN_C_C_C_CLASSNAMEID_2);
1151
1152                query.append(_FINDER_COLUMN_C_C_C_CLASSPK_2);
1153
1154                query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
1155
1156                String sql = query.toString();
1157
1158                Query q = session.createQuery(sql);
1159
1160                QueryPos qPos = QueryPos.getInstance(q);
1161
1162                qPos.add(companyId);
1163
1164                qPos.add(classNameId);
1165
1166                qPos.add(classPK);
1167
1168                list = q.list();
1169            }
1170            catch (Exception e) {
1171                throw processException(e);
1172            }
1173            finally {
1174                if (list == null) {
1175                    list = new ArrayList<EmailAddress>();
1176                }
1177
1178                cacheResult(list);
1179
1180                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_C_C_C,
1181                    finderArgs, list);
1182
1183                closeSession(session);
1184            }
1185        }
1186
1187        return list;
1188    }
1189
1190    public List<EmailAddress> findByC_C_C(long companyId, long classNameId,
1191        long classPK, int start, int end) throws SystemException {
1192        return findByC_C_C(companyId, classNameId, classPK, start, end, null);
1193    }
1194
1195    public List<EmailAddress> findByC_C_C(long companyId, long classNameId,
1196        long classPK, int start, int end, OrderByComparator obc)
1197        throws SystemException {
1198        Object[] finderArgs = new Object[] {
1199                new Long(companyId), new Long(classNameId), new Long(classPK),
1200                
1201                String.valueOf(start), String.valueOf(end), String.valueOf(obc)
1202            };
1203
1204        List<EmailAddress> list = (List<EmailAddress>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_C_C_C,
1205                finderArgs, this);
1206
1207        if (list == null) {
1208            Session session = null;
1209
1210            try {
1211                session = openSession();
1212
1213                StringBundler query = null;
1214
1215                if (obc != null) {
1216                    query = new StringBundler(5 +
1217                            (obc.getOrderByFields().length * 3));
1218                }
1219                else {
1220                    query = new StringBundler(5);
1221                }
1222
1223                query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
1224
1225                query.append(_FINDER_COLUMN_C_C_C_COMPANYID_2);
1226
1227                query.append(_FINDER_COLUMN_C_C_C_CLASSNAMEID_2);
1228
1229                query.append(_FINDER_COLUMN_C_C_C_CLASSPK_2);
1230
1231                if (obc != null) {
1232                    appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
1233                }
1234
1235                else {
1236                    query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
1237                }
1238
1239                String sql = query.toString();
1240
1241                Query q = session.createQuery(sql);
1242
1243                QueryPos qPos = QueryPos.getInstance(q);
1244
1245                qPos.add(companyId);
1246
1247                qPos.add(classNameId);
1248
1249                qPos.add(classPK);
1250
1251                list = (List<EmailAddress>)QueryUtil.list(q, getDialect(),
1252                        start, end);
1253            }
1254            catch (Exception e) {
1255                throw processException(e);
1256            }
1257            finally {
1258                if (list == null) {
1259                    list = new ArrayList<EmailAddress>();
1260                }
1261
1262                cacheResult(list);
1263
1264                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_C_C_C,
1265                    finderArgs, list);
1266
1267                closeSession(session);
1268            }
1269        }
1270
1271        return list;
1272    }
1273
1274    public EmailAddress findByC_C_C_First(long companyId, long classNameId,
1275        long classPK, OrderByComparator obc)
1276        throws NoSuchEmailAddressException, SystemException {
1277        List<EmailAddress> list = findByC_C_C(companyId, classNameId, classPK,
1278                0, 1, obc);
1279
1280        if (list.isEmpty()) {
1281            StringBundler msg = new StringBundler(8);
1282
1283            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1284
1285            msg.append("companyId=");
1286            msg.append(companyId);
1287
1288            msg.append(", classNameId=");
1289            msg.append(classNameId);
1290
1291            msg.append(", classPK=");
1292            msg.append(classPK);
1293
1294            msg.append(StringPool.CLOSE_CURLY_BRACE);
1295
1296            throw new NoSuchEmailAddressException(msg.toString());
1297        }
1298        else {
1299            return list.get(0);
1300        }
1301    }
1302
1303    public EmailAddress findByC_C_C_Last(long companyId, long classNameId,
1304        long classPK, OrderByComparator obc)
1305        throws NoSuchEmailAddressException, SystemException {
1306        int count = countByC_C_C(companyId, classNameId, classPK);
1307
1308        List<EmailAddress> list = findByC_C_C(companyId, classNameId, classPK,
1309                count - 1, count, obc);
1310
1311        if (list.isEmpty()) {
1312            StringBundler msg = new StringBundler(8);
1313
1314            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1315
1316            msg.append("companyId=");
1317            msg.append(companyId);
1318
1319            msg.append(", classNameId=");
1320            msg.append(classNameId);
1321
1322            msg.append(", classPK=");
1323            msg.append(classPK);
1324
1325            msg.append(StringPool.CLOSE_CURLY_BRACE);
1326
1327            throw new NoSuchEmailAddressException(msg.toString());
1328        }
1329        else {
1330            return list.get(0);
1331        }
1332    }
1333
1334    public EmailAddress[] findByC_C_C_PrevAndNext(long emailAddressId,
1335        long companyId, long classNameId, long classPK, OrderByComparator obc)
1336        throws NoSuchEmailAddressException, SystemException {
1337        EmailAddress emailAddress = findByPrimaryKey(emailAddressId);
1338
1339        int count = countByC_C_C(companyId, classNameId, classPK);
1340
1341        Session session = null;
1342
1343        try {
1344            session = openSession();
1345
1346            StringBundler query = null;
1347
1348            if (obc != null) {
1349                query = new StringBundler(5 +
1350                        (obc.getOrderByFields().length * 3));
1351            }
1352            else {
1353                query = new StringBundler(5);
1354            }
1355
1356            query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
1357
1358            query.append(_FINDER_COLUMN_C_C_C_COMPANYID_2);
1359
1360            query.append(_FINDER_COLUMN_C_C_C_CLASSNAMEID_2);
1361
1362            query.append(_FINDER_COLUMN_C_C_C_CLASSPK_2);
1363
1364            if (obc != null) {
1365                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
1366            }
1367
1368            else {
1369                query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
1370            }
1371
1372            String sql = query.toString();
1373
1374            Query q = session.createQuery(sql);
1375
1376            QueryPos qPos = QueryPos.getInstance(q);
1377
1378            qPos.add(companyId);
1379
1380            qPos.add(classNameId);
1381
1382            qPos.add(classPK);
1383
1384            Object[] objArray = QueryUtil.getPrevAndNext(q, count, obc,
1385                    emailAddress);
1386
1387            EmailAddress[] array = new EmailAddressImpl[3];
1388
1389            array[0] = (EmailAddress)objArray[0];
1390            array[1] = (EmailAddress)objArray[1];
1391            array[2] = (EmailAddress)objArray[2];
1392
1393            return array;
1394        }
1395        catch (Exception e) {
1396            throw processException(e);
1397        }
1398        finally {
1399            closeSession(session);
1400        }
1401    }
1402
1403    public List<EmailAddress> findByC_C_C_P(long companyId, long classNameId,
1404        long classPK, boolean primary) throws SystemException {
1405        Object[] finderArgs = new Object[] {
1406                new Long(companyId), new Long(classNameId), new Long(classPK),
1407                Boolean.valueOf(primary)
1408            };
1409
1410        List<EmailAddress> list = (List<EmailAddress>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_C_C_C_P,
1411                finderArgs, this);
1412
1413        if (list == null) {
1414            Session session = null;
1415
1416            try {
1417                session = openSession();
1418
1419                StringBundler query = new StringBundler(6);
1420
1421                query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
1422
1423                query.append(_FINDER_COLUMN_C_C_C_P_COMPANYID_2);
1424
1425                query.append(_FINDER_COLUMN_C_C_C_P_CLASSNAMEID_2);
1426
1427                query.append(_FINDER_COLUMN_C_C_C_P_CLASSPK_2);
1428
1429                query.append(_FINDER_COLUMN_C_C_C_P_PRIMARY_2);
1430
1431                query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
1432
1433                String sql = query.toString();
1434
1435                Query q = session.createQuery(sql);
1436
1437                QueryPos qPos = QueryPos.getInstance(q);
1438
1439                qPos.add(companyId);
1440
1441                qPos.add(classNameId);
1442
1443                qPos.add(classPK);
1444
1445                qPos.add(primary);
1446
1447                list = q.list();
1448            }
1449            catch (Exception e) {
1450                throw processException(e);
1451            }
1452            finally {
1453                if (list == null) {
1454                    list = new ArrayList<EmailAddress>();
1455                }
1456
1457                cacheResult(list);
1458
1459                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_C_C_C_P,
1460                    finderArgs, list);
1461
1462                closeSession(session);
1463            }
1464        }
1465
1466        return list;
1467    }
1468
1469    public List<EmailAddress> findByC_C_C_P(long companyId, long classNameId,
1470        long classPK, boolean primary, int start, int end)
1471        throws SystemException {
1472        return findByC_C_C_P(companyId, classNameId, classPK, primary, start,
1473            end, null);
1474    }
1475
1476    public List<EmailAddress> findByC_C_C_P(long companyId, long classNameId,
1477        long classPK, boolean primary, int start, int end, OrderByComparator obc)
1478        throws SystemException {
1479        Object[] finderArgs = new Object[] {
1480                new Long(companyId), new Long(classNameId), new Long(classPK),
1481                Boolean.valueOf(primary),
1482                
1483                String.valueOf(start), String.valueOf(end), String.valueOf(obc)
1484            };
1485
1486        List<EmailAddress> list = (List<EmailAddress>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_C_C_C_P,
1487                finderArgs, this);
1488
1489        if (list == null) {
1490            Session session = null;
1491
1492            try {
1493                session = openSession();
1494
1495                StringBundler query = null;
1496
1497                if (obc != null) {
1498                    query = new StringBundler(6 +
1499                            (obc.getOrderByFields().length * 3));
1500                }
1501                else {
1502                    query = new StringBundler(6);
1503                }
1504
1505                query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
1506
1507                query.append(_FINDER_COLUMN_C_C_C_P_COMPANYID_2);
1508
1509                query.append(_FINDER_COLUMN_C_C_C_P_CLASSNAMEID_2);
1510
1511                query.append(_FINDER_COLUMN_C_C_C_P_CLASSPK_2);
1512
1513                query.append(_FINDER_COLUMN_C_C_C_P_PRIMARY_2);
1514
1515                if (obc != null) {
1516                    appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
1517                }
1518
1519                else {
1520                    query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
1521                }
1522
1523                String sql = query.toString();
1524
1525                Query q = session.createQuery(sql);
1526
1527                QueryPos qPos = QueryPos.getInstance(q);
1528
1529                qPos.add(companyId);
1530
1531                qPos.add(classNameId);
1532
1533                qPos.add(classPK);
1534
1535                qPos.add(primary);
1536
1537                list = (List<EmailAddress>)QueryUtil.list(q, getDialect(),
1538                        start, end);
1539            }
1540            catch (Exception e) {
1541                throw processException(e);
1542            }
1543            finally {
1544                if (list == null) {
1545                    list = new ArrayList<EmailAddress>();
1546                }
1547
1548                cacheResult(list);
1549
1550                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_C_C_C_P,
1551                    finderArgs, list);
1552
1553                closeSession(session);
1554            }
1555        }
1556
1557        return list;
1558    }
1559
1560    public EmailAddress findByC_C_C_P_First(long companyId, long classNameId,
1561        long classPK, boolean primary, OrderByComparator obc)
1562        throws NoSuchEmailAddressException, SystemException {
1563        List<EmailAddress> list = findByC_C_C_P(companyId, classNameId,
1564                classPK, primary, 0, 1, obc);
1565
1566        if (list.isEmpty()) {
1567            StringBundler msg = new StringBundler(10);
1568
1569            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1570
1571            msg.append("companyId=");
1572            msg.append(companyId);
1573
1574            msg.append(", classNameId=");
1575            msg.append(classNameId);
1576
1577            msg.append(", classPK=");
1578            msg.append(classPK);
1579
1580            msg.append(", primary=");
1581            msg.append(primary);
1582
1583            msg.append(StringPool.CLOSE_CURLY_BRACE);
1584
1585            throw new NoSuchEmailAddressException(msg.toString());
1586        }
1587        else {
1588            return list.get(0);
1589        }
1590    }
1591
1592    public EmailAddress findByC_C_C_P_Last(long companyId, long classNameId,
1593        long classPK, boolean primary, OrderByComparator obc)
1594        throws NoSuchEmailAddressException, SystemException {
1595        int count = countByC_C_C_P(companyId, classNameId, classPK, primary);
1596
1597        List<EmailAddress> list = findByC_C_C_P(companyId, classNameId,
1598                classPK, primary, count - 1, count, obc);
1599
1600        if (list.isEmpty()) {
1601            StringBundler msg = new StringBundler(10);
1602
1603            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1604
1605            msg.append("companyId=");
1606            msg.append(companyId);
1607
1608            msg.append(", classNameId=");
1609            msg.append(classNameId);
1610
1611            msg.append(", classPK=");
1612            msg.append(classPK);
1613
1614            msg.append(", primary=");
1615            msg.append(primary);
1616
1617            msg.append(StringPool.CLOSE_CURLY_BRACE);
1618
1619            throw new NoSuchEmailAddressException(msg.toString());
1620        }
1621        else {
1622            return list.get(0);
1623        }
1624    }
1625
1626    public EmailAddress[] findByC_C_C_P_PrevAndNext(long emailAddressId,
1627        long companyId, long classNameId, long classPK, boolean primary,
1628        OrderByComparator obc)
1629        throws NoSuchEmailAddressException, SystemException {
1630        EmailAddress emailAddress = findByPrimaryKey(emailAddressId);
1631
1632        int count = countByC_C_C_P(companyId, classNameId, classPK, primary);
1633
1634        Session session = null;
1635
1636        try {
1637            session = openSession();
1638
1639            StringBundler query = null;
1640
1641            if (obc != null) {
1642                query = new StringBundler(6 +
1643                        (obc.getOrderByFields().length * 3));
1644            }
1645            else {
1646                query = new StringBundler(6);
1647            }
1648
1649            query.append(_SQL_SELECT_EMAILADDRESS_WHERE);
1650
1651            query.append(_FINDER_COLUMN_C_C_C_P_COMPANYID_2);
1652
1653            query.append(_FINDER_COLUMN_C_C_C_P_CLASSNAMEID_2);
1654
1655            query.append(_FINDER_COLUMN_C_C_C_P_CLASSPK_2);
1656
1657            query.append(_FINDER_COLUMN_C_C_C_P_PRIMARY_2);
1658
1659            if (obc != null) {
1660                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
1661            }
1662
1663            else {
1664                query.append(EmailAddressModelImpl.ORDER_BY_JPQL);
1665            }
1666
1667            String sql = query.toString();
1668
1669            Query q = session.createQuery(sql);
1670
1671            QueryPos qPos = QueryPos.getInstance(q);
1672
1673            qPos.add(companyId);
1674
1675            qPos.add(classNameId);
1676
1677            qPos.add(classPK);
1678
1679            qPos.add(primary);
1680
1681            Object[] objArray = QueryUtil.getPrevAndNext(q, count, obc,
1682                    emailAddress);
1683
1684            EmailAddress[] array = new EmailAddressImpl[3];
1685
1686            array[0] = (EmailAddress)objArray[0];
1687            array[1] = (EmailAddress)objArray[1];
1688            array[2] = (EmailAddress)objArray[2];
1689
1690            return array;
1691        }
1692        catch (Exception e) {
1693            throw processException(e);
1694        }
1695        finally {
1696            closeSession(session);
1697        }
1698    }
1699
1700    public List<Object> findWithDynamicQuery(DynamicQuery dynamicQuery)
1701        throws SystemException {
1702        Session session = null;
1703
1704        try {
1705            session = openSession();
1706
1707            dynamicQuery.compile(session);
1708
1709            return dynamicQuery.list();
1710        }
1711        catch (Exception e) {
1712            throw processException(e);
1713        }
1714        finally {
1715            closeSession(session);
1716        }
1717    }
1718
1719    public List<Object> findWithDynamicQuery(DynamicQuery dynamicQuery,
1720        int start, int end) throws SystemException {
1721        Session session = null;
1722
1723        try {
1724            session = openSession();
1725
1726            dynamicQuery.setLimit(start, end);
1727
1728            dynamicQuery.compile(session);
1729
1730            return dynamicQuery.list();
1731        }
1732        catch (Exception e) {
1733            throw processException(e);
1734        }
1735        finally {
1736            closeSession(session);
1737        }
1738    }
1739
1740    public List<EmailAddress> findAll() throws SystemException {
1741        return findAll(QueryUtil.ALL_POS, QueryUtil.ALL_POS, null);
1742    }
1743
1744    public List<EmailAddress> findAll(int start, int end)
1745        throws SystemException {
1746        return findAll(start, end, null);
1747    }
1748
1749    public List<EmailAddress> findAll(int start, int end, OrderByComparator obc)
1750        throws SystemException {
1751        Object[] finderArgs = new Object[] {
1752                String.valueOf(start), String.valueOf(end), String.valueOf(obc)
1753            };
1754
1755        List<EmailAddress> list = (List<EmailAddress>)FinderCacheUtil.getResult(FINDER_PATH_FIND_ALL,
1756                finderArgs, this);
1757
1758        if (list == null) {
1759            Session session = null;
1760
1761            try {
1762                session = openSession();
1763
1764                StringBundler query = null;
1765                String sql = null;
1766
1767                if (obc != null) {
1768                    query = new StringBundler(2 +
1769                            (obc.getOrderByFields().length * 3));
1770
1771                    query.append(_SQL_SELECT_EMAILADDRESS);
1772
1773                    appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
1774
1775                    sql = query.toString();
1776                }
1777
1778                else {
1779                    sql = _SQL_SELECT_EMAILADDRESS.concat(EmailAddressModelImpl.ORDER_BY_JPQL);
1780                }
1781
1782                Query q = session.createQuery(sql);
1783
1784                if (obc == null) {
1785                    list = (List<EmailAddress>)QueryUtil.list(q, getDialect(),
1786                            start, end, false);
1787
1788                    Collections.sort(list);
1789                }
1790                else {
1791                    list = (List<EmailAddress>)QueryUtil.list(q, getDialect(),
1792                            start, end);
1793                }
1794            }
1795            catch (Exception e) {
1796                throw processException(e);
1797            }
1798            finally {
1799                if (list == null) {
1800                    list = new ArrayList<EmailAddress>();
1801                }
1802
1803                cacheResult(list);
1804
1805                FinderCacheUtil.putResult(FINDER_PATH_FIND_ALL, finderArgs, list);
1806
1807                closeSession(session);
1808            }
1809        }
1810
1811        return list;
1812    }
1813
1814    public void removeByCompanyId(long companyId) throws SystemException {
1815        for (EmailAddress emailAddress : findByCompanyId(companyId)) {
1816            remove(emailAddress);
1817        }
1818    }
1819
1820    public void removeByUserId(long userId) throws SystemException {
1821        for (EmailAddress emailAddress : findByUserId(userId)) {
1822            remove(emailAddress);
1823        }
1824    }
1825
1826    public void removeByC_C(long companyId, long classNameId)
1827        throws SystemException {
1828        for (EmailAddress emailAddress : findByC_C(companyId, classNameId)) {
1829            remove(emailAddress);
1830        }
1831    }
1832
1833    public void removeByC_C_C(long companyId, long classNameId, long classPK)
1834        throws SystemException {
1835        for (EmailAddress emailAddress : findByC_C_C(companyId, classNameId,
1836                classPK)) {
1837            remove(emailAddress);
1838        }
1839    }
1840
1841    public void removeByC_C_C_P(long companyId, long classNameId, long classPK,
1842        boolean primary) throws SystemException {
1843        for (EmailAddress emailAddress : findByC_C_C_P(companyId, classNameId,
1844                classPK, primary)) {
1845            remove(emailAddress);
1846        }
1847    }
1848
1849    public void removeAll() throws SystemException {
1850        for (EmailAddress emailAddress : findAll()) {
1851            remove(emailAddress);
1852        }
1853    }
1854
1855    public int countByCompanyId(long companyId) throws SystemException {
1856        Object[] finderArgs = new Object[] { new Long(companyId) };
1857
1858        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_COMPANYID,
1859                finderArgs, this);
1860
1861        if (count == null) {
1862            Session session = null;
1863
1864            try {
1865                session = openSession();
1866
1867                StringBundler query = new StringBundler(2);
1868
1869                query.append(_SQL_COUNT_EMAILADDRESS_WHERE);
1870
1871                query.append(_FINDER_COLUMN_COMPANYID_COMPANYID_2);
1872
1873                String sql = query.toString();
1874
1875                Query q = session.createQuery(sql);
1876
1877                QueryPos qPos = QueryPos.getInstance(q);
1878
1879                qPos.add(companyId);
1880
1881                count = (Long)q.uniqueResult();
1882            }
1883            catch (Exception e) {
1884                throw processException(e);
1885            }
1886            finally {
1887                if (count == null) {
1888                    count = Long.valueOf(0);
1889                }
1890
1891                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_COMPANYID,
1892                    finderArgs, count);
1893
1894                closeSession(session);
1895            }
1896        }
1897
1898        return count.intValue();
1899    }
1900
1901    public int countByUserId(long userId) throws SystemException {
1902        Object[] finderArgs = new Object[] { new Long(userId) };
1903
1904        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_USERID,
1905                finderArgs, this);
1906
1907        if (count == null) {
1908            Session session = null;
1909
1910            try {
1911                session = openSession();
1912
1913                StringBundler query = new StringBundler(2);
1914
1915                query.append(_SQL_COUNT_EMAILADDRESS_WHERE);
1916
1917                query.append(_FINDER_COLUMN_USERID_USERID_2);
1918
1919                String sql = query.toString();
1920
1921                Query q = session.createQuery(sql);
1922
1923                QueryPos qPos = QueryPos.getInstance(q);
1924
1925                qPos.add(userId);
1926
1927                count = (Long)q.uniqueResult();
1928            }
1929            catch (Exception e) {
1930                throw processException(e);
1931            }
1932            finally {
1933                if (count == null) {
1934                    count = Long.valueOf(0);
1935                }
1936
1937                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_USERID,
1938                    finderArgs, count);
1939
1940                closeSession(session);
1941            }
1942        }
1943
1944        return count.intValue();
1945    }
1946
1947    public int countByC_C(long companyId, long classNameId)
1948        throws SystemException {
1949        Object[] finderArgs = new Object[] {
1950                new Long(companyId), new Long(classNameId)
1951            };
1952
1953        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_C_C,
1954                finderArgs, this);
1955
1956        if (count == null) {
1957            Session session = null;
1958
1959            try {
1960                session = openSession();
1961
1962                StringBundler query = new StringBundler(3);
1963
1964                query.append(_SQL_COUNT_EMAILADDRESS_WHERE);
1965
1966                query.append(_FINDER_COLUMN_C_C_COMPANYID_2);
1967
1968                query.append(_FINDER_COLUMN_C_C_CLASSNAMEID_2);
1969
1970                String sql = query.toString();
1971
1972                Query q = session.createQuery(sql);
1973
1974                QueryPos qPos = QueryPos.getInstance(q);
1975
1976                qPos.add(companyId);
1977
1978                qPos.add(classNameId);
1979
1980                count = (Long)q.uniqueResult();
1981            }
1982            catch (Exception e) {
1983                throw processException(e);
1984            }
1985            finally {
1986                if (count == null) {
1987                    count = Long.valueOf(0);
1988                }
1989
1990                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_C_C, finderArgs,
1991                    count);
1992
1993                closeSession(session);
1994            }
1995        }
1996
1997        return count.intValue();
1998    }
1999
2000    public int countByC_C_C(long companyId, long classNameId, long classPK)
2001        throws SystemException {
2002        Object[] finderArgs = new Object[] {
2003                new Long(companyId), new Long(classNameId), new Long(classPK)
2004            };
2005
2006        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_C_C_C,
2007                finderArgs, this);
2008
2009        if (count == null) {
2010            Session session = null;
2011
2012            try {
2013                session = openSession();
2014
2015                StringBundler query = new StringBundler(4);
2016
2017                query.append(_SQL_COUNT_EMAILADDRESS_WHERE);
2018
2019                query.append(_FINDER_COLUMN_C_C_C_COMPANYID_2);
2020
2021                query.append(_FINDER_COLUMN_C_C_C_CLASSNAMEID_2);
2022
2023                query.append(_FINDER_COLUMN_C_C_C_CLASSPK_2);
2024
2025                String sql = query.toString();
2026
2027                Query q = session.createQuery(sql);
2028
2029                QueryPos qPos = QueryPos.getInstance(q);
2030
2031                qPos.add(companyId);
2032
2033                qPos.add(classNameId);
2034
2035                qPos.add(classPK);
2036
2037                count = (Long)q.uniqueResult();
2038            }
2039            catch (Exception e) {
2040                throw processException(e);
2041            }
2042            finally {
2043                if (count == null) {
2044                    count = Long.valueOf(0);
2045                }
2046
2047                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_C_C_C,
2048                    finderArgs, count);
2049
2050                closeSession(session);
2051            }
2052        }
2053
2054        return count.intValue();
2055    }
2056
2057    public int countByC_C_C_P(long companyId, long classNameId, long classPK,
2058        boolean primary) throws SystemException {
2059        Object[] finderArgs = new Object[] {
2060                new Long(companyId), new Long(classNameId), new Long(classPK),
2061                Boolean.valueOf(primary)
2062            };
2063
2064        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_C_C_C_P,
2065                finderArgs, this);
2066
2067        if (count == null) {
2068            Session session = null;
2069
2070            try {
2071                session = openSession();
2072
2073                StringBundler query = new StringBundler(5);
2074
2075                query.append(_SQL_COUNT_EMAILADDRESS_WHERE);
2076
2077                query.append(_FINDER_COLUMN_C_C_C_P_COMPANYID_2);
2078
2079                query.append(_FINDER_COLUMN_C_C_C_P_CLASSNAMEID_2);
2080
2081                query.append(_FINDER_COLUMN_C_C_C_P_CLASSPK_2);
2082
2083                query.append(_FINDER_COLUMN_C_C_C_P_PRIMARY_2);
2084
2085                String sql = query.toString();
2086
2087                Query q = session.createQuery(sql);
2088
2089                QueryPos qPos = QueryPos.getInstance(q);
2090
2091                qPos.add(companyId);
2092
2093                qPos.add(classNameId);
2094
2095                qPos.add(classPK);
2096
2097                qPos.add(primary);
2098
2099                count = (Long)q.uniqueResult();
2100            }
2101            catch (Exception e) {
2102                throw processException(e);
2103            }
2104            finally {
2105                if (count == null) {
2106                    count = Long.valueOf(0);
2107                }
2108
2109                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_C_C_C_P,
2110                    finderArgs, count);
2111
2112                closeSession(session);
2113            }
2114        }
2115
2116        return count.intValue();
2117    }
2118
2119    public int countAll() throws SystemException {
2120        Object[] finderArgs = new Object[0];
2121
2122        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL,
2123                finderArgs, this);
2124
2125        if (count == null) {
2126            Session session = null;
2127
2128            try {
2129                session = openSession();
2130
2131                Query q = session.createQuery(_SQL_COUNT_EMAILADDRESS);
2132
2133                count = (Long)q.uniqueResult();
2134            }
2135            catch (Exception e) {
2136                throw processException(e);
2137            }
2138            finally {
2139                if (count == null) {
2140                    count = Long.valueOf(0);
2141                }
2142
2143                FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, finderArgs,
2144                    count);
2145
2146                closeSession(session);
2147            }
2148        }
2149
2150        return count.intValue();
2151    }
2152
2153    public void afterPropertiesSet() {
2154        String[] listenerClassNames = StringUtil.split(GetterUtil.getString(
2155                    com.liferay.portal.util.PropsUtil.get(
2156                        "value.object.listener.com.liferay.portal.model.EmailAddress")));
2157
2158        if (listenerClassNames.length > 0) {
2159            try {
2160                List<ModelListener<EmailAddress>> listenersList = new ArrayList<ModelListener<EmailAddress>>();
2161
2162                for (String listenerClassName : listenerClassNames) {
2163                    listenersList.add((ModelListener<EmailAddress>)Class.forName(
2164                            listenerClassName).newInstance());
2165                }
2166
2167                listeners = listenersList.toArray(new ModelListener[listenersList.size()]);
2168            }
2169            catch (Exception e) {
2170                _log.error(e);
2171            }
2172        }
2173    }
2174
2175    @BeanReference(name = "com.liferay.portal.service.persistence.AccountPersistence")
2176    protected com.liferay.portal.service.persistence.AccountPersistence accountPersistence;
2177    @BeanReference(name = "com.liferay.portal.service.persistence.AddressPersistence")
2178    protected com.liferay.portal.service.persistence.AddressPersistence addressPersistence;
2179    @BeanReference(name = "com.liferay.portal.service.persistence.BrowserTrackerPersistence")
2180    protected com.liferay.portal.service.persistence.BrowserTrackerPersistence browserTrackerPersistence;
2181    @BeanReference(name = "com.liferay.portal.service.persistence.ClassNamePersistence")
2182    protected com.liferay.portal.service.persistence.ClassNamePersistence classNamePersistence;
2183    @BeanReference(name = "com.liferay.portal.service.persistence.CompanyPersistence")
2184    protected com.liferay.portal.service.persistence.CompanyPersistence companyPersistence;
2185    @BeanReference(name = "com.liferay.portal.service.persistence.ContactPersistence")
2186    protected com.liferay.portal.service.persistence.ContactPersistence contactPersistence;
2187    @BeanReference(name = "com.liferay.portal.service.persistence.CountryPersistence")
2188    protected com.liferay.portal.service.persistence.CountryPersistence countryPersistence;
2189    @BeanReference(name = "com.liferay.portal.service.persistence.EmailAddressPersistence")
2190    protected com.liferay.portal.service.persistence.EmailAddressPersistence emailAddressPersistence;
2191    @BeanReference(name = "com.liferay.portal.service.persistence.GroupPersistence")
2192    protected com.liferay.portal.service.persistence.GroupPersistence groupPersistence;
2193    @BeanReference(name = "com.liferay.portal.service.persistence.ImagePersistence")
2194    protected com.liferay.portal.service.persistence.ImagePersistence imagePersistence;
2195    @BeanReference(name = "com.liferay.portal.service.persistence.LayoutPersistence")
2196    protected com.liferay.portal.service.persistence.LayoutPersistence layoutPersistence;
2197    @BeanReference(name = "com.liferay.portal.service.persistence.LayoutSetPersistence")
2198    protected com.liferay.portal.service.persistence.LayoutSetPersistence layoutSetPersistence;
2199    @BeanReference(name = "com.liferay.portal.service.persistence.ListTypePersistence")
2200    protected com.liferay.portal.service.persistence.ListTypePersistence listTypePersistence;
2201    @BeanReference(name = "com.liferay.portal.service.persistence.LockPersistence")
2202    protected com.liferay.portal.service.persistence.LockPersistence lockPersistence;
2203    @BeanReference(name = "com.liferay.portal.service.persistence.MembershipRequestPersistence")
2204    protected com.liferay.portal.service.persistence.MembershipRequestPersistence membershipRequestPersistence;
2205    @BeanReference(name = "com.liferay.portal.service.persistence.OrganizationPersistence")
2206    protected com.liferay.portal.service.persistence.OrganizationPersistence organizationPersistence;
2207    @BeanReference(name = "com.liferay.portal.service.persistence.OrgGroupPermissionPersistence")
2208    protected com.liferay.portal.service.persistence.OrgGroupPermissionPersistence orgGroupPermissionPersistence;
2209    @BeanReference(name = "com.liferay.portal.service.persistence.OrgGroupRolePersistence")
2210    protected com.liferay.portal.service.persistence.OrgGroupRolePersistence orgGroupRolePersistence;
2211    @BeanReference(name = "com.liferay.portal.service.persistence.OrgLaborPersistence")
2212    protected com.liferay.portal.service.persistence.OrgLaborPersistence orgLaborPersistence;
2213    @BeanReference(name = "com.liferay.portal.service.persistence.PasswordPolicyPersistence")
2214    protected com.liferay.portal.service.persistence.PasswordPolicyPersistence passwordPolicyPersistence;
2215    @BeanReference(name = "com.liferay.portal.service.persistence.PasswordPolicyRelPersistence")
2216    protected com.liferay.portal.service.persistence.PasswordPolicyRelPersistence passwordPolicyRelPersistence;
2217    @BeanReference(name = "com.liferay.portal.service.persistence.PasswordTrackerPersistence")
2218    protected com.liferay.portal.service.persistence.PasswordTrackerPersistence passwordTrackerPersistence;
2219    @BeanReference(name = "com.liferay.portal.service.persistence.PermissionPersistence")
2220    protected com.liferay.portal.service.persistence.PermissionPersistence permissionPersistence;
2221    @BeanReference(name = "com.liferay.portal.service.persistence.PhonePersistence")
2222    protected com.liferay.portal.service.persistence.PhonePersistence phonePersistence;
2223    @BeanReference(name = "com.liferay.portal.service.persistence.PluginSettingPersistence")
2224    protected com.liferay.portal.service.persistence.PluginSettingPersistence pluginSettingPersistence;
2225    @BeanReference(name = "com.liferay.portal.service.persistence.PortletPersistence")
2226    protected com.liferay.portal.service.persistence.PortletPersistence portletPersistence;
2227    @BeanReference(name = "com.liferay.portal.service.persistence.PortletItemPersistence")
2228    protected com.liferay.portal.service.persistence.PortletItemPersistence portletItemPersistence;
2229    @BeanReference(name = "com.liferay.portal.service.persistence.PortletPreferencesPersistence")
2230    protected com.liferay.portal.service.persistence.PortletPreferencesPersistence portletPreferencesPersistence;
2231    @BeanReference(name = "com.liferay.portal.service.persistence.RegionPersistence")
2232    protected com.liferay.portal.service.persistence.RegionPersistence regionPersistence;
2233    @BeanReference(name = "com.liferay.portal.service.persistence.ReleasePersistence")
2234    protected com.liferay.portal.service.persistence.ReleasePersistence releasePersistence;
2235    @BeanReference(name = "com.liferay.portal.service.persistence.ResourcePersistence")
2236    protected com.liferay.portal.service.persistence.ResourcePersistence resourcePersistence;
2237    @BeanReference(name = "com.liferay.portal.service.persistence.ResourceActionPersistence")
2238    protected com.liferay.portal.service.persistence.ResourceActionPersistence resourceActionPersistence;
2239    @BeanReference(name = "com.liferay.portal.service.persistence.ResourceCodePersistence")
2240    protected com.liferay.portal.service.persistence.ResourceCodePersistence resourceCodePersistence;
2241    @BeanReference(name = "com.liferay.portal.service.persistence.ResourcePermissionPersistence")
2242    protected com.liferay.portal.service.persistence.ResourcePermissionPersistence resourcePermissionPersistence;
2243    @BeanReference(name = "com.liferay.portal.service.persistence.RolePersistence")
2244    protected com.liferay.portal.service.persistence.RolePersistence rolePersistence;
2245    @BeanReference(name = "com.liferay.portal.service.persistence.ServiceComponentPersistence")
2246    protected com.liferay.portal.service.persistence.ServiceComponentPersistence serviceComponentPersistence;
2247    @BeanReference(name = "com.liferay.portal.service.persistence.ShardPersistence")
2248    protected com.liferay.portal.service.persistence.ShardPersistence shardPersistence;
2249    @BeanReference(name = "com.liferay.portal.service.persistence.SubscriptionPersistence")
2250    protected com.liferay.portal.service.persistence.SubscriptionPersistence subscriptionPersistence;
2251    @BeanReference(name = "com.liferay.portal.service.persistence.UserPersistence")
2252    protected com.liferay.portal.service.persistence.UserPersistence userPersistence;
2253    @BeanReference(name = "com.liferay.portal.service.persistence.UserGroupPersistence")
2254    protected com.liferay.portal.service.persistence.UserGroupPersistence userGroupPersistence;
2255    @BeanReference(name = "com.liferay.portal.service.persistence.UserGroupRolePersistence")
2256    protected com.liferay.portal.service.persistence.UserGroupRolePersistence userGroupRolePersistence;
2257    @BeanReference(name = "com.liferay.portal.service.persistence.UserIdMapperPersistence")
2258    protected com.liferay.portal.service.persistence.UserIdMapperPersistence userIdMapperPersistence;
2259    @BeanReference(name = "com.liferay.portal.service.persistence.UserTrackerPersistence")
2260    protected com.liferay.portal.service.persistence.UserTrackerPersistence userTrackerPersistence;
2261    @BeanReference(name = "com.liferay.portal.service.persistence.UserTrackerPathPersistence")
2262    protected com.liferay.portal.service.persistence.UserTrackerPathPersistence userTrackerPathPersistence;
2263    @BeanReference(name = "com.liferay.portal.service.persistence.WebDAVPropsPersistence")
2264    protected com.liferay.portal.service.persistence.WebDAVPropsPersistence webDAVPropsPersistence;
2265    @BeanReference(name = "com.liferay.portal.service.persistence.WebsitePersistence")
2266    protected com.liferay.portal.service.persistence.WebsitePersistence websitePersistence;
2267    private static final String _SQL_SELECT_EMAILADDRESS = "SELECT emailAddress FROM EmailAddress emailAddress";
2268    private static final String _SQL_SELECT_EMAILADDRESS_WHERE = "SELECT emailAddress FROM EmailAddress emailAddress WHERE ";
2269    private static final String _SQL_COUNT_EMAILADDRESS = "SELECT COUNT(emailAddress) FROM EmailAddress emailAddress";
2270    private static final String _SQL_COUNT_EMAILADDRESS_WHERE = "SELECT COUNT(emailAddress) FROM EmailAddress emailAddress WHERE ";
2271    private static final String _FINDER_COLUMN_COMPANYID_COMPANYID_2 = "emailAddress.companyId = ?";
2272    private static final String _FINDER_COLUMN_USERID_USERID_2 = "emailAddress.userId = ?";
2273    private static final String _FINDER_COLUMN_C_C_COMPANYID_2 = "emailAddress.companyId = ? AND ";
2274    private static final String _FINDER_COLUMN_C_C_CLASSNAMEID_2 = "emailAddress.classNameId = ?";
2275    private static final String _FINDER_COLUMN_C_C_C_COMPANYID_2 = "emailAddress.companyId = ? AND ";
2276    private static final String _FINDER_COLUMN_C_C_C_CLASSNAMEID_2 = "emailAddress.classNameId = ? AND ";
2277    private static final String _FINDER_COLUMN_C_C_C_CLASSPK_2 = "emailAddress.classPK = ?";
2278    private static final String _FINDER_COLUMN_C_C_C_P_COMPANYID_2 = "emailAddress.companyId = ? AND ";
2279    private static final String _FINDER_COLUMN_C_C_C_P_CLASSNAMEID_2 = "emailAddress.classNameId = ? AND ";
2280    private static final String _FINDER_COLUMN_C_C_C_P_CLASSPK_2 = "emailAddress.classPK = ? AND ";
2281    private static final String _FINDER_COLUMN_C_C_C_P_PRIMARY_2 = "emailAddress.primary = ?";
2282    private static final String _ORDER_BY_ENTITY_ALIAS = "emailAddress.";
2283    private static final String _NO_SUCH_ENTITY_WITH_PRIMARY_KEY = "No EmailAddress exists with the primary key ";
2284    private static final String _NO_SUCH_ENTITY_WITH_KEY = "No EmailAddress exists with the key {";
2285    private static Log _log = LogFactoryUtil.getLog(EmailAddressPersistenceImpl.class);
2286}