The moose likes JBoss and the fly likes Usage of IN in jboss-ql Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » JBoss
Reply Bookmark "Usage of IN in jboss-ql" Watch "Usage of IN in jboss-ql" New topic
Author

Usage of IN in jboss-ql

Vicente Castrillo
Greenhorn

Joined: Feb 17, 2005
Posts: 4
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.
 
IntelliJ Java IDE
 
subject: Usage of IN in jboss-ql
 
Threads others viewed
EJB-QL Question
ejb-ql formulation question
Mock exam question doubt - q.11 p.428
Doubts on EJB-QL
Invalid EBJQL
IntelliJ Java IDE