[jboss-jira] [JBoss JIRA] (WFLY-2376) DataSource properties are not persisting via CLI

[Jay Kumar SenSharma (JIRA)]

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

Jay Kumar SenSharma commented on WFLY-2376:
-------------------------------------------

- Any of the concerned attribute like *"stale-connection-checker-properties"* or *"reauth-plugin-properties"* or *"exception-sorter-properties"* are not declared inside any of the following XSDs still CLI command shows that those are valid properties/tags

wildfly-8.0.0.Beta2-SNAPSHOT/docs/schema/wildfly-datasources_2_0.xsd
wildfly-8.0.0.Beta2-SNAPSHOT/docs/schema/jboss-as-datasources_1_0.xsd
wildfly-8.0.0.Beta2-SNAPSHOT/docs/schema/jboss-as-datasources_1_1.xsd

                
> DataSource properties are not persisting via CLI
> ------------------------------------------------
>
>                 Key: WFLY-2376
>                 URL: https://issues.jboss.org/browse/WFLY-2376
>             Project: WildFly
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: JCA
>    Affects Versions: 8.0.0.Beta1
>            Reporter: Jay Kumar SenSharma
>            Assignee: Stefano Maestri
>
> - The CLI command show that there are some valid configuration properties available like following while configuring DataSources, However those properties never get persisted in the DataSource configuration:
> {quote}
>  ./jboss-cli.sh  --user=admin --password=admin at 123 -c --controller=remote://localhost:9999  command="/subsystem=datasources/data-source=testpool:read-resource-description(recursive=true)" 
>             "stale-connection-checker-properties" => {
>                 "type" => OBJECT,
>                 "description" => "The stale connection checker properties",
>                 "expressions-allowed" => true,
>                 "nillable" => true,
>                 "value-type" => STRING,
>                 "access-type" => "read-write",
>                 "storage" => "configuration",
>                 "restart-required" => "no-services"
>             },
>             "reauth-plugin-properties" => {
>                 "type" => OBJECT,
>                 "description" => "The properties for the reauthentication plugin",
>                 "expressions-allowed" => true,
>                 "nillable" => true,
>                 "value-type" => STRING,
>                 "access-type" => "read-write",
>                 "storage" => "configuration",
>                 "restart-required" => "no-services"
>             },
>             "exception-sorter-properties" => {
>                 "type" => OBJECT,
>                 "description" => "The exception sorter properties",
>                 "expressions-allowed" => true,
>                 "nillable" => true,
>                 "value-type" => STRING,
>                 "access-type" => "read-write",
>                 "storage" => "configuration",
>                 "restart-required" => "no-services"
>             },
> {quote}
> - Following command never complains about any issue and the following command executed without any issue but the above properties are not persisted in the DataSource.
>  ./jboss-cli.sh --user=admin --password=admin at 123 -c --controller=remote://localhost:9999 command="/subsystem=datasources/data-source=testpool:add(jndi-name=\"java:jboss/TestDS\",driver-name=\"ojdbc6.jar\",connection-url=\"jdbc:oracle:thin:@DBHostName:1521:DBName\",user-name=\"user\",password=\"pass\",new-connection-sql=\"select 1 from dual\", check-valid-connection-sql=\"select 2 from dual\",valid-connection-checker-class-name=\"org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker\",exception-sorter-properties={\"prop1\"=>\"value1\"},reauth-plugin-properties={\"reauthProp1\"=>\"reauthValue1\"},exception-sorter-properties={\"exceptionSorterProp1\"=>\"exceptionSorterValue1\"})"
> - The Generated DataSource looks like following:
> ${quote}
>                 <datasource jndi-name="java:jboss/TestDS" pool-name="testpool" enabled="true">
>                     <connection-url>jdbc:oracle:thin:@DBHostName:1521:DBName</connection-url>
>                     <driver>ojdbc6.jar</driver>
>                     <new-connection-sql>select 1 from dual</new-connection-sql>
>                     <security>
>                         <user-name>user</user-name>
>                         <password>pass</password>
>                     </security>
>                     <validation>
>                         <valid-connection-checker class-name="org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker"/>
>                         <check-valid-connection-sql>select 2 from dual</check-valid-connection-sql>
>                     </validation>
>                 </datasource>
> ${quote}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira