Why do you have to open transactions when using jooq in micronaut, even if it is a simple select #1149
Unanswered
chengna106
asked this question in
Q&A
Why do you have to open transactions when using jooq in micronaut, even if it is a simple select
#1149
Replies: 2 comments
-
|
Well every database interaction runs in a transaction, if there is no surrounding transaction you are in auto-commit mode |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Even auto-commit opens a transaction AFAIK. And doing multiple reads inside of a transaction is good practice. Otherwise you might end up updating your dataset in between selects from another source. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Why do you have to open transactions when using jooq in micronaut, even if it is a simple select
Beta Was this translation helpful? Give feedback.
All reactions