Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group