[teiid-issues] [JBoss JIRA] (TEIID-1919) Teiid exception when XA procedure uses two sources (defined in separate *-ds.xml files) that use different oracle accounts and point at the same oracle instance

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12663421#comment-12663421 ] 

Ramesh Reddy commented on TEIID-1919:
-------------------------------------

See this for LocalConnection

http://docs.jboss.org/teiid/7.6.0.Final/client-developers-guide/en-US/html_single/#local_connection

Yes, you need to set 
<xa-datasource-property name="useCallingThread">false</xa-datasource-property> 

Also when you use *mm://localhost:31000* in url (data source is configured without URL), even though it is same VM, you can not count that as LocalConnection as there is marshall/unmarshell going on between requests and response.

See this for XA datasource http://docs.jboss.org/teiid/7.6.0.Final/client-developers-guide/en-US/html_single/#as_xa_connection

                
> Teiid exception when XA procedure uses two sources (defined in separate *-ds.xml files) that use different oracle accounts and point at the same oracle instance
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-1919
>                 URL: https://issues.jboss.org/browse/TEIID-1919
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.7
>         Environment: Using Oracle XA Datasources
>            Reporter: Johnathon Lee
>            Assignee: Steven Hawkins
>         Attachments: serverExample.log, xasimple.jsp, xatest.jsp
>
>
> Teiid exception when XA procedure uses two sources (defined in separate *-ds.xml files) that use different oracle accounts and point at the same oracle instance.
> See attached serverExample.log.  Error manifests @ 8243.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira