[teiid-issues] [JBoss JIRA] (TEIID-2205) Temp table and procedure block transactions issue

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-2205:
----------------------------------

    Forum Reference: https://community.jboss.org/thread/204069


A somewhat related issue (shown in https://community.jboss.org/thread/204069 for a request scoped transaction) was noticed with just adding in the transactioncontext.  In both the procedure block transaction logic and with the local connection using the calling thread there were circumstances where the transaction was not properly associated with the thread.  This is likely due to incorrectly assuming that the transactionservice begin method associates the transaction.
                
> Temp table and procedure block transactions issue
> -------------------------------------------------
>
>                 Key: TEIID-2205
>                 URL: https://issues.jboss.org/browse/TEIID-2205
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.6
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 8.2
>
>
> The Request class is not correctly setting the transactioncontext on the commandcontext, so downstream transaction logic in temp tables and procedure blocks will not work properly.
> Block/temp table work will fail to isolate correctly and not rollback.

--
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