postgresql-8.0.jar and failure of ORDER BY parameters - Mailing list pgsql-jdbc

From Guillaume Cottenceau
Subject postgresql-8.0.jar and failure of ORDER BY parameters
Date
Msg-id 874qdjpfe5.fsf@meuh.mnc.ch
Whole thread Raw
Responses Re: postgresql-8.0.jar and failure of ORDER BY parameters
List 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

pgsql-jdbc by date:

Previous
From: sunil sunsunwal
Date:
Subject: Connectivity of postgreSQL database to a JSP page
Next
From: Dave Cramer
Date:
Subject: Re: Connectivity of postgreSQL database to a JSP page