CODEWITHSUNDEEP
javaspring-webfluxspring-data-r2dbcr2dbc
Rachana Kulkarni
Rachana Kulkarni

Reputation: 71

Ignore field for update in spring-r2dbc

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

Upvotes: 7

Views: 5016

Answers (2)

Mohsen
Mohsen

Reputation: 489

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

Upvotes: 1

Dharmendra Vishwakarma
Dharmendra Vishwakarma

Reputation: 516

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

Upvotes: 2

Related Questions