I am using spring data jpa to delete the records.
@Modifying
@Transactional
@Query(value = "delete from table where start_time_ms <= :startTimeMs",
nativeQuery = true)
Integer deleteInBulkByStartTime(@Param("startTimeMs") Long startTimeMs) throws
SQLException;
Spring takes care of managing the transaction.
On Sunday, May 21, 2023 at 1:09:55 AM UTC+5:30 Noel Grandin wrote:
> check that all your transactions are being closed. Holding a transaction
> open means that the storage cannot be freed.
>
>
>
>>
>>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/7c3dc13a-1ccc-4333-932e-4ac29a4d15e9n%40googlegroups.com.
