I’m working on a Java based web application. I deploy the application in SAP CP. The application read/writes to a database in SAP HANA. The application connects to HANA through Data Source Binding (I mark this binding as <DEFAULT>). It works absolutely fine and I can read/write to DB through user interface. The UI of the application is in UI5 and backend part is done in Java. In Java, I connect to DB using JDBC.
The challenge that I’m facing currently is that when I try a non-default data source binding in the SAP CP for my application, I’m unable to connect my application to this data source. Which means at runtime it is unable to find this data source binding. The data source binding works fine as I’m able to verify it to be connected to HANA DB. I have tried various ways (a lot!) to get the connection trying to make different changes in web.xml and resource-ref-name, but unable to succeed. I’ve looked so many resources online but haven’t seen any with non-default data source binding.