3488280 - Configuring multiple hosts on JDBC material face issue in Cloud Integration

You are using JDBC adapter to connect to onpremise DB from CPI system.
There are multiple hosts for DB which you would like to configure as a high availability way.
So once one of the host is down then one of the other will be used.
For such a configuration the multiple hosts of Cloud Connector added in below format in the JDBC material:
       jdbc:sap://<Host1>:<Port>;<Host2>:<Port>;<Host3>:<Port>;<Host4>:<Port>;<Host5>:<Port>;<Host6>:<Port>/?autocommit=false

Running the Iflow is working fine, however when one of the host is down the following error faced:

com.sap.it.rt.adapter.jdbc.exceptions.JDBCException: The processing has failed due to error in creating metadata table. : com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to
jdbc:sap://<Host1>:<Port>;<Host2>:<Port>;<Host3>:<Port>;<Host4>:<Port>;<Host5>:<Port>;<Host6>:<Port>
[None of the hosts could be reached: [Receive of connect failed.; host = <Host1>:<Port> error = Unknown host <Host1>:<Port> [null], ...

• Cloud Integration
• SAP Integration Suite

SAP Cloud Platform Integration, SAP HCI, SAP CPI, SCPI, SAP Integration Suite, JDBC, hosts, multiple, JDBCDriverException , KBA , LOD-HCI-PI-CON-RFC , RFC Adapter , Problem