Re: JDBC connectivity issue

From: chris <chrisk(at)pgsqlrocket(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: JDBC connectivity issue
Date: 2018-03-14 20:47:50
Message-ID: 4d52b5cc-7381-5f86-58ce-8512d14b7e6a@pgsqlrocket.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oh sorry for getting the wrong information.

How would I get the information on what driver is currently installed?

On 03/14/2018 09:44 AM, Adrian Klaver wrote:
> 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.
>>>>>>>
>>>>>>>
>>>>>>> //
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message chiru r 2018-03-14 21:17:44 PgBackrest questions
Previous Message pinker 2018-03-14 20:02:52 Re: Need followup setup instructions to postgresql-10.3-1-linux-x64.run