[jboss-jira] [JBoss JIRA] (WFLY-3688) datasources subsystem: datasource and xa-datasource properties do not support the use of multiple values for one property

[Jeff Zhang (JIRA)]

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

Jeff Zhang commented on WFLY-3688:
----------------------------------

Hi Tom,

The datasource extension is supporting multiple values split by charactor ','
https://github.com/wildfly/wildfly/blob/master/connector/src/main/java/org/jboss/as/connector/util/Injection.java#L318

And I think we can input properties information as a string like:
[standalone at localhost:9999 /] /system-property=foo5:add(value="name=org.foo.bar,version=1.2")
{"outcome" => "success"}
[standalone at localhost:9999 /] /system-property=foo5/:read-resource
{
    "outcome" => "success",
    "result" => {"value" => "name=org.foo.bar,version=1.2"}
}
* change system-property to datasource property *

Could you try it and see if it meet your need? Or please give more information (db connection param, config file) that I can reproduce this locally and find a fix.

Thanks

> datasources subsystem: datasource and xa-datasource properties do not support the use of multiple values for one property
> -------------------------------------------------------------------------------------------------------------------------
>
>                 Key: WFLY-3688
>                 URL: https://issues.jboss.org/browse/WFLY-3688
>             Project: WildFly
>          Issue Type: Bug
>          Components: JCA
>    Affects Versions: 8.1.0.Final
>            Reporter: Tom Fonteyne
>            Assignee: Jeff Zhang
>
> The oracle JDBC driver had a method:
>        setConnectionProperties(java.util.Properties value)
> which is needed to set several connection properties for datasources.
> Most (all?) of these connection properties do not have individual setters.
> WildFly does not support setting a "Properties" value for "datasource-property"



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)