Scenario:
* AS400 with two databases, one for production and other one for staging
* One machine running Wildfly for production and one running for staging, each one connected with respective database
The staging Wildfly is managing data from production database, even with the corrected schema specified in connection-url.
Does Wildfly, somehow, change datasource connection-url?
Accordingly with AS400 documentation, when a connection does not define schema then it picks up tables and views from the first schema found.
This is not happening when connected with SQL clients.
Plz forget this entry. It was my mistake.
We have one property file with the schema configuration then in runtime we use a SET SCHEMA command.