Author: tchemit Date: 2012-08-27 01:01:29 +0200 (Mon, 27 Aug 2012) New Revision: 3635 Url: http://chorem.org/repositories/revision/pollen/3635 Log: fix request when user is connected + have a account id then result is not unique Modified: trunk/pollen-persistence/src/main/java/org/chorem/pollen/business/persistence/PollAccountDAOImpl.java Modified: trunk/pollen-persistence/src/main/java/org/chorem/pollen/business/persistence/PollAccountDAOImpl.java =================================================================== --- trunk/pollen-persistence/src/main/java/org/chorem/pollen/business/persistence/PollAccountDAOImpl.java 2012-08-26 21:41:13 UTC (rev 3634) +++ trunk/pollen-persistence/src/main/java/org/chorem/pollen/business/persistence/PollAccountDAOImpl.java 2012-08-26 23:01:29 UTC (rev 3635) @@ -111,7 +111,7 @@ Preconditions.checkArgument(StringUtils.isNotBlank(accountId) || user != null); - String hql = "SELECT e FROM PollAccountImpl e, PollImpl p, VoteImpl v WHERE " + + String hql = "SELECT distinct(e) FROM PollAccountImpl e, PollImpl p, VoteImpl v WHERE " + "p.pollId = :pollId AND " + "v in elements (p.vote) AND " + "e = v.pollAccount AND ";