[
https://issues.apache.org/jira/browse/DERBY-6066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13580785#comment-13580785
]
Mamta A. Satoor commented on DERBY-6066:
----------------------------------------
Currently, there is no test in our harness to see when the piggybacked
isolation level might not be correct and hence the isolation level should be
obtained from server. There is following comment in
o.a.d.client.am.Connection.getTransactionIsolationX
// DERBY-1148 - Client reports wrong isolation level. We need to
get the isolation
// level from the server. 'isolation_' maintained in the client's
connection object
// can be out of sync with the real isolation when in an XA
transaction. This can
// also happen when isolation is set using SQL instead of JDBC. So
we try to get the
// value from the server by calling the "current isolation"
function. If we fail to
// get the value, return the value stored in the client's
connection object.
// DERBY-3192 - Cache session data in the client driver allows
// the re-introduction of isolation level caching. Changes to the
// isolation level triggered from SQL are now handled by
// piggybacking the modified isolation level on messages going
// back to the client.
// The XA-problem is handled by letting XA state changes set the
// cached isolation level to TRANSACTION_UNKNOWN which will trigger
// a refresh from the server.
> Client should use a prepared statement rather than regular statement for
> Connection.getTransactionIsolation
> -----------------------------------------------------------------------------------------------------------
>
> Key: DERBY-6066
> URL: https://issues.apache.org/jira/browse/DERBY-6066
> Project: Derby
> Issue Type: Improvement
> Components: Network Client
> Reporter: Mamta A. Satoor
> Assignee: Mamta A. Satoor
> Attachments: DERBY6066_patch1_diff.txt
>
>
> This jira is similar to DERBY-6053 but for
> o.a.d.client.am.Connection.getTransactionIsolation. Use prepared statement
> rather than regular statement every time user makes a get transaction
> isolation call.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
