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

From Steffen Heil (Mailinglisten)
Subject Patch fo select ip and/or port for outgoing connections
Date
Msg-id 3bdf77beeaa149aeb8972af5b586271b@exchange.sh-solutions.de
Whole thread Raw
Responses Re: Patch fo select ip and/or port for outgoing connections  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Hi


In our environment we had the requirement to enforce that (on a multihomed server) the database driver uses a certain
localip 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


Attachment

pgsql-jdbc by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: PreparedStatement.setDate() behavior with OVERLAPS
Next
From: Dave Cramer
Date:
Subject: Re: Patch fo select ip and/or port for outgoing connections