@ReadOnlyProperty with child entity associated with a View possibly related to DATAJDBC-431

[davidbruce]

Hello, I am using spring-data-relational 2.2.11 with Postgres and I am having an issue where I have a child @Column that maps to a different Java class that is annotated with @Table and that table is a view.

This works fine for retrieval, but for some reason when I attempt to modify the parent and use parentNameRepository.save(), it attempts to run a delete statement against the child. This then throws an error because it is attempting to delete from a view. @ReadOnlyProperty does not appear to prevent this delete statement and neither does annotation the child class with @Immutable.

For now the our work are either to create triggers at the DB level that ignores this delete generated delete statement, or just iterate over the parent and set a @Transient field with a repository call for the view. (not ideal).

I found that there was an old ticket for ignored @ReadOnlyProperty DATAJDBC-431

[schauder]

Please clarify which property is annotated with @ReadOnlyProperty.

class A {
    @ReadOnlyProperty // the complete reference is read only
    B b;
}

class B {
    @ReadOnlyProperty // only one property of the referenced class is read only
     String someProperty
}

[davidbruce]

@schauder The complete reference is marked with @ReadOnlyProperty.

@Table("parent")
class ParentEntity {
    @Id
    UUID id;
    String timezone; 
    String starttime;
    String endtime;
    boolean enabled;
    @ReadOnlyProperty
    @Column("parent_id")
    ChildViewEntity childViewEntity;
}

@Table("child_view")
class ChildViewEntity {
    int calculatedField;
}

[schauder]

Thanks.
I addressed that in a PR.

It would be great, if you could verify that it solves the problem for you.

[davidbruce]

@schauder I've tested your change and verified it has solved our problem. Thank you very much for looking into this. When will this officially release?