Thanks for making this a proper issue and clarifying the current behaviour :)
Le lundi 21 octobre 2019 09:52:08 UTC+2, Lukas Eder a écrit : > > Hi Victor, > > Thank you very much for your message. I've created a bug report for this > issue, which I believe is a bug: > https://github.com/jOOQ/jOOQ/issues/9409 > > At first sight, the outer query should throw an exception, as the > transactional semantics is undefined. We could, of course, define it > retroactively. I *think* that what happens is you inherit the datasource's > default auto commit flag, which might be "true", so you will run each query > in its own transaction. > > Fixing this will not be easy as a lot of applications may already depend > on the current behaviour. We'll think about it. Thanks again for bringing > this to our attention. > > Lukas > > On Fri, Oct 18, 2019 at 11:54 AM Victor Noël <[email protected] > <javascript:>> wrote: > >> Hi, >> >> I was playing with transaction support in jOOQ and faced the following >> situation that surprised me (this is pseudo-code and very simplifying to >> illustrate the heart of the question): >> >> var leaked = DSL >> .using(datasource, SQLDialect.POSTGRES) >> .transactionResult(conf -> { >> var tx = DSL.using(conf); >> tx.select(...).fetch(); >> return tx; >> }); >> >> leaked.select(...).fetch(); >> >> I would have expected the first select to succeed and the second one to >> fail, because I leaked the context out of the transaction and used it after >> it was closed. >> >> But maybe I'm making incorrect assumptions? >> >> What happens in this case, the leaked select will just be executed >> outside of any transaction? >> >> Thanks >> >> -- >> You received this message because you are subscribed to the Google Groups >> "jOOQ User Group" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jooq-user/d169e71a-3a31-4d89-9400-0bc9911952fc%40googlegroups.com >> >> <https://groups.google.com/d/msgid/jooq-user/d169e71a-3a31-4d89-9400-0bc9911952fc%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/dd95da24-e96c-4943-a2f6-35ed744549a0%40googlegroups.com.
