Re: JDBC connectivity issue

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