[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

[Johnathon Lee (JIRA)]

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

Johnathon Lee commented on TEIID-1919:
--------------------------------------

I understand the significance of what it does.  I'm having trouble with the correct way to set it.  ie:

Things that don't work:
<xa-datasource-property name="useCallingThread">false</xa-datasource-property>   
<xa-datasource-property name="url">jdbc:teiid:xatest at mm://localhost:31000;useCallingThread=false</xa-datasource-property>

with messages similiar to:
Caused by: org.jboss.resource.JBossResourceException: Could not find accessor on XADataSource: ; - nested throwable: (java.lang.NoSuchMethodException: org.teiid.jdbc.TeiidDataSource.setUrl(java.lang.String))


Which makes me think the "local" only connections from the documentation is the concept I'm missing or that is being ignored.  Do I not declare the DS as XA in order to leverage this?  That seems to indicate I might be trading for other configuration issues...
                
> 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