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 👉 copy to mine functionality to add it to your personal snippets collection.
Top comments (0)