I am trying to delete records from a table where the ID is in a set of values. Can I achive this using criteria queries?

Can you make it bit more clearer what you are trying to achieve

I want to delete all the records from a table whose ID is present in a set of values. Can I do this using Criteria queries?
For more clarity, I want to implement the following query.

DELETE * FROM A WHERE ID IN (a, b, c, ...)

I hav all the IN parameters in a Vector.

Thanks

Criteria don't support bulk updates/deletes. Use HQL.

Curtis ...

[quote="sandeep.r"]I want to delete all the records from a table whose ID is present in a set of values. Can I do this using Criteria queries?
For more clarity, I want to implement the following query.

DELETE * FROM A WHERE ID IN (a, b, c, ...)

I hav all the IN parameters in a Vector.

Thanks[/quote]

try this

List list = criteria.list
list.removeall(list);
This is a roundabout way if you insist in using criteria. but ideally you should be using HQL or
session.createFilter.

Hope this helps .please do rate

Hi sandeep,

I am getting similar problem in deletion with IN clause,

Can u please help if u have found the solution to this problem...

Regards,

Rohit(Sagi)

Dear Rohit,
I had changed my startegy in my application so that I no longer need using the IN clause and continue using criterias.
But if you want this query better u use the HQL.

Thanks
Sandeep