Author: glandais Date: 2008-03-12 17:06:24 +0000 (Wed, 12 Mar 2008) New Revision: 1321 Modified: trunk/simexplorer-is/simexplorer-is-security/src/java/fr/cemagref/simexplorer/is/security/dao/DaoActorImpl.java Log: Query bug (getGroupsOfActor) Modified: trunk/simexplorer-is/simexplorer-is-security/src/java/fr/cemagref/simexplorer/is/security/dao/DaoActorImpl.java =================================================================== --- trunk/simexplorer-is/simexplorer-is-security/src/java/fr/cemagref/simexplorer/is/security/dao/DaoActorImpl.java 2008-03-12 17:04:45 UTC (rev 1320) +++ trunk/simexplorer-is/simexplorer-is-security/src/java/fr/cemagref/simexplorer/is/security/dao/DaoActorImpl.java 2008-03-12 17:06:24 UTC (rev 1321) @@ -134,6 +134,11 @@ return a; } + /** + * Sets the actor visible. + * + * @param actor the new actor visible + */ private void setActorVisible(Actor actor) { actor.setVisible(true); } @@ -259,12 +264,33 @@ } public List<Group> getGroupsOfActor(Actor actor) { + + //String query = "select distinct group from Actor actor join actor.groups as group where actor = :actor and group.visible = true"; + String query = "select distinct g from Group g, Actor actor where g member of actor.groups and g.visible = true and actor=:actor"; List<Group> groups = CollectionUtil.toGenericList(em.createQuery( - "select distinct group from Actor actor join actor.groups as group where actor = :actor and group.visible = true") + query) .setParameter("actor", actor).getResultList(), Group.class); return groups; } + + /* + public Object debugQuery(String query, int type) { + Query jpaQuery = em.createQuery(query); + if (type == 0) { + return jpaQuery.getSingleResult(); + } + if (type == 1) { + return jpaQuery.getResultList(); + } + if (type == 2) { + int lines = jpaQuery.executeUpdate(); + return lines; + } + return null; + } +*/ + }