Postgres Pro
Downloads
Home   >   mailing lists

Re: Patch fo select ip and/or port for outgoing connections - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Patch fo select ip and/or port for outgoing connections
Date
Msg-id CADK3HHK4PNdJQX=X32_SxPy_ikpqTTvOozEQc1LzfxafZgbVEg@mail.gmail.com
Whole thread Raw
In response to Patch fo select ip and/or port for outgoing connections  ("Steffen Heil (Mailinglisten)" <lists@steffen-heil.de>)
List pgsql-jdbc
Tree view
Interesting, thanks for the patch.

Cheers,

Dave

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 15 August 2015 at 13:16, Steffen Heil (Mailinglisten) <lists@steffen-heil.de> wrote:
Hi


In our environment we had the requirement to enforce that (on a multihomed server) the database driver uses a certain local ip to connect to the database server.
In java this can easily be archived calling "bind" on the tcp socket before calling connect.

I patched the source of the jdbc driver to make this available through the connection properties "BIND_IP" and "BIND_PORT".
Both are optional, we are using "BIND_IP" in production code.

I attached the patch for everyone to use in any way.
(I am unsure about the contribution process and license requirements but you can use this code however you see fit).

I would be grateful, if this patch or another way to archive the same goal could be included in the next release...


Best regards,
  Steffen


pgsql-jdbc by date:

Previous
From: "Steffen Heil (Mailinglisten)"
Date:
Subject: Patch fo select ip and/or port for outgoing connections
Next
From: Balázs Zsoldos
Date:
Subject: Concurrent read and write access of LargeObject via getBlob() can raise exception