oracle jdbc connection string with multiple ports
751501Feb 4 2010 — edited Oct 15 2014The regular connection string for the Oracle connection looks like: jdbc:oracle:thin:@host:1521:instance
But let say the TNS entry for the instance defined as follows:
entry =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = TCP.WORLD) (PROTOCOL = TCP) (HOST = host) (PORT = 1521))
(ADDRESS = (COMMUNITY = TCP.WORLD) (PROTOCOL = TCP) (HOST = host) (PORT = 1522))
(ADDRESS = (COMMUNITY = TCP.WORLD) (PROTOCOL = TCP) (HOST = host) (PORT = 1523))
)
(CONNECT_DATA =
(SID = O102364)
)
)
Can I build the connection string that will include all required ports?