Re: [JDBC] old JDBC driver (8.1-JDBC3) can connect to postgresql 9.x ?

Поиск
Список
Период
Сортировка
От Jorge Solórzano
Тема Re: [JDBC] old JDBC driver (8.1-JDBC3) can connect to postgresql 9.x ?
Дата
Msg-id CA+cVU8PYLCgZ6mnXsbOn8r-uJ0QvRo7kqids0MnwUW77d+qj+A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [JDBC] old JDBC driver (8.1-JDBC3) can connect to postgresql 9.x ?  ("itoshun001@efeel.to" <itoshun001@efeel.to>)
Ответы Re: [JDBC] old JDBC driver (8.1-JDBC3) can connect to postgresql 9.x ?  ("itoshun001@efeel.to" <itoshun001@efeel.to>)
Re: old JDBC driver (8.1-JDBC3) can connect to postgresql 9.x ?  ("itoshun001@efeel.to" <itoshun001@efeel.to>)
Список pgsql-jdbc
On Mon, Jan 16, 2017 at 4:41 PM, itoshun001@efeel.to <itoshun001@efeel.to> wrote:
Hi Jorge

Thank you much for your quick reply !
Now I understand the new JDBC driver (9.3 Build 1103) will work with postgresql 8.3 and 9.3.

I have an additional question (sorry for my sticky question)

  (Q) We would be happy if we can use the old jdbc driver(8.1-404 JDBC3) also to postgresql 9.3.
      Is it possible technically ?
      (I know it's not supported version and might have problems fixed by later versions)

​Yes, it is technically possible but some new features should not be available, and you wont get the bugfixes of later version.


I ask this because:
  - the old jdbc driver is stable for existing functions on our web app
  - the number of existing functions affected by upgrading a JDBC driver is so large on our web app

​The driver should be highly compatible with earlier versions, and if your web app is using standard jdbc, then it should be practically transparent the change (you don't even need to recompile).


Now many existing functions are connecting to postgresql 8.3 with the old jdbc driver on our web app and in the near future we will connect a few new functions to postgresql 9.1.
Then upgrading jdbc driver needs many tests and using old jdbc driver also to postgresql 9.1 needs a few tests.

As as usual a proper testing prior to production should get you the idea if it will break something.​

 

Sorry to be so demanding .... and thank you for your kindness.


Best regards,
itoshun


----- Original Message -----
>From: Jorge Solórzano <jorsol@gmail.com>
>To: "itoshun001@efeel.to" <itoshun001@efeel.to>
>Cc: "pgsql-jdbc@postgresql.org" <pgsql-jdbc@postgresql.org>
>Date: 2017/1/16, Mon 22:32
>Subject: Re: [JDBC] old JDBC driver (8.1-JDBC3) can connect to postgresql 9.x ?
>
>
>The last version that supported Java 5 is 9.3 Build 1103, so you should use that version and it will work with postgresql 8.3 and postgresql 9.3.
>
>
>
>Jorge Solórzano
>
>
>On Mon, Jan 16, 2017 at 1:05 AM, itoshun001@efeel.to <itoshun001@efeel.to> wrote:
>
>Hi exports,
>>
>>Thanks for your great effort and works for JDBC drivers.
>>Now I have one question.
>>
>>  (Q) Can the old JDBC driver(8.1-404 JDBC3) connect to latest or supported versions(greater than 9.1) of postgresql ??
>>
>>We would be happy if we have an answerfor this because of the background below although it's not supported version currently...
>>I hope that postgresql 9.x can handle V3 JDBC protocols even if a versions of jdbc3 driver on clients is old.
>>
>>  Background:
>>    - Our old web application is running on JVM 1.5 + tomcat5 + JDBC driver(8.1-404-JDBC3) + postgresql 8.3.22
>>    - Now we plan to get to connect the application to postgresql 9.x(setup newly) in addition to the existing postgresql 8.3.22.
>>
>>Thanks and best regards,
>>itoshun
>>
>>efeel web administrater
>>
>>
>>--
>>Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
>>To make changes to your subscription:
>>http://www.postgresql.org/ mailpref/pgsql-jdbc
>>
>
>
>

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Jorge Solórzano
Дата:
Сообщение: Re: [JDBC] JDBC String to Bool spec
Следующее
От: "itoshun001@efeel.to"
Дата:
Сообщение: Re: old JDBC driver (8.1-JDBC3) can connect to postgresql 9.x ?