File Location: <JBoss EAP 7.x Installed folder>\standalone\configuration\standalone.xml
For CTModelHouse, the data sources within this .xml file should be within the <subsystem> element that defines the data sources and the drivers within it.
If you are deploying the ctmodelhouse.war for the first time through JBoss EAP 7.x, the standalone.xml file will not contain the <subsystem> element corresponding to this .war file to define its data sources. Hence, the coding provided in the following snippet has to replace the existing <subsystem> element that is pointed to the default data source. Then, in the future deployments, the coding is only to be validated for correct configuration.
Configure the <subsystem> element to define the data sources within the standalone.xml file as follows:
The <user-name> and <password> elements highlighted in the snippet should match with the database username and password provided for CTModelHouse while executing the DB scripts.
<subsystem xmlns="urn:jboss:domain:datasources:1.2"> <datasources> <datasource jta="true" jndi-name="java:/jboss/datasources/ModelHouseCT" pool-name="ModelHouseCT" enabled="true" use-ccm="true"> <connection-url>jdbc:oracle:thin:@localhost:1521:xe</connection-url> <driver-class>oracle.jdbc.OracleDriver</driver-class> <driver>OracleJDBCDriver</driver> <pool> <min-pool-size>10</min-pool-size> <max-pool-size>20</max-pool-size> </pool> <security> <user-name>CT_MODEL</user-name> <password>CT_MODEL</password> </security> <validation> <validate-on-match>false</validate-on-match> <background-validation>false</background-validation> </validation> <timeout> <set-tx-query-timeout>false</set-tx-query-timeout> <blocking-timeout-millis>0</blocking-timeout-millis> <idle-timeout-minutes>0</idle-timeout-minutes> <query-timeout>0</query-timeout> <use-try-lock>0</use-try-lock> <allocation-retry>0</allocation-retry> <allocation-retry-wait-millis>0</allocation-retry-wait-millis> </timeout> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </datasource> <datasource jta="true" jndi-name="java:/jboss/datasources/ModelHouse" pool-name="ModelHouse" enabled="true" use-ccm="true"> <connection-url>jdbc:oracle:thin:@localhost:1521:xe</connection-url> <driver-class>oracle.jdbc.OracleDriver</driver-class> <driver>OracleJDBCDriver</driver> <pool> <min-pool-size>10</min-pool-size> <max-pool-size>20</max-pool-size> </pool> <security> <user-name>CT_MODEL</user-name> <password>CT_MODEL</password> </security> <validation> <validate-on-match>false</validate-on-match> <background-validation>false</background-validation> </validation> <timeout> <set-tx-query-timeout>false</set-tx-query-timeout> <blocking-timeout-millis>0</blocking-timeout-millis> <idle-timeout-minutes>0</idle-timeout-minutes> <query-timeout>0</query-timeout> <use-try-lock>0</use-try-lock> <allocation-retry>0</allocation-retry> <allocation-retry-wait-millis>0</allocation-retry-wait-millis> </timeout> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </datasource> <drivers> <driver name="OracleJDBCDriver" module="oracle.jdbc"> <datasource-class>oracle.jdbc.driver.OracleDriver</datasource-class> </driver> <driver name="h2" module="com.h2database.h2"> <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class> </driver> </drivers> </datasources> </subsystem>