Re: JDBC connectivity issue

On 03/14/2018 07:51 AM, chris wrote:
>
> I believe its Postgresql-9.4.1208.jre7.jar

Pretty sure solving this is going to require knowing exactly what driver
is in use. The failover syntax looks to be fairly recent, so being off
by a little on the driver version can make a big difference.

Or you could do as this post suggests:

https://www.postgresql.org/message-id/CADK3HHJgdio_TZ-fpk4rguWaA-wWZFNZrjBft_T4jLBK_E_c8w%40mail.gmail.com

That is install driver version 42.2.1.

> On 03/13/2018 05:48 PM, Adrian Klaver wrote:
>> On 03/13/2018 04:46 PM, chris wrote:
>>> I'm sorry that took a few days but I am running;
>>>
>>>
>>> Postgresql-9.4
>>>
>>> and
>>>
>>> jre7.jar
>>
>> What we are looking for is the JDBC driver you are using?
>>
>>>
>>> Thanks in advance.
>>>
>>>
>>> On 03/08/2018 02: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?
>>>>
>>>>
>>>> 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