[
https://issues.apache.org/jira/browse/SENTRY-1534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15802682#comment-15802682
]
Alexander Kolbasov commented on SENTRY-1534:
--------------------------------------------
To better understand the problem, take a look at
http://docs.oracle.com/database/121/ADFNS/adfns_sqlproc.htm#ADFNS99871. In
particular, it says that you get
REPEATABLE READ if you set the transaction isolation level to SERIALIZABLE.
The problem is that an attempt to set isolation level to repeatable read is
rejected by Oracle and you get an error.
> Oracle supports serializable instead of repeatable-read
> -------------------------------------------------------
>
> Key: SENTRY-1534
> URL: https://issues.apache.org/jira/browse/SENTRY-1534
> Project: Sentry
> Issue Type: Bug
> Components: Sentry
> Affects Versions: 1.8.0, sentry-ha-redesign
> Reporter: Alexander Kolbasov
> Assignee: Alexander Kolbasov
> Attachments: SENTRY-1534.003.patch
>
>
> The fix for SENTRY-1486 changed the default transaction isolation level from
> read-committed to repeatable-read. Unfortunately Oracle doesn't support it
> and Datanucleus doesn't handle this properly (it thinks that it is
> supported). For Oracle the consistency level should be set to "serializable"
> With the current setting (repeatable-read") Sentry doesn't work with Oracle.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
