We have multiple data sources in QA and some of them are pointing to PROD. I have modified the serverames to QA and did test connection, it was successful. Still some of the queries are getting extracted from the PROD. How do I validate that if changes made are correct? and is it only resources.xml?
Changes in the Data sources - server info Test connection validated in resources.xml
Correct, resources.xml will show your current configuration.
TestConnection will always use your current configuration.
However, Websphere 8.5.5 does not have a dynamic configuration.
After updating your configuration to use the QA instead of the PROD database, your application will still use PROD until you restart your server.