Hi,
Trying postgresql-8.0-310.jdbc3.jar and
postgresql-8.0-311.jdbc3.jar with a 7.4.5 server, ORDER BY
parameters in a preparedStatement are not taken in account
anymore (were ok when using 7.4.x JAR driver).
E.g.
SELECT .... ORDER BY ?, ?
..
actionSt = conn.prepareStatement( getQuery(),
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY );
..
actionSt.setInt( 1, 4 );
actionSt.setInt( 2, 5 );
the last part setting ORDER BY parameters, which have no effect
on the resultset we obtain.
Is there something I can do beside changing the version of the
server used?
Thanks.
--
Guillaume Cottenceau