We have deployed an application to AEM server. Under Transaction Objects in AEM, I see the SQLCA transaction object, but I cannot test it or update it because our Connection Cache dropdown list is empty. If I try to add a new transaction object, or update/test an existing one, I get an error message of ‘Please select a connection cache’. Why are the Data Sources that are defined in the application server console not being displayed in the Connection Cache dropdown list?

Please resolve it by referring to the solution in the Appeon Help> Appeon Server Configuration Guide for J2EE> Database Connection Setup> Setting up Appeon Server data sources\connection caches> Setting up data source for WebSphere> Required configurations when global security is on.

BTW, for more details of the related data sources\connection caches configuration, you can refer to the Setting up connection caches part in the Appeon Server Configuration Guide for .NET, or the Setting up Appeon Server data sources\connection caches part in the Appeon Server Configuration Guide for J2EE as needed.