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

Hi Jorge

Thank you for your accurate answers and kind understanding for our situation.
Now I understand below and these info is very useful for our team !

  - the old driver(8.1-404 JDBC3) technically can connect to postgresql 9.3 but some new features should not be
available,and we won't get the bugfixes of later version. 

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

One more question which might be last question....

  (Q) My understanding below is correct ??

      Versions of jdbc driver that supported Java 5 can't connect to postgresql 9.4 or later 
      because 
       - the versions of jdbc driver don't support JDBC 4, 41 and 42
       - the versions of postreqsql don't support JDBC3

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/17, Tue 08:21
>Subject: Re: [JDBC] old JDBC driver (8.1-JDBC3) can connect to postgresql 9.x ?
>
>
>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
shouldbe 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
futurewe 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
postgresql8.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
postgresql8.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
>>>>
>>>
>>>
>>>
>>
>
>
>