Re: JDBC connectivity issue

On 03/08/2018 01:30 PM, chris wrote:
> Given that the syntax looks correct for the url, how would we go about
> debugging that it's not seeing the comma?

From previous post:

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

>
>
> On 03/08/2018 02:27 PM, Adrian Klaver wrote:
>> 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(dot)klaver(at)aklaver(dot)com