JPA Native Query delete in

Question

Hello,

I try to delete a list of rows from a table using this Native Query:

@NamedNativeQuery(name="WebGroup.DeleteIn", query="DELETE FROM WebGroup WHERE WebGroup.GROUP_ID IN (:IDsList)"

getEm().createNamedQuery("WebGroup.DeleteIn") .setParameter("IDsList", groupToDeleteIDs) .executeUpdate();

and this is the SQL that MySQL executes:

DELETE FROM WebGroup WHERE WebGroup.GROUP_ID IN (:IDsList)

SO, JPA doesn't replace the variable IDsList...

Some one could help me please? Thank you!

Answer 1

which should be the right Type of IDsList?

Collection? List? Long[] ?

Thank you!