Hi please tell me! Why? my entity not updated in db ```if (checkEmailStatusVerification.first == des...

# spring

[Shumilin Alexandr]

Hi please tell me! Why? my entity not updated in db

if (checkEmailStatusVerification.first == description) { // it's ok
    verification.verificationState = description
    verificationRepository.run { save(verification) } // this code doesn't work
    throw EmailVerificationException("emailAlreadyVerified  ${verification.email}")
}

i am use

//reactive postgre
implementation("org.springframework.boot:spring-boot-starter-data-r2dbc")
runtimeOnly("io.r2dbc:r2dbc-postgresql:0.8.13.RELEASE")
runtimeOnly("org.postgresql:postgresql:42.5.1")

[Ties]

One thing that could be happening here is that this method is transactional. Which means that if the method throws an exception, the transaction is rolled back, and you throw an exception right after the save method. Just as a test, can you not throw that exception and see if the object get's saved then? (also, maybe a question for the other kotlin people here, what would the .run{} add above just calling verificationRepository.save(verification)?)

[Shumilin Alexandr]

.run{} add above just calling verificationRepository.save(verification)?)

this call method without publisher

[Shumilin Alexandr]

i try without throw Exception - doesn’t work(

[Ties]

How are you testing it? and can you add a log statement there (within the .run{}), to make sure that the code is actually executed (since with reactive stack, that can also be a thing..)

[Shumilin Alexandr]

i check my db record

[Ties]

Then a quick extra check would be to add a log statement just above the save(verification) just to see if that bit of code actually gets executed

[Shumilin Alexandr]

Ok. I try. Write message here after check.

[Shumilin Alexandr]

println("This state start" + verification.verificationState)
verification.verificationState = conDescription
println("START UPDATE state " + verification.verificationState)
verificationRepository.run { save(verification) }
println("FINISH UPDATE")
throw EmailVerificationException("emailAlreadyVerified  ${verification.email}")

i see records in log but db record not updated

[Shumilin Alexandr]

i add to config

logging:
  level:
    io.r2dbc.postgresql.QUERY: DEBUG # for queries
    io.r2dbc.postgresql.PARAM: DEBUG # for parameters

and my query not start, i am not see qery in log

[Shumilin Alexandr]

kotlin.run { verificationRepository.save(verification).subscribe() }

[Shumilin Alexandr]

this good)

[Ties]

So it turned out that your code was not executed 😛

[Shumilin Alexandr]

Yes. Without subscriber not working