Simple connection failover support - Mailing list pgsql-jdbc

From Mikko Tiihonen
Subject Simple connection failover support
Date
Msg-id 4FBB9691.50008@nitorcreations.com
Whole thread Raw
Responses Simple connection fail-over documentation patch  (Mikko Tiihonen <mikko.tiihonen@nitorcreations.com>)
Re: Simple connection failover support  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Hi,

Here are two patches that add simple failover support to the jdbc driver.

Patch 1 converts all references to pair of host+port variables to single InetSocketAddress
Patch 2 rewrites the url parsing to support multiple host:port pairs and modifies the low level connection opening to
retryonce all listed addresses 
I also added more cases to the unit tests to verify that I did not break any functionality.

* The connection url and connection parameters stay backwards compatible
* If there are commas in the hostname part of the url the new code will use them to split the addresses and keep them
inthe defined priority order 
* If there is any IOException or login failure during the connection phase the code will try another listed address
* I tried to keep the code still Java 1.4 compatible

-Mikko

pgsql-jdbc by date:

Previous
From: Craig Ringer
Date:
Subject: Re: json type
Next
From: OTSUKA Kenji
Date:
Subject: a difference of version information 9.1-902 jar and source