Ignore field for update in spring-r2dbc

Question

I am using spring r2dbc and ReactiveCrudRepository, I have a field which I need to ignore for when update query is generated

@Data
@Table(PRODUCT_TABLE)
public class ProductEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO) // Id generated by database
    private Integer id;

    private Integer companyId;

    @Column(insertable=false, updatable = false)
    private String companyName;

    @NotBlank
    private String name;

    private VerificationStatus verificationStatus;
}

How can I ignore companyName in update query. I am able ignore it in insert query using @column but its not working for update

score 1 · Answer 1 · answered May 16 '20 at 15:33

1

If you don't want to keep the field for update and insert, then mark the field with @Transient.

For example,

@Transient
private String companyName;

https://docs.spring.io/spring-data/commons/docs/current/api/org/springframework/data/annotation/Transient.html

answered May 16 '20 at 15:33

Dharmendra Vishwakarma

484
2
12

2

But I do want to it use for select statements, it would be ignored in case of Transient – Rachana Kulkarni May 18 '20 at 01:47

score 1 · Answer 2 · answered Jan 03 '22 at 14:24

1

Simplify use

@ReadOnlyProperty

For example,

@ReadOnlyProperty
private String companyName;

https://docs.spring.io/spring-data/commons/docs/current/api/org/springframework/data/annotation/ReadOnlyProperty.html

answered Jan 03 '22 at 14:24

Mohsen

438
5
14

this one will not allow insert field data to persist – downvoteit Feb 24 '23 at 17:23

Ignore field for update in spring-r2dbc

2 Answers2