ORACLE r2dbc update instead of insert

[karimifariba]

Spring Boot 3.3.3 RELEASE
Spring Data R2DBC 3.3.3
R2DBC-(ORACLE) 1.2.0

If I call #save on a new unchanged entity, then currently, I am getting an error: Failed to update table [%s]. Row with Id [%s] does not exist.

I am using the [oracle-r2dbc] (https://github.com/oracle/oracle-r2dbc) library

If I alter my path to ensure the item is always actually updated, before save gets called, then it succeeds as expected.

As this is a nested entity, it is being saved as a side-effect of the primary entity.

Is this a bug, as it worked previously for me, or do I need to update the code flow to perform a read and check if anything has changed before I call save?

[southwolf]

@karimifariba
I believe this is duplicated / related with #49, and #275, save() determines whether to perform insert() or update() simply by checking if id exists, and the workaround would be implementing Persistable interface and overriding isNew() method, which is a weird solution IMHO...

[schauder]

Spring Data R2DBC doesn't support nested entities.

Please provide a Minimimal Reproducable Example, preferable as a Github repository. Make sure to include the database, either as an in memory database or if that is not possible using Testcontainers.

[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.