• 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:

./jboss-cli.sh --user=admin --password=admin@123 -c --controller=remote://localhost:9999 command="/subsystem=datasources/data-source=testpool:read-resource-description(recursive=true)"

"stale-connection-checker-properties" =>

Unknown macro: { "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" =>

Unknown macro: { "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" =>

Unknown macro: { "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" }

,

• 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@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=

,reauth-plugin-properties=

,exception-sorter-properties=

)"

• 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}