Re: [JBoss-user] help please with ejbql

[Dain <da...@da...>]

You can't do that.  You will have to preprocess the query using dynamic 
ql.  Here is what you do:

1) add a new home method selectByCodes (or queryByCodes)
2) in the home method implementation ejbHomeSelectByCodes you generate 
an EJB-QL query that uses an in operator in the where instead of the 
member of. Something like this:  Speciality.code in (?1, ?2, ?3, ?4).
3) after you generate the query call a dynamic ql mapped ejbSelect 
query.  You will have to convert the collection into an Object array 
but that is simple with toArray.

Fairly simple?

-dain

On Tuesday, November 19, 2002, at 11:40 AM, kiuma wrote:

> Hi all,
> I'm trying to write this query
>
> *    signature="java.util.Collection findByCodes( java.util.Collection 
> pCodes )"
> *    result-type-mapping="Local"
> *    query="SELECT OBJECT(Speciality) FROM WaSpeciality Speciality 
> WHERE Speciality.code MEMBER OF ?1"
>
>
> I think that jboss and ejb in general don't like this form.
> Is there any way to extract a collection of beans matching a 
> collection of id?
>
> regards
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: To learn the basics of securing 
> your web site with SSL, click here to get a FREE TRIAL of a Thawte 
> Server Certificate: http://www.gothawte.com/rd524.html
> _______________________________________________
> JBoss-user mailing list
> JBo...@li...
> https://lists.sourceforge.net/lists/listinfo/jboss-user