Uploaded image for project: 'WildFly'
  1. WildFly
  2. WFLY-2376

DataSource properties are not persisting via CLI

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.0.0.Beta1
    • 8.0.0.Beta1
    • JCA
    • None
    • Hide
      • Create a datasource like following:

      ./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\"}

      )"

      • Check the JBoss configuration of datasource
      Show
      Create a datasource like following: ./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\"} )" Check the JBoss configuration of datasource

    Description

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

      {\"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}

      Attachments

        Issue Links

          Activity

            People

              smaestri@redhat.com Stefano Maestri
              jaysensharma Jay SenSharma (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: