JDBC: Simplified definition of multiple ports within the connection string

Details

Detail name Value
Changelog Number 14619
Type Improvement
Status Resolved
Fix Versions Exasol 7.1.11, Exasol 8.0.3
Resolution Date 2022-06-09

Improvement

The JDBC connection string allows defining multiple ports within the connection string.
The ruleset for such scenarios is simplified now.

For every host within the Connection String up to one port can be defined. In addition, a default port can be defined at the very last position.

Example 1

jdbc:exa:ccadw,eeded:3321,cmw087..093:16234;

for host eeded port 3321 is defined
for all other hosts the default port 16234 is defined

Example 2

jdbc:exa:ccadw,eeded:3321,cmw087..093:16234:8741;

for host eeded port 3321 is defined
for hosts cmw087 to cmw093 port 16234 is defined
for all other hosts the default port 8741 is defined

Example 3

jdbc:exa:ccadw,eeded:3321,cmw087..093;

for host eeded port 3321 is defined
for all other hosts the driver default 8563 is used as no explicit default port is defined

Changed behavior

For JDBC connection strings containing multiple ports, the ruleset defining which port applied to which host is changed. Please follow the Documentation.