Skip site navigation (1) Skip section navigation (2)

Re: Upgrade question, going from 8.3 to 9.1...

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Віталій Тимчишин <tivv00(at)gmail(dot)com>
Cc: Ned Wolpert <ned(dot)wolpert(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Upgrade question, going from 8.3 to 9.1...
Date: 2012-02-15 20:48:54
Message-ID: CADK3HH+qFrH81cSbUTvLixz84_HPVt98YELhLwkcxfrUSZw6ww@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(at)gmail(dot)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(dot)wolpert(at)gmail(dot)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

In response to

Responses

pgsql-jdbc by date

Next:From: ImranDate: 2012-02-16 10:25:37
Subject: Re: non-trivial finalize() on AbstractJdbc2Statement
Previous:From: Віталій ТимчишинDate: 2012-02-15 20:45:35
Subject: Re: Upgrade question, going from 8.3 to 9.1...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group