[teiid-issues] [JBoss JIRA] (TEIID-5827) XA datasource properties are undefined

[Mark Tawk (Jira)]

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

Mark Tawk commented on TEIID-5827:
----------------------------------

Thank you Steven for the fix.
We encountered an issue with xa-datasource using Oracle. We are not able to set the xa-datasource-property "URL" for the oracle connection. 
{code:java}
<xa-datasource-property name="URL">
                        jdbc:oracle:thin:@oraclehost:1521/ORCL
                    </xa-datasource-property>
{code}


> XA datasource properties are undefined
> --------------------------------------
>
>                 Key: TEIID-5827
>                 URL: https://issues.jboss.org/browse/TEIID-5827
>             Project: Teiid
>          Issue Type: Bug
>          Components: AdminApi
>            Reporter: Mark Tawk
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 13.0, 12.2.2, 12.3.1
>
>
> The method getTemplatePropertyDefinitions, in the class AdminFactory.java.
> The datasource name should be "xa-data-source" instead of "data-source" when the datasource is XA. See the code snapshot below:
>  
> {code:java}
> // get JDBC properties  
>         if (isXA(templateName)) {  
>                 cliCall("read-resource-description", new String[] {"subsystem", "datasources", "data-source",   
>                         stripXA(templateName)}, null, builder);  
>                 addXAProperties(props);  
>         } else {  
>             cliCall("read-resource-description", new String[] {"subsystem", "datasources", "data-source",   
>                     templateName}, null, builder);  
>             addDriverproperties(props);              
>         }  
>  {code}
> Another issue, when reading using the method getDataSource in the class AdminFactory.java, it is not getting the properties recursively. and the connection properties are returned as undefined like below:
>  
>  {code:java} 
>  "xa-datasource-properties" => {  
>  "DatabaseName" => undefined,  
>  "PortNumber" => undefined,  
>  "ServerName" => undefined  
>         }  
>  {code}
> more details in the following forum discussion link: [https://developer.jboss.org/thread/280411?start=15&tstart=0]



--
This message was sent by Atlassian Jira
(v7.13.8#713008)