-
1. Re: XA Datasource URL value are invisible when using system environment variables in WF13
claudio4j Sep 3, 2018 9:58 AM (in response to pejonsson)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
-
2. Re: XA Datasource URL value are invisible when using system environment variables in WF13
pejonsson Sep 12, 2018 7:37 AM (in response to claudio4j)Thanks for responding! I'll look into WF14
The XA datasource jdbc url can be found under the tab properties-->URL
-
3. Re: XA Datasource URL value are invisible when using system environment variables in WF13
pejonsson Sep 12, 2018 7:45 AM (in response to 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)
-
5. Re: XA Datasource URL value are invisible when using system environment variables in WF13
claudio4j Sep 12, 2018 7:04 PM (in response to pejonsson)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.