Open
Description
Is your feature request related to a problem? If so, please give a short summary of the problem and how the feature would resolve it
When default routing is not sufficient, asking the driver to use a specific interface (either via interface name or IP or dns name) is useful.
Describe the preferred solution
Add a JDBC driver property localSocketAddress.
Allowed values
- (must) IPv4 or IPv6 address
- (must) dns name
- (very optional) interface name
Describe alternatives you've considered
./.
None available, I am using Open Liberty.
Most drivers do support this already.
Additional context
See below
Reference Documentations/Specifications
- PostgreSQL: Add new property to specify local Socket Address pgjdbc/pgjdbc#2081
- MySQL: https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-networking.html#cj-conn-prop_localSocketAddress
- Oracle: https://docs.oracle.com/cd/E17952_01/connector-j-8.0-en/connector-j-connp-props-networking.html#cj-conn-prop_localSocketAddress
- IBM DB2 request: https://ibm-data-and-ai.ideas.ibm.com/ideas/DB24LUW-I-1592
Reference Implementation
Unknown, but a lot of drivers already support this exact JDBC property.
Metadata
Metadata
Assignees
Type
Projects
Status
Backlog
Activity
tkyc commentedon Jun 13, 2023
We'll visit this in planning and let you know if we'll take up work on this.