]
RH Bugzilla Integration commented on WFLY-2376:
-----------------------------------------------
Kabir Khan <kkhan(a)redhat.com> changed the Status of [bug
DataSource properties are not persisting via CLI
------------------------------------------------
Key: WFLY-2376
URL:
https://issues.jboss.org/browse/WFLY-2376
Project: WildFly
Issue Type: Bug
Components: JCA
Affects Versions: 8.0.0.Beta1
Reporter: Jay Kumar SenSharma
Assignee: Stefano Maestri
Fix For: 9.0.0.Beta1
- 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@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@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}