Hi

Im a new JPA user and I could use some help with a query.
I have two objects(Project and Developer) that are many to many.
So each pojo or entity has a Set of the other defined.

ie
Project Entity has
String name
ManyToMany
Set<Developer> developer ......


Developer Entity has
String name
ManyToMany
Set<Project> project

How would I create a namedquery to find all developers for a particular project name or all projects for a particular developer name?

Im having trouble with the JPQL syntax
Ive tried
query = "select a from Developer a IN(a.projects) b where b.name = rojname"

but the compiler doesnt like that.

Ive tried searching for an example of a JPA many to many query without any luck. Any help would be much appreciated!

Problem solved on another forum

"select a from Developer a IN(a.projects) b where b.name = projname"

Should be

"select a from Developer a, IN(a.projects) b where b.name = projname"


missing comma..ugh!
thanks

Sweet! Thanks for the update!

The JPA means what?
who can tell me, I'm a little confused