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.