]
Steven Hawkins commented on TEIID-5827:
---------------------------------------
[~mtawk] with the existing logic it looks like that would need to be set via the
connection-properties property as URL=jdbc:oracle:thin:@oraclehost:1521/ORCL - I think
this needs some tweaking as the code has special handling only for a handful of xa
properties: ServerName, PortNumber, and DatabaseName
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]