We have used JDBC to connect to a scale out HANA system but JAVA application can not connect to the HANA database when failover happens in HANA system successfully.
Following points might be the cause of the above issue:
- JDBC connection does not have all the HANA hosts maintained of the scale out system.
- JDBC does not know other HANA hosts when these hosts are down.
To solve this issue please do as following:
Please maintain all hosts including the standby hosts into the JDBC connection as the following pattern:
Scale out system has host 192.168.0.101, 192.168.0.102, 192.168.0.103 and 192.168.0.104,
however, JDBC connection maintains like:
You must change the connection to: jdbc:sap://192.168.0.101:30015;192.168.0.102:30015;192.168.0.103:30015;192.168.0.104:30015
When failing over happens application can not connect to the HANA System because JDBC does not know 192.168.0.102, 192.168.0.103 and 192.168.0.104.
Read here about Steps to Add New HANA System in SAP HANA Studio