Spring、Hibernate、删除超过5分钟的记录

DELETE FROM logs WHERE timestamp < NOW() - INTERVAL 5 MINUTE;

@Entity
@Table(name = "logs")
public class Log {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(name = "timestamp")
    private Timestamp timestamp;

    // getters and setters
}

Session session = sessionFactory.openSession();
Transaction tx = null;
try {
    tx = session.beginTransaction();
    Query query = session.createQuery("DELETE FROM Log l WHERE l.timestamp < :fiveMinutesAgo");
    Calendar calendar = Calendar.getInstance();
    calendar.add(Calendar.MINUTE, -5);
    query.setParameter("fiveMinutesAgo", new Timestamp(calendar.getTimeInMillis()));
    query.executeUpdate();
    tx.commit();
} catch (HibernateException e) {
    if (tx != null) tx.rollback();
    e.printStackTrace();
} finally {
    session.close();
}

DELETE FROM logs WHERE timestamp < NOW() - INTERVAL 5 MINUTE LIMIT 1000;