Re: JVM & JDBC Upgrade --- Help !!

Hi Oliver, a little research later and it does appear to be the case that
getFetchSize used to return the size of the resultset, but now doesn’t.

We were looking to upgrade Apache, Tomcat, PostgreSQL DRivers and ultimately
PostgreSQL itself, but in all honesty to change all the instances of this to
work in some other way would be a major undertaking for the application
developers.

As such, we will likely continue with what we have, as simply put, it works
!!

Thanks for your input.

Craig

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Oliver Jowett
Sent: 23 September 2011 00:42
To: craig(dot)golby(at)dignitas(dot)ltd(dot)uk
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] JVM & JDBC Upgrade --- Help !!

On 23 September 2011 11:16, Craig Golby <craig(dot)golby(at)dignitas(dot)ltd(dot)uk> wrote:

>         int rowCount = rsID.getFetchSize();

Well, there's your problem, getFetchSize() doesn't return the number
of rows in a resultset, it returns whatever fetch size is in use,
which defaults to 0.
(That's probably something that has changed since the 7.3 driver - the
7.3 driver did do some odd nonstandard things in that area, and if you
relied on them then yes your code will break)

Oliver