Page Comparison

File Location: <JBoss EAP 7.x Installed folder>\standalone\configuration\standalone.xml


For expertctstudio, the data sources within this .xml file should be within the <subsystem> element that defines the data sources and the drivers within it.
Note: If you are deploying the expertctstudio.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.

Anchor
page12 page12

Configure the <subsystem> element to define the data sources within the standalone.xml file as follows:
Note: The <user-name> and <password> elements highlighted in the snippet should match with the database username and password provided for expertctstudio while executing the DB scripts.


Image Modified <subsystem xmlns="urn:jboss:domain:datasources:1.2">

<datasources>

<datasource jta="false" jndi-
Image Modified name="java:/jboss/datasources/ExpertStudio" pool-name="ExpertStudio" Image Modified enabled="true" use-ccm="false">

<connection-
Image Modified 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_EXPERT</user-name>

<password>CT_EXPERT</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-
Image Modified wait-millis>

</timeout>

<statement>

<share-prepared-statements>false</share-prepared-
Image Modified statements>

</statement>

</datasource>

<datasource jta="false" jndi-
name="java:/jboss/datasources/ExpertStudioTarget" pool- name="ExpertStudioTarget" enabled="true" use-ccm="false">

<connection-
Image Modified 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>

Anchor
page13 page13

<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-
Image Modified wait-millis>

</timeout>

<statement>

<share-prepared-statements>false</share-prepared-
Image Modified statements>

</statement>

</datasource>

<drivers>

<driver name="OracleJDBCDriver" module="oracle.jdbc">

<datasource-
Image Modified class>oracle.jdbc.driver.OracleDriver</datasource-class>

</driver>
<driver name="h2" module="com.h2database.h2">

<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-
Image Modified datasource-class>

</driver>

</drivers>

</datasources>
Image Modified </subsystem>