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

[Ramesh Reddy (Jira)]

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

Ramesh Reddy commented on TEIID-5960:
-------------------------------------

Teiid does not control any properties what is being set, if the MySQL data source supports the URL property on it then you can use it, if not no. AFAIK, I only seen Oracle  supports the URL property on their data source. If MySQL also supports that is fine. Check the "setter" methods on the data source class then use them to define it.

> 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)