2247694 - In case of SAP HANA takeover or failover in HANA multitenant database environment you want to know how to point Java stack to correct HANA node.

Symptom

• You have SAP Java stack application server and after HANA failover or HANA takeover you want to have the JAVA stack automatically pointing to the correct SAP HANA node.
• You use SAP HANA multitenant database containers with connected JAVA Stack.

Environment

SAP HANA Database 1.0

Reproducing the Issue

Failover or takeover takes place in SAP HANA multitenant database environment where the connected application has a JAVA Stack.

Cause

The HDBUSERSTORE can only be used to store connection information for SAP HANA application clients that support ODBC, ABAP and HDBSQL connection types. HDBUSERSTORE does not support JDBC based connection types which the JAVA stack uses when connecting to a SAP HANA Database.

Resolution

1. In the Connection Pools window of the AS Java Config Tool edit the URL property string so that it has the information for the failover node or the node on the secondary site that you want to takeover too:

           
           jdbc:sap://saphananode1:3XX13;saphananode2:3XX13?databaseName=SID
In the above example Url saphananode1 is the current working SAP HANA node and saphananode2 is the standby node that you want to failover too. The multitenant port is 3XX13 where XX is the instance number. SID is the name of the SAP HANA Database.

2. For windows environments although SAP JAVA does not use HDBUSERSTORE functionality to connect to SAP HANA Database, it is still Mandatory to add user SAPService<SID> to HDBUSERSTORE as described in the following SAP note 1852017

See Also

• Connect to SAP HANA via JDBC.
• Using AS Java Config Tool to manage secure store data.

Keywords

system replication.