XA Datasource URL value are invisible when using system environment variables in WF13

[pejonsson]

The WF13 Admin UI on 9990 does not show the URL the url contains system environment variables

If you enter a "straight" JDBC url without variables, it works.

jboss-cli.sh -c --command="ls /subsystem=datasources/xa-data-source=MYDATASOURCE/xa-datasource-properties=URL" is reporting

value=jdbc:oracle:thin:@${env.dbhost}:1521:${env.dbsid}

The same value is found in standalone-fullxml

So far, so good. The datasource is also working (TESTS OK).

I populate the settings via the .CLI

#########################

set dsname=MYDATASOURCE

set jndiname=java:/$dsname

batch

/subsystem=datasources/xa-data-source=$dsname:add(user-name=${env.cobrausername},password=${env.cobrapassword}, recovery-username=${env.cobrausername},recovery-password=${env.cobrapassword} driver-name=$driver,jndi-name=$jndiname,use-ccm=true,min-pool-size=1,initial-pool-size=5,max-pool-size=100, validate-on-match=false,background-validation=true, valid-connection-checker-class-name=$validationcheckerclass, exception-sorter-class-name=$execptioncheckerclass,stale-connection-checker-class-name=$stalecheckerclass,use-ccm=true,statistics-enabled=true,no-tx-separate-pool=true,same-rm-override=false,share-prepared-statements=true,prepared-statements-cache-size=100,enabled=true)

/subsystem=datasources/xa-data-source=$dsname/xa-datasource-properties=URL:add(value=${env.jdbcurl})

run-batch

/subsystem=datasources/xa-data-source=$dsname/:write-attribute(name=no-recovery,value=false)

echo Adding $dsname DONE

############################################

My system environment variables are defined in my .bashrc like this:

export dbhost=ora001

export dbsid=ORCL

[claudio4j]

The xa-datasource-properties are not displayed in Web Admin Console on Wildfly 13, but they are for Wildfly 14.

I tested the following datasource using CLI, created on Wildfly 14 and it shows the URL property of xa-datasource-property, under the "Connection" tab, it is the last property.

However I am curious when you said the straight URL with no variables is displayed, where is it displayed ? Can you show a screenshot ?

set dsname=MYDATASOURCE

set jndiname=java:/$dsname

set driver=h2

/system-property=cobrausername:add(value=my_user)

/system-property=cobrapassword:add(value=my_pwd)

/system-property=dbhost:add(value=my_host)

/system-property=dbsid:add(value=my_dbsid)

batch

/subsystem=datasources/xa-data-source=$dsname:add(user-name=$cobrausername,password=$cobrapassword, driver-name=$driver,jndi-name=$jndiname,use-ccm=true,min-pool-size=1,initial-pool-size=5,max-pool-size=100, validate-on-match=false,background-validation=true,use-ccm=true,statistics-enabled=true,no-tx-separate-pool=true,same-rm-override=false,share-prepared-statements=true,prepared-statements-cache-size=100,enabled=true)

/subsystem=datasources/xa-data-source=$dsname/xa-datasource-properties=URL:add(value="jdbc:oracle:thin:@${dbhost}:1521:${dbsid}")

run-batch

This screenshot if of Wildfly 14, see the last line, it shows the xa datasource properties

[pejonsson]

Thanks for responding! I'll look into WF14

The XA datasource jdbc url can be found under the tab properties-->URL

[pejonsson]

Sorry, that answer was only valid for EAP7.

On WF13, you need to flip into EXPERT mode (upper right corner when looking at the XA datasource)

http://localhost:9990/console/index.html#expert-mode;address=%255C0subsystem%255C2datasources%255C0xa-data-source

[pejonsson]

[claudio4j]

I confirm that the expert mode (Model Browser) doesn't show the values as it contains the expression and the value is read-only.

A jira issue was opened to track this problem https://issues.jboss.org/browse/HAL-1520

I expect to fix it this week. Thanks for reporting.