HQL: Using the IN together with an array of orm entitites

[Marco Betschart]

I've got the following code which works on ACF 9.0.1:

SELECT b FROM branch AS b

WHERE b.company IN (:companies)

Where :companies holds an array of company entities which were loaded before. In Railo 3.3.4.003 final I receive the following error: "Can't cast Object type [java.util.ArrayList] to a value of type [Component]".

Is this possible at all in Railo? If not, how may I select entities which contain a given set of entities which have to be in a relation with the searched object??

[Jeroen Knoef]

I got the same error, so I would say that this is a bug. It's probably a good idea to create an issue for it in JIRA.

There was a similar issue, which is resolved: https://issues.jboss.org/browse/RAILO-1859, but that issue concerns simple values.

You can use an array of id's instead as a workaround until it is fixed:

FROM branch AS b

WHERE b.company.id IN (:companyIds)

I'm assuming here that the company entity has an id property named id.

[Marco Betschart]

That's what I've done already to take the development further. Where may I open this issue exactly?

[Jeroen Knoef]

https://issues.jboss.org/browse/RAILO

This link is provided in the Railo administrator as well, at the bottom of the overview page.