db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julius Stroffek (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2508) Implement the XA transaction timeout support for embedded driver.
Date Thu, 03 May 2007 16:47:15 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493421

Julius Stroffek commented on DERBY-2508:

XAResource.setTransactionTimeout says something about the resource manager's default timeout.
This should than have some fixed value (or 0 to be disabled).

If derby is used as an embedded database the feature is probably of a limited value and using
XAResource.setTransactionTimeout might be sufficient. I thought that the database administrator
might want to change this if derby will run as a network server. It might help in case of
a network server - the db administrator do not have to be able to control the application
code and even he do not have to know every application connecting to the database.

If the application connecting to derby server will not use setTransactionTimeout itself and
it will crash when there is some global transaction not commited/rolled back which is also
not associated to any connection, that global transaction will keep holding the locks. DB
administrator is than able to setup the derby.jdbc.xaTransactionTimeout property and the locks
would be released after the specified time.

And I thought that it would be a good idea that the behavior of derby network client end embedded
client would be the same.

> Implement the XA transaction timeout support for embedded driver.
> -----------------------------------------------------------------
>                 Key: DERBY-2508
>                 URL: https://issues.apache.org/jira/browse/DERBY-2508
>             Project: Derby
>          Issue Type: Sub-task
>    Affects Versions:
>            Reporter: Julius Stroffek
>         Assigned To: Julius Stroffek
>             Fix For:
>         Attachments: d2432_beta1.diff, d2432_beta1.stat, d2508.diff, d2508.stat
> Implement the XA transaction support for embedded driver in EmbedXAResource.
> Implement functions XAResource.setTransactionTimeout and XAResource.getTransactionTimeout
and add the code to cancel the transaction after the specified period of time.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message