-
Notifications
You must be signed in to change notification settings - Fork 201
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Support for configuring transaction characteristics #432
Comments
BillyYccc
changed the title
Support for setting Transaction Isolation
Support for configuring transaction characteristics
Feb 21, 2020
this is somehow proprietary to each database, e.g for postgres one need to execute a SQL statement that will do that |
Yes it differs between different database vendors.
Postgres supports starting a transaction with configuring transaction
isolation levels and characteristics
https://www.postgresql.org/docs/current/sql-start-transaction.html.
MySQL supports starting a transaction with configuring only
transaction characteristics(but additionally WITH CONSISTENT SNAPSHOT)
https://dev.mysql.com/doc/refman/8.0/en/commit.html
MS SQL Server does not support such kind of configuration syntax to start a
transaction.
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/begin-transaction-transact-sql?view=sql-server-ver15
I'm thinking we might provide an API which seems like this
```
SqlConnection#begin(Supplier<String> startTxSql, Handler<AsyncResult<
Transaction>> handler);
```
so that users could be able to decide how the transactions are started.
…On Thu, May 14, 2020 at 7:41 PM Julien Viet ***@***.***> wrote:
this is somehow proprietary to each database, e.g for postgres one need to
execute a SQL statement that will do that
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<#432 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABJV4JPDJWVC5CPTZ4XR7MDRRPKG3ANCNFSM4JADEB4Q>
.
|
1 |
BillyYccc
added a commit
to BillyYccc/vertx-sql-client
that referenced
this issue
May 17, 2020
Signed-off-by: Billy Yuan <[email protected]>
as part of the API I don't understand how the |
I think that the |
BillyYccc
added a commit
to BillyYccc/vertx-sql-client
that referenced
this issue
May 18, 2020
Signed-off-by: Billy Yuan <[email protected]>
BillyYccc
added a commit
to BillyYccc/vertx-sql-client
that referenced
this issue
May 18, 2020
Signed-off-by: Billy Yuan <[email protected]>
BillyYccc
added a commit
to BillyYccc/vertx-sql-client
that referenced
this issue
May 18, 2020
Signed-off-by: Billy Yuan <[email protected]>
BillyYccc
added a commit
to BillyYccc/vertx-sql-client
that referenced
this issue
May 18, 2020
Signed-off-by: Billy Yuan <[email protected]>
Hi @vietj , any uodate on this? |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Reference:
https://vertx.io/docs/apidocs/io/vertx/ext/sql/SQLOptions.html#getTransactionIsolation--
https://vertx.io/docs/apidocs/io/vertx/ext/sql/TransactionIsolation.html
The text was updated successfully, but these errors were encountered: