[JBoss JIRA] (AG-110) Support non-standard transaction isolation levels
by Luis Barreiro (Jira)
[ https://issues.jboss.org/browse/AG-110?page=com.atlassian.jira.plugin.sys... ]
Luis Barreiro updated AG-110:
-----------------------------
Fix Version/s: 1.5
> Support non-standard transaction isolation levels
> -------------------------------------------------
>
> Key: AG-110
> URL: https://issues.jboss.org/browse/AG-110
> Project: Agroal
> Issue Type: Enhancement
> Affects Versions: 1.4
> Reporter: Rich DiCroce
> Assignee: Luis Barreiro
> Priority: Major
> Fix For: 1.5
>
>
> Some databases support non-standard transaction isolation levels. For example, MS SQL Server has a SNAPSHOT isolation level. Agroal currently can't support this via the transaction isolation level config option because TransactionIsolation is an enum, so it can't have custom values. It would be nice if this were supported. WildFly's "old" datasources subsystem already supports non-standard isolation levels, so it would be nice if the Agroal subsystem had parity.
> There is a workaround, at least on MS SQL Server. initialSql (new-connection-sql in WildFly) can be used to execute "SET TRANSACTION ISOLATION LEVEL SNAPSHOT" when the connection is created.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months
[JBoss JIRA] (AG-110) Support non-standard transaction isolation levels
by Luis Barreiro (Jira)
[ https://issues.jboss.org/browse/AG-110?page=com.atlassian.jira.plugin.sys... ]
Luis Barreiro updated AG-110:
-----------------------------
Component/s: api
> Support non-standard transaction isolation levels
> -------------------------------------------------
>
> Key: AG-110
> URL: https://issues.jboss.org/browse/AG-110
> Project: Agroal
> Issue Type: Enhancement
> Components: api
> Affects Versions: 1.4
> Reporter: Rich DiCroce
> Assignee: Luis Barreiro
> Priority: Major
> Fix For: 1.5
>
>
> Some databases support non-standard transaction isolation levels. For example, MS SQL Server has a SNAPSHOT isolation level. Agroal currently can't support this via the transaction isolation level config option because TransactionIsolation is an enum, so it can't have custom values. It would be nice if this were supported. WildFly's "old" datasources subsystem already supports non-standard isolation levels, so it would be nice if the Agroal subsystem had parity.
> There is a workaround, at least on MS SQL Server. initialSql (new-connection-sql in WildFly) can be used to execute "SET TRANSACTION ISOLATION LEVEL SNAPSHOT" when the connection is created.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months
[JBoss JIRA] (AG-110) Support non-standard transaction isolation levels
by Luis Barreiro (Jira)
[ https://issues.jboss.org/browse/AG-110?page=com.atlassian.jira.plugin.sys... ]
Luis Barreiro updated AG-110:
-----------------------------
Affects Version/s: 1.4
> Support non-standard transaction isolation levels
> -------------------------------------------------
>
> Key: AG-110
> URL: https://issues.jboss.org/browse/AG-110
> Project: Agroal
> Issue Type: Enhancement
> Affects Versions: 1.4
> Reporter: Rich DiCroce
> Assignee: Luis Barreiro
> Priority: Major
>
> Some databases support non-standard transaction isolation levels. For example, MS SQL Server has a SNAPSHOT isolation level. Agroal currently can't support this via the transaction isolation level config option because TransactionIsolation is an enum, so it can't have custom values. It would be nice if this were supported. WildFly's "old" datasources subsystem already supports non-standard isolation levels, so it would be nice if the Agroal subsystem had parity.
> There is a workaround, at least on MS SQL Server. initialSql (new-connection-sql in WildFly) can be used to execute "SET TRANSACTION ISOLATION LEVEL SNAPSHOT" when the connection is created.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months