Re: JDBC connectivity issue

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: chris <chrisk(at)pgsqlrocket(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: JDBC connectivity issue
Date: 2018-03-22 09:06:49
Message-ID: CADK3HHLv=XZ4r2i4QOe0FWWQ9XC0Nro7p+mXpi3a0uz4-YKLwg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris,

At this point I'd write small piece of code to test if the url and failover
is working correctly. Sounds like you have a considerably sized stack
making it difficult to debug.
With a small piece of code it should become clear as to how things work or
don't as the case may be

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

On 21 March 2018 at 17:13, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

> On 03/21/2018 01:56 PM, chris wrote:
>
>> I did the re install not to change versions but to now know what version
>> I am running
>>
>
> My previous question was not as clear as should have been.
> So:
> 1) At some place in your software stack there is some sort of
> configuration that links your app via JDBC to a Postgres JDBC driver. If
> you know where that configuration is you should be able to find the driver
> and presumably the version.
> 2) So when you say you did a reinstall do you mean you are now pointing
> the configuration at postgresql-42.2.1.jre7.jar? FYI
> postgresql-42.2.2.jre7.jar is actually the latest:
> https://jdbc.postgresql.org/download.html
>
>
>
>>
>> On 03/21/2018 02:44 PM, Adrian Klaver wrote:
>>
>>> On 03/21/2018 01:16 PM, chris wrote:
>>>
>>>> I wasnt able to find what version we had installed so we went ahead and
>>>> reinstalled it
>>>>
>>>
>>> Maybe I am missing something, but if you could not find the version you
>>> where using how do you know installing a new driver actually changed the
>>> version you are using now?
>>>
>>>
>>>
>>>> we downloaded the current version JDBC 4.1 Driver 42.2.1.jre7
>>>>
>>>>
>>>> We are still having the same problem.
>>>>
>>>> Thanks
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devart 2018-03-22 09:53:56 Introducing brand-new dbForge Studio for PostgreSQL, a powerful IDE for working with PostgreSQL databases
Previous Message Laurenz Albe 2018-03-22 08:33:45 Re: Prepared statements