Eclipse Community Forums: Dali » JPQL Error: collection-valued path '...' cannot be resolved to a valid association field

Home » Eclipse Projects » Dali » JPQL Error: collection-valued path '...' cannot be resolved to a valid association field(Defining a NamedQuery, the Validator signals me an Error but the query works well ...)

Show: Today's Messages :: Show Polls :: Message Navigator

JPQL Error: collection-valued path '...' cannot be resolved to a valid association field [message #1814032]

Mon, 02 September 2019 07:29

Kim Sönksen

Messages: 1
Registered: September 2019

Junior Member

I have an Entity named Person which as the following property:

@ElementCollection(targetClass = Role.class, fetch = FetchType.EAGER)
@Enumerated(EnumType.STRING)
@CollectionTable(name = "person_roles")
private Set<Role> roles = new HashSet<>();

and I have a NamedQuery whis looks like this:

@NamedQuery(
 name = Person.NQ_GET_PERSON_BY_ROLE_ENTITY,
 query = "select a from Person a, IN(a.roles) r where r = :role and a.legalEntity = :legalEntity "

The Query works well and as expected, but the Validator in the UI always tells me

The collection-valued path 'a.roles' cannot be resolved to a valid association field.

Does someone know how to get around this annoying behaviour without completely disabling the validation?

Thnx in advance.

Report message to a moderator

Previous Topic:	Integer instead of int
Next Topic:	Cannot generate entities from existing MySQL db using JPA Tools

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 22:35:36 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter