Prepared Statement Issues. - Mailing list pgsql-jdbc

From Greg Johnson
Subject Prepared Statement Issues.
Date
Msg-id 1066923229.28266.912.camel@watto.interprose.net
Whole thread Raw
Responses Re: Prepared Statement Issues.
Re: Prepared Statement Issues.
List pgsql-jdbc
I recently have been trying to update to the 113 build of jdbc drivers,
but I am having some problems. I have several prepared statements where
I pass in order by column and the order of the sort.

select id, name, address, state from people order by (?) (?)

However, with the 113 build I cant seem to set the column name to order
by or the sort direction anymore. With the 112 build I just set the SQL
type to INTEGER and it passed through.  I also used the same "hack" to
pass an array of values to IN statements.

select id, name, address, state from people where id in (?);

What java sql type do I need to use for these types of queries?

Thanks For you Help!


________________________________________________________________________
Greg Johnson
The InterProse
Consulting Group, Inc.
http://www.interprose.com
t (360) 604-3531 x225
f (360) 604-3579






pgsql-jdbc by date:

Previous
From: "Mike Kenny - CPX Mngd Services"
Date:
Subject: No suitable driver
Next
From: Francisco Villavicencio
Date:
Subject: Unable to run Applets with appletviewer