Prepared Statement Issues.

From: Greg Johnson <gregj(at)interprose(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Prepared Statement Issues.
Date: 2003-10-23 15:33:50
Message-ID: 1066923229.28266.912.camel@watto.interprose.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message FERNANDA M. 2003-10-23 23:19:35 Retrieving bytes error!!
Previous Message ni3india 2003-10-23 14:40:21 Source code JDBC driver