Any views on the following behaviour would be appreciated. I am using

INFORMIX-OnLine 7.31.UD7
IBM Informix JDBC Driver for IBM Informix Dynamic Server 2.21.JC5

Some code....

PreparedStatement ifxStmt2 = ifxCxn.preparedStatement("select iddoc
from corrapp where identity IN (?));

This works - with only one value in the list of IN values to bind...

ifxStmt2.setString(bind, "'000000010'");
ifxStmt2.execute();
rSet = ifxStmt2.getResultSet();
while (rSet.next()) {
this code is executed
}

In the above case a ResultSet object with a number of rows is returned.

However, if I add a second value to the list of IN values (below I just
duplicate the first value and expect the same set of results) an empty
ResultSet object is returned (no exceptions raised)...

ifxStmt2.setString(bind, "'000000010','000000010");
ifxStmt2.execute();
rSet = ifxStmt2.getResultSet();
while (rSet.next()) {
this code is NOT executed
}

This same second version of the query executed on the server works OK.
The identity column type is CHAR(12) but I have investigated issues
with padding using "'   000000010" or indeed "'000000010   '" for the
IN list values to no avail.

Many thanks,

Mark