On Hibernate 5 I receive the following warning: deprecation: HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

Essentially Hibernate 5 deprecated the JPQL 'MEMBER OF' syntax in favor of the JPQL inner join syntax. My question is essentially why? Is it worth changing from the MEMBER OF syntax to INNER JOIN? I'm curious what the reasoning is.

Thanks in advance,
Steve

It's not the MEMBER OF which got deprecated, it's the collection properties that were dropped in favor of functions.
MEMBER OF is JPA 2.0 compliant, so it shouldn't be depreciated.

This is the issue:

https://hibernate.atlassian.net/browse/HHH-10070

I appreciate your response. Good to know that MEMBER OF is respected. Now I am confused as to why the warning is being issued at all as I am not using collection properties to my knowledge.

Here is a good example from StackOverflow which illustrates the problem: http://stackoverflow.com/questions/33338186/how-to-remove-hibernate-deprecation-warning-message
I'll insert the stackoverflow query herein for simplicity:



How is it that this query produces the collection properties warning? How can we avoid this warning but still use MEMBER OF syntax which I prefer to the INNER JOIN syntax?

Thanks in advance,
Steve

You should open a JIRA issue for this.

A JOIN might also perform better than MEMBER OF, if the latter results in a sub-select.

Ok, I will open a JIRA after I gather some more information. That's also a good point about the inner join. Noted.

@sagneta, did you create a JIRA for this warning? I got the same problem and could not find a JIRA about it.

I totally forgot to create a JIRA. I will try to do so.

Ok the JIRA now exists. I apologize for dropping the ball.

https://hibernate.atlassian.net/browse/HHH-10621

Thanks