[appfuse-user] How to Return a list from user_role table?

[Jesfre]

Hi all...
I want to get all Users was in "admin" role... This is  a third table from
relationship User-Role
How to get all user in "admin" role from this?

This doesn't works...

public List getUsersByRole(String roleId) {
        List user=  getHibernateTemplate().find("select from User where
role_id=" + roleId);
        List userList = new ArrayList();
        for(Long userId : userIdList) {
                userList.add((User) getHibernateTemplate().get(User.class, 
userId));
        }
        return userList;
    }

Thanks...
-- 
View this message in context: 
http://www.nabble.com/How-to-Return-a-list-from-user_role-table--tf2943283s2369.html#a8230231
Sent from the AppFuse - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]