Re: Upgrade question, going from 8.3 to 9.1... - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Upgrade question, going from 8.3 to 9.1...
Date
Msg-id CADK3HH+qFrH81cSbUTvLixz84_HPVt98YELhLwkcxfrUSZw6ww@mail.gmail.com
Whole thread Raw
In response to Re: Upgrade question, going from 8.3 to 9.1...  (Віталій Тимчишин <tivv00@gmail.com>)
Responses Re: Upgrade question, going from 8.3 to 9.1...  (Ned Wolpert <ned.wolpert@gmail.com>)
List pgsql-jdbc
My memory seems to be failing, yes, you will probably need a newer driver.
Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca



2012/2/15 Віталій Тимчишин <tivv00@gmail.com>:
> I do remember some problems discussed with 9.1. AFAIR here it
> is: http://grokbase.com/t/postgresql/pgsql-hackers/114jz3zdpb/jdbc-connections-to-9-1
> According to the thread, driver was fixed, so you need 9.1 driver to handle
> this problem.
>
>
> 2012/2/15 Ned Wolpert <ned.wolpert@gmail.com>
>>
>> Folks-
>>
>>   We're in the process of upgrading our postgresql install from 8.3 to
>> 9.1.2. Our main application is using postgresql-8.3-606.jdbc3.jar against
>> the existing postgresql database. (Java jdk1.6.0_29, Oracle's version, not
>> OpenJDK.  Its in use by hibernate. (Other Java applications use the database
>> too, but mostly via hibernate or rbatis)
>>
>>   My questions are:
>> 1) is it necessary to upgrade the jdbc jar file to the 9.1 version, or is
>> the 8.3 version 'upwards' compatible? If it is, can someone point out me to
>> what I would fail in apps that did not upgrade?
>> 2) Even though we are not using features from the JDBC4 version, should we
>> still use the JDBC4 variant due to the 1.6 JDK version?
>> 3) Is there any potential issues if an application is using the latest 9.1
>> JDBC driver against postgresql 8.3.x database?
>>
>> Obviously, we're hoping not to require an updated jar file, and just delay
>> the upgrade until the next application release. But I need to know if
>> upgrading the JDBC driver with the database upgrade cannot be avoided.
>>
>> Thanks
>>
>> --
>> Virtually, Ned Wolpert
>> http://codehead.tumblr.com/
>> http://codeheadsystems.wordpress.com/
>>
>> "Settle thy studies, Faustus, and begin..."   --Marlowe
>
>
>
>
> --
> Best regards,
>  Vitalii Tymchyshyn

pgsql-jdbc by date:

Previous
From: Віталій Тимчишин
Date:
Subject: Re: Upgrade question, going from 8.3 to 9.1...
Next
From: Imran
Date:
Subject: Re: non-trivial finalize() on AbstractJdbc2Statement