Re: JDBC connectivity issue

On 03/08/2018 01:12 PM, chris wrote:
> Hi,
> 
> I have a JDBC temping to connect to 2 postgres nodes in a hot standby 
> configuration. Running postgres 9.4 on centos6.
> 
> What we are trying to accomplish is in an event of a failover, to first 
> try to connect to the master. If that fails to then reach out to the 
> standby.
> 
> I looked online and found the suggested way to do this, but it's not 
> working.
> 
> This is the JDBC line we have:
> 
> /jdbc.url=jdbc:postgresql://10.16.10.12:5432,10.16.10.13:5432/app_db/
> 
> Here is the error we are getting:/
> /
> 
> /2018-03-07 13:54:36, 994 ERROR:com.zaxxer.hikari.util.PropertyElf - 
> failed to set properly port number on target class 
> org.postgresql.ds.PGSimpleDataSource java.langNumberFormatException:for 
> input string: "5432,10.16.10.13:5432"/

Lets try that again:

To me it looks like whatever code you are using is trying to use 
"5432,10.16.10.13:5432" as the port number for 10.16.10.12. In other 
words it is not seeing the ',' as a separator for the two IP's'.

Time to clean the glasses:)

> 
> It looks like the first IP address has disappeared or is not set right./
> /
> 
> Thanks in advance for the help.
> 
> 
> //
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com