Refine Connection.setTransactionIsolationLevel
documentation
#265
Labels
for: team-attention
An issue we need to discuss as a team to make progress
type: documentation
A documentation update
Milestone
While reading the specification, I'm not completly sure what are the exact behavior of Connecton.setTransactionIsolationLevel :
must transaction isolation be the default state when creating a transaction, or must that apply only for the next transaction.
JDBC Connection.setTransactionIsolation(int) indicates:
Every transaction will default to newly the transaction isolation value.
R2DBC Connection.setTransactionIsolationLevel(IsolationLevel) :
https://github.com/r2dbc/r2dbc-spi/blob/main/r2dbc-spec/src/main/asciidoc/transactions.adoc doesn't clarify that point.
This differ from JDBC, and I think that's an error, expecting that Connection.beginTransaction(TransactionDefinition) to set a transaction isolation for the scope of the transaction, and Connection.setTransactionIsolationLevel(isolationLvl) to set default transaction level for the connection. (postgresql implementation does set isolation for connection, not only next transaction)
Could you confirm the expected behavior ?
The text was updated successfully, but these errors were encountered: