If you haven't already done so, remove the is-same-rm setting from your mysql source.
Thank you Steven, the solution you suggested solved the problem.
We are using Teiid AdminAPI for teiid administration and when implementing your suggested solution, we faced issues.
After investigation we find out there is an issue in the class AdminFactory.java in the method getTemplatePropertyDefinitions
When it is XA datasource, the datasource name should be "xa-data-source" instead of "data-source". See the code snapshot below:
// 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); }
When reading using the method getDataSource in the class AdminFactory.java, it is not getting the properties recursively. and we are getting the connection properties as undefined. like below:
"xa-datasource-properties" => { "DatabaseName" => undefined, "PortNumber" => undefined, "ServerName" => undefined }
We tried sending natively the property recurssive = true in the cli request, and the connection properties were assigned correctly.
Please add a JIRA for correction. Maybe a pull request along with it?