01: /**
02: * Copyright (c) 2000-2008 Liferay, Inc. All rights reserved.
03: *
04: * Permission is hereby granted, free of charge, to any person obtaining a copy
05: * of this software and associated documentation files (the "Software"), to deal
06: * in the Software without restriction, including without limitation the rights
07: * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
08: * copies of the Software, and to permit persons to whom the Software is
09: * furnished to do so, subject to the following conditions:
10: *
11: * The above copyright notice and this permission notice shall be included in
12: * all copies or substantial portions of the Software.
13: *
14: * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
15: * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
16: * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
17: * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
18: * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
19: * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
20: * SOFTWARE.
21: */package com.liferay.portlet.polls.service.persistence;
22:
23: import com.liferay.portal.SystemException;
24: import com.liferay.portal.kernel.util.StringMaker;
25: import com.liferay.portal.spring.hibernate.CustomSQLUtil;
26: import com.liferay.portal.spring.hibernate.HibernateUtil;
27: import com.liferay.portlet.polls.NoSuchChoiceException;
28: import com.liferay.portlet.polls.model.PollsChoice;
29: import com.liferay.portlet.polls.model.impl.PollsChoiceImpl;
30: import com.liferay.util.dao.hibernate.QueryPos;
31:
32: import java.util.List;
33:
34: import org.hibernate.SQLQuery;
35: import org.hibernate.Session;
36:
37: /**
38: * <a href="PollsChoiceFinderImpl.java.html"><b><i>View Source</i></b></a>
39: *
40: * @author Bruno Farache
41: *
42: */
43: public class PollsChoiceFinderImpl implements PollsChoiceFinder {
44:
45: public static String FIND_BY_UUID_G = PollsChoiceFinder.class
46: .getName()
47: + ".findByUuid_G";
48:
49: public PollsChoice findByUuid_G(String uuid, long groupId)
50: throws NoSuchChoiceException, SystemException {
51:
52: Session session = null;
53:
54: try {
55: session = HibernateUtil.openSession();
56:
57: String sql = CustomSQLUtil.get(FIND_BY_UUID_G);
58:
59: SQLQuery q = session.createSQLQuery(sql);
60:
61: q.addEntity("PollsChoice", PollsChoiceImpl.class);
62:
63: QueryPos qPos = QueryPos.getInstance(q);
64:
65: qPos.add(uuid);
66: qPos.add(groupId);
67:
68: List list = q.list();
69:
70: if (list.size() == 0) {
71: StringMaker sm = new StringMaker();
72:
73: sm.append("No PollsChoice exists with the key {uuid=");
74: sm.append(uuid);
75: sm.append(", groupId=");
76: sm.append(groupId);
77: sm.append("}");
78:
79: throw new NoSuchChoiceException(sm.toString());
80: } else {
81: return (PollsChoice) list.get(0);
82: }
83: } catch (NoSuchChoiceException nsce) {
84: throw nsce;
85: } catch (Exception e) {
86: throw new SystemException(e);
87: } finally {
88: HibernateUtil.closeSession(session);
89: }
90: }
91:
92: }
|