you can use another syntax
WHERE userid = ANY (?)
and call PreparedStatement.setArray(). That means, you have to provide
an instance of java.sql.Array as parameter. For this purpose you can
implement this interface (It's not too difficult, I've done this.) or
use Connection.createArrayOff(). The last is available dependent on the
JDBC-Library you use. I have not tried it yet.
One advantage of ANY instead of IN is, that you can pass an empty array
without causing a SQL syntax error.
Tiago Alves schrieb:
> Sorry if you answer this before, I couldn't find it.
> I want to do something like:
> PreparedStatement ps = connection.prepareStatement("select * from users
> where userid in ?");
> Is this possible? How?
> Tiago A.
In response to
pgsql-jdbc by date
|Next:||From: Alexander Panzhin||Date: 2008-11-11 10:19:40|
|Subject: Re: Using SELECT IN with prepared statement|
|Previous:||From: Oliver Jowett||Date: 2008-11-11 01:46:04|
|Subject: Re: Pgsql jdbc driver 8.3 Build 603: Commit deadlock|