3488280 - Configuring multiple hosts on JDBC material face issue - 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, CPI, CI, SAP Integration Suite, JDBC, hosts, multiple, JDBCDriverException , KBA , LOD-HCI-PI-CON-JDBC , JDBC Adapter , Problem