Expected behaviour of using a configuration out of its transaction scope?

[Victor Noël]

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 jooq-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jooq-user/d169e71a-3a31-4d89-9400-0bc9911952fc%40googlegroups.com.