High availability Oracle jdbc connection string

Hello everyone,

Do we know if IDT connection supports a high availability jdbc connection string format?

We are trying to connect to Oracle database 12.2.0.1 using jdbc7 and jdbc8 drivers. The connection string format provided to us is in this format:

jdbc:oracl:thin:@ldap://abc.xyz.com:1389.

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.

Thanks,

Venkat