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/

That seems to be correct:

https://jdbc.postgresql.org/documentation/94/connect.html
"Connection Fail-over

To support simple connection fail-over it is possible to define multiple
endpoints (host and port pairs) in the connection url separated by
commas. The driver will try to once connect to each of them in order
until the connection succeeds. If none succeed, a normal connection
exception is thrown.

The syntax for the connection url is:

jdbc:postgresql://host1:port1,host2:port2/database"

>
> 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"/
>
> It looks like the first IP address has disappeared or is not set right./

To me it looks whatever code you are using is trying to us
"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'.

Can you provide more information about the JDBC version you are using
and the app code you are using?

> /
>
> Thanks in advance for the help.
>
>
> //
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com