[jira] Created: (DERBY-4750) add documentation to declare global temporary tables to explain expected behavior when used with XA transactions.

["Mike Matrigali (JIRA)" <ji...@apache.org>]

add documentation to declare global temporary tables to explain expected behavior when used with XA transactions.
-----------------------------------------------------------------------------------------------------------------

                 Key: DERBY-4750
                 URL: https://issues.apache.org/jira/browse/DERBY-4750
             Project: Derby
          Issue Type: Improvement
          Components: Documentation
    Affects Versions: 10.7.0.0
            Reporter: Mike Matrigali
            Priority: Minor


Add the following information to the DECLARED GLOBAL TEMPORARY TABLE documentation, probably in the restrictions section.

Declared Global Temporary Tables can be used in XA transactions, but
can only be declared and accessed within the scope of a single XA transaction.
Derby only can support access to the table until one of the following XA
interfaces is called:
  XAResource.end(), XAresource().prepare(), or XAResource.commit()

Derby will automatically drop the temporary table whenever the XA tranaction
commits or aborts, subsequent attempts to access the tables will encounter
table not found errors.

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