I just updated Spring Boot to 3.0.0 and now every DELETE query gives the same error: Index 0 out of bounds for length 0
I’m using Kotlin 1.7.21 with Java 17 and Spring Boot 3.0.0.
Example of query:
DELETE FROM UserComic UC WHERE UC.series.id = :seriesId
Post the full stack trace and the code section that runs the query.
Hi, I found the problem.
My code is using @Where("deleted_by IS NULL")
for soft deletes. In my entities I also have 2 @Generated(GenerationTime.ALWAYS)
columns. So what happens is, after I soft delete the entity Hibernate still tries to update the two virtual columns, causing the transaction not to commit.
What is the best way to solve this? Can I remove the @Generated from the column?
Might be a bug. Please create an issue in the issue tracker(https://hibernate.atlassian.net) with a test case(hibernate-test-case-templates/JPAUnitTestCase.java at main · hibernate/hibernate-test-case-templates · GitHub) that reproduces the issue.