Execute delete statement 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();
}
Shared with from Codever.
👉 Use the Copy to mine
functionality to copy this snippet to your own personal collection and easy manage
your code snippets.
Codever is open source on Github ⭐🙏