postgresql-8.0.jar and failure of ORDER BY parameters

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: postgresql-8.0.jar and failure of ORDER BY parameters
Date: 2005-05-04 08:24:50
Message-ID: 874qdjpfe5.fsf@meuh.mnc.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2005-05-04 11:54:16 Re: Connectivity of postgreSQL database to a JSP page
Previous Message sunil sunsunwal 2005-05-04 06:22:26 Connectivity of postgreSQL database to a JSP page