Re: JDBC connectivity issue

I believe its Postgresql-9.4.1208.jre7.jar
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.
>>>>>
>>>>>
>>>>> //
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>
>