EJB-QL question

choubovski Apr 30, 2002 10:14 AM

Hello,

I want to get a collection of entity which contains some objects in a collection.
I've tried this but it doesn't work :

<ejb-ql>select object(i) from Interlocuteur i where ?1 MEMBER OF i.environnements AND ?2 MEMBER OF i.environnements</ejb-ql>

Any idea ?
Thanks in advance.

1. Re: EJB-QL question

dsundstrom Apr 30, 2002 10:46 AM (in response to choubovski)

What SQL is getting generated for this EJB-QL (it is written to the server.log file)? Is it the sql you were expecting?
Actions
2. Re: EJB-QL question

choubovski Apr 30, 2002 10:57 AM (in response to choubovski)

The problem is that I can't find any SQL generated in this server.log file.
Actions
3. Re: EJB-QL question

choubovski Apr 30, 2002 12:28 PM (in response to choubovski)

I finally found another solution to get the collection I want but I still don't understand why what I did is not working.
Actions
4. Re: EJB-QL question

dsundstrom Apr 30, 2002 12:53 PM (in response to choubovski)

> The problem is that I can't find any SQL generated in
> this server.log file.

Up the log level to at least debug.
Actions

Go to original post