A modern programming language that makes developers happier.

kotlinlang

Hi everyone! Has anyone faced the following issue while using Spring Boot + Webflux + Exposed starter?
Since I am using starter I rely on @Transactional annotation but when it comes to executing queries it fails because at that moment there is no transaction in the context (thread local) but there was one, I checked. For some reason the transaction gets detached somewhere at the dynamic proxy stage. I found that *transaction management only works* *if I use regular functions and not suspend*. I spent a lot of time digging through Spring and Exposed issues on github but the only thing I realized is there were some similar issues but they are already fixed. And that’s weird because I am using the latest available versions of Spring Boot and Exposed starter.

Hmm, there are a lot of explicit mentions of this issue in the <#C0B8ZTWE4|> thread, but funny thing is that I haven’t encountered this issue while using Spring Data.

Hi <@U0826PMD5NY> Please consider taking a look through the tickets on <https://youtrack.jetbrains.com/issues/EXPOSED?q=spring|YouTrack> to see if any align with your issue.

<https://youtrack.jetbrains.com/issue/EXPOSED-609/No-transaction-in-context-spring-boot-3.2.x|EXPOSED-609> and <https://youtrack.jetbrains.com/issue/EXPOSED-627/Compatibility-of-Transactional-with-suspend-functions-instead-of-newSuspendedTransaction-in-coroutine-environment|EXPOSED-627> in particular might be useful.

If they are, please consider upvoting them and/or sharing any comments/feedback specific to your use case that could help us address the issue moving forward.