Prepared Statement Issues.

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