IN clause in PreparedStatement
843859Apr 23 2009 — edited Nov 20 2014I have a SELECT statement :
"select A, B, C from SOME_TABLE where SOME_FIELD in ( ? )",
"?" could be (1,2,3) or (1,2,3,4,5) etc.
I tried to use "setArray" method however it doesn't work. The obvious workaround is to generate IN clause and to append it to the query. But I would rather use PreparedStatement standard approach. Is it possible?
thanks in advance.