Hi to everyone! I have some problems with a query in a migration to JBOSS.
THis is my ejb-ql query:
SELECT Object(o) FROM gtable o, IN(o.infos) alias info where info = ?2 and o.config.gType = ?1
o.infos = Cmr field, so its a collection of objects
o.config.gType = cmr-field as well.
The problem is the next one, so far as I know, you can not have this usage of "IN" with JBOSS-QL. So, what should be the new way???
Any suggest would be welcome.
Thanks in advance.