Do we know if IDT connection supports a high availability jdbc connection string format?
We are trying to connect to Oracle database 126.96.36.199 using jdbc7 and jdbc8 drivers. The connection string format provided to us is in this format:
There are 2 servers (primary and standby) behind this FQDN.
Here's a sample of connection details I am using
Upon testing the above connection I receive this error
IO Error: Invalid number format for port number
I modified the string to use host:port format (abc.xyz.com:1389) but then I get this error:
IO Error: Size Data Unit (SDU) mismatch
However if I use the primary server name (dbcat123p-host.xyz.com:1521) in the 'Server(s)' field above, the connection tests fine. See below.
We are on BI4.2 SP5 Patch6. Appreciate any inputs on this.