[teiid-issues] [JBoss JIRA] (TEIID-5960) Setting connection url property for MYSQL XA Datasource

[Manoj Majumdar (Jira)]

    [ https://issues.redhat.com/browse/TEIID-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14121783#comment-14121783 ] 

Manoj Majumdar commented on TEIID-5960:
---------------------------------------

I got to find a way to set connection url in xa-datasource. It is by setting a property called "connection-properties", and the value will be "URL=". It works for mysql and sqlserver xa datasources as far as I have checked.

> Setting connection url property for MYSQL XA Datasource
> -------------------------------------------------------
>
>                 Key: TEIID-5960
>                 URL: https://issues.redhat.com/browse/TEIID-5960
>             Project: Teiid
>          Issue Type: Bug
>          Components: AdminApi, JDBC Connector
>    Affects Versions: 11.1.2
>            Reporter: Manoj Majumdar
>            Assignee: Steven Hawkins
>            Priority: Minor
>              Labels: Mysql-connector, teiid, xa-datasource-property
>
> I am trying to create a mysql xa datasource, but am unable to mention connection url properties in it. I have used property names such as "URL" and "connection-url", but the property is not visible in datasource.
> Also when I explicitly make a property tag in datasource for the url, it is working, but not when I am creating it through Admin Api,
> I need the connection url for setting mysql connection arguments such as "rewriteBatchedStatements=true"



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