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

Ned,

If you can make a connection then you should be fine, other than the
meta data issues

Dave Cramer

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

2012/2/16 Ned Wolpert <ned(dot)wolpert(at)gmail(dot)com>:
> So, the driver issue was only in dealing with UNICODE issues? Is it true
> that if we are always set with UNICODE client_encoding we should be fine?
> (Or, another way to put it, we have already tested connection from the
> existing java apps using the 8.3 driver to the new 9.1 database test
> instance, and they worked 'just fine' for initial queries... is that where
> this problem would manifest itself? Only in connecting?) Or was there
> something else I missed in that thread?
>
>
> 2012/2/15 Dave Cramer <pg(at)fastcrypt(dot)com>
>>
>> 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
>
>
>
>
> --
> Virtually, Ned Wolpert
> http://codehead.tumblr.com/
> http://codeheadsystems.wordpress.com/
>
> "Settle thy studies, Faustus, and begin..."   --Marlowe