DEV Community

Cover image for How to execute delete statements with jpa query
Adrian Matei for Codever

Posted on • Updated on • Originally published at codever.dev

How to execute delete statements with jpa query

Use the executeUpdate method of the Query interface. It will return the number of deleted entries:

public int deleteOldMessages(int daysBack) {
  var query = em.createQuery("delete from Message m where createdAt < :givenTimestamp");
  query.setParameter(Message.GIVEN_TIMESTAMP, LocalDateTime.now().minusDays(daysBack));

  return query.executeUpdate();
}
Enter fullscreen mode Exit fullscreen mode

Shared with ❤ī¸ from Codever. Use 👉 copy to mine functionality to add it to your personal snippets collection.

Latest comments (0)