Spring-Boot 2.0.0.BUILD-SNAPSHOT We have a class named Asset
@Entity
@Inheritance(strategy = InheritanceType.JOINED)
@DiscriminatorColumn(name = "asset_type", columnDefinition = "TINYINT(3) UNSIGNED NOT NULL")
@SQLDelete(sql = "UPDATE asset SET deleted = true where id=?")
@Where(clause = "deleted = false")
public abstract class Asset {
And 2 concrete classes Video and Image:
@Entity
@DiscriminatorValue(value = "1")
@SQLDelete(sql = "UPDATE asset SET deleted = true where id=?")
public class Video extends Asset {
@Entity
@DiscriminatorValue(value = "2")
@SQLDelete(sql = "UPDATE asset SET deleted = true where id=?")
public class Image extends Asset {
snippet from our build:
compile('org.springframework.boot:spring-boot-starter-data-jpa')
After recent Spring-Boot updates we have noticed that entities are not being deleted anymore. We are using MySQL 5.7.17 Let me know if you need any additional information
Comment From: wilkinsona
It's not clear why you think this is a bug in Spring Boot rather than, say, Hibernate or Spring Data JPA. Can you please provide a small sample that reproduces the problem? Also, any details of what you know that suggests this is a bug in Spring Boot would be useful.
Comment From: yuvalbo
Hi @wilkinsona and thank you for your quick response: chances are its not spring-boot directly but as we are using snapshot and dependencies change by the hour we cannot pin-point the root cause. My guess would be Spring Data JPA but can't say 100% nor can I state the exact spring data jpa's version.
Regarding a sample code, can't provide something more than I already sent. It is part of a larger project and would be hard to slice
Comment From: wilkinsona
Regarding a sample code, can't provide something more than I already sent. It is part of a larger project and would be hard to slice
The sample need not be produced from your project. In fact, ideally, it would be a small app that's no bigger than is necessary to reproduce the problem. If you'd like us to spend some time trying to locate and diagnose the problem then please spend some time providing a sample.
Comment From: spring-projects-issues
If you would like us to look at this issue, please provide the requested information. If the information is not provided within the next 7 days this issue will be closed.
Comment From: yuvalbo
@wilkinsona assuming its a Spring-JPA issue, as we are using SpringBoot 2.0.0 snapshot How do I figure out the exact spring-jpa version?
Thanks
Comment From: wilkinsona
The latest Spring Boot snapshots are using Spring Data Kay m3 which contains Spring Data JPA 2.0.0.M3
Comment From: spring-projects-issues
If you would like us to look at this issue, please provide the requested information. If the information is not provided within the next 7 days this issue will be closed.
Comment From: spring-projects-issues
Closing due to lack of requested feedback. If you would like us to look at this issue, please provide the requested information and we will re-open the issue.
Comment From: elvisciotti
Spring boot 2.6.1, Hibernate 5.6.1. SQLDelete works well when applied to children. Does NOT get applied when added only to the parent. Not sure if that's wanted, I didn't find any mention in the documentation