I have two datasources in my standalone.xml with same jndi-name and pool-name. But only one of the datasources is enabled.
<datasource jndi-name="java:jboss/jdbc/My2DB" pool-name="Mis2DB" enabled="true">
<connection-url>jdbc:postgresql://localhost:5432/my_prod_db</connection-url>
<driver>postgres</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<security>
<user-name>username</user-name>
<password>password</password>
</security>
<validation>
<check-valid-connection-sql>Select 1</check-valid-connection-sql>
</validation>
</datasource>
<datasource jndi-name="java:jboss/jdbc/My2DB" pool-name="Mis2DB" enabled="false">
<connection-url>jdbc:postgresql://localhost:5432/my_test_db</connection-url>
<driver>postgres</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<security>
<user-name>username</user-name>
<password>password</password>
</security>
<validation>
<check-valid-connection-sql>Select 1</check-valid-connection-sql>
</validation>
</datasource>
Starting wildfly results in this error message:
o.j.a.c.management-operation: WFLYCTL0013: Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("data-source" => "Mis2DB")
]) - failure description: "WFLYCTL0212: Duplicate resource [
(\"subsystem\" => \"datasources\"),
(\"data-source\" => \"Mis2DB\")
]"
For test purposes I am using either the prod or the test database.
I am using wildfly-26.1.2.Final.