[jboss-jira] [JBoss JIRA] (WFLY-9227) XA-Datasources not shown in admin console when using expressions (${some.thing}) in xml config

Brian Stansberry (JIRA) issues at jboss.org
Tue Sep 12 22:10:00 EDT 2017


    [ https://issues.jboss.org/browse/WFLY-9227?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13463117#comment-13463117 ] 

Brian Stansberry commented on WFLY-9227:
----------------------------------------

What does the CLI show when you do this?

/subsystem=datasources:read-resource(recursive=true)

> XA-Datasources not shown in admin console when using expressions (${some.thing}) in xml config
> ----------------------------------------------------------------------------------------------
>
>                 Key: WFLY-9227
>                 URL: https://issues.jboss.org/browse/WFLY-9227
>             Project: WildFly
>          Issue Type: Bug
>          Components: JCA, Web Console
>    Affects Versions: 10.1.0.Final
>            Reporter: Marius Schmidt
>            Assignee: Brian Stansberry
>            Priority: Minor
>
> I expected the this to work, but I does not seem to:
> {noformat}
> GIVEN a Wildfly 10.1.0.Final subsystem datasources configuration as
> 	<subsystem xmlns="urn:jboss:domain:datasources:4.0">
> 		<datasources>
> 			<xa-datasource jndi-name="java:/datasources/SOURCE" pool-name="SOURCE" enabled="${source.db.enabled:false}">
> 				<xa-datasource-property name="URL">
> 					${source.db.url:undefined}
> 				</xa-datasource-property>
> 				<driver>OracleJDBCDriver</driver>
> 				<xa-pool>
> 					<min-pool-size>0</min-pool-size>
> 					<max-pool-size>10</max-pool-size>
> 					<is-same-rm-override>false</is-same-rm-override>
> 					<no-tx-separate-pools>true</no-tx-separate-pools>
> 				</xa-pool>
> 				<security>
> 					<user-name>${source.db.user:user}</user-name>
> 					<password>${source.db.password:password}</password>
> 				</security>
> 				<recovery no-recovery="true"/>
> 				<validation>
> 					<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
> 					<stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"/>
> 					<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
> 				</validation>
> 			</xa-datasource>
> 		</datasources>
> 		<drivers>
> 			<driver name="h2" module="com.h2database.h2">
> 				<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
> 			</driver>
> 			<driver name="OracleJDBCDriver" module="com.oracle.ojdbc7">
> 				<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
> 			</driver>
> 		</drivers>
> 	</subsystem>
> AND a /full/path/to/file.properties file fitting a database connection, containing
> 	source.db.enabled=true
> 	source.db.url=jdbc:oracle:thin:@sample.de:1521:MY_SID
> 	source.db.user=USER
> 	source.db.password=PASSWORD
> WHEN the server is started with --properties=/full/path/to/file.properties
> THEN the webadmin console shows the xa-datasource SOURCE within the datasources subsytem
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)


More information about the jboss-jira mailing list