'Wildfly Domain Server Group - Initializes all the DataSource of the profile
I have configured a Wildfly 16 domain with two profiles, in one profile I have 15 server-group with several DataSource for different applications, each DataSource initializes with the number of connections in 8, every time a server-group is restarted it starts the DataSource creating connections to the DB (Oracle), opening 120 (15*8) connections per slave server,
How can I make each server-group start only the respective DataSources for their applications?
I have configured different forms in the DataSource without much success
<datasource jndi-name="java:jboss/datasources/jdbc/pool-DST1" pool-name="pool-DST1" use-ccm="false" statistics-enabled="true">
<connection-url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=yes)(ADDRESS=(PROTOCOL=TCP)(HOST=pluton.dominio1.net)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=jardin.jardinazuayo.fin.ec)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))</connection-url>
<driver>oracle</driver>
<pool>
<min-pool-size>8</min-pool-size>
<initial-pool-size>0</initial-pool-size>
<max-pool-size>15</max-pool-size>
<prefill>true</prefill>
<use-strict-min>true</use-strict-min>
</pool>
<security>
<user-name>PRJECT-S1</user-name>
<password>XXXXXXX</password>
</security>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>false</validate-on-match>
<background-validation>true</background-validation>
<background-validation-millis>180000</background-validation-millis>
<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>
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
