[jboss-user] [EJB 3.0] - Querying a join table

Hi, I need to query the join table of a many to many relationship and am having trouble. PersistentValue class: @ManyToMany(cascade = {CascadeType.ALL}, fetch = FetchType.LAZY) | @JoinTable(name = "user_filter", | joinColumns={@JoinColumn(name="persistentvalue_id")}, | inverseJoinColumns={@JoinColumn(name="persistentuser_id")}) | public Collection<PersistentUser> getUsersAllowed() { | if(usersAllowed == null) usersAllowed = new ArrayList<PersistentUser>(); | return usersAllowed; | } PersistentUser class: @ManyToMany(mappedBy = "usersAllowed") | public Collection<PersistentValue> getUserFilters() { | if(userFilters == null) userFilters = new ArrayList<PersistentValue>(); | return userFilters; | } If I try to query user_filters directly, I get a 'no such mapping exception'. Do I need to create an entity representing the join table, and if so, how do i do this? Your help appreciated, thanks. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3963139#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...