Probably straight up SQL. DELETE FROM CP_CONSUMER WHERE ID IN (list of ids) or maybe can be done as a Criteria query and add a method called deleteConsumer(List<Consumer> consumers) or deleteConsumers(List<String> ids); Might be able to use HQL too.