Hi,

EJBQLQuery delete = new EJBQLQuery("delete from Artist a where a.id in (1,
> 2, 3)");


this looks more promising. It would be better this way (IMHO):

context = // assume this exists
List<Integer> myArtistList = // assume this exists
EJBQLQuery delete = new EJBQLQuery("delete from Artist a where a.id in
:myArtistList");
delete.setParameter("myArtistList", myArtistList);
context.performNonSelectingQuery(deleteQuery);

Is this possible? Or, would it be?

Thanks,
Borut

2008/5/30 Andrus Adamchik <[EMAIL PROTECTED]>:

> See my other reply - there is actually an EJBQL delete.
>
>
>
> On May 30, 2008, at 4:27 PM, Borut Bolčina wrote:
>
>  Hi,
>>
>> what is the C3M4 prefered way of doing this SQL equivalent: DELETE FROM
>> Artist WHERE Oid IN (1,4,8,9);
>>
>> Thanks,
>> Borut
>>
>
>

Reply via email to