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