| From: | Mikko Tiihonen <mikko(dot)tiihonen(at)nitorcreations(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Simple connection failover support |
| Date: | 2012-05-22 13:37:21 |
| Message-ID: | 4FBB9691.50008@nitorcreations.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 retry once 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 in the 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
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Change-String-host-int-port-to-InetSocketAddress-add.patch | text/x-patch | 0 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | OTSUKA Kenji | 2012-05-25 01:50:27 | a difference of version information 9.1-902 jar and source |
| Previous Message | Craig Ringer | 2012-05-22 04:53:32 | Re: json type |