Re: Need java.sql.Array impl for PreparedStatement.setArray()

[tauron]

What is the recommended way to implement queries like
SELECT id FROM table WHERE x IN (1,2,3)
using a PreparedStatement in the current Connector/J 3.1.10?


PreparedStatement pStmt = connection.prepareStatement("SELECT id FROM table WHERE x IN ?");
int[] array = {1,2,3};
pStmt.setString(1, array); // <- won't work
ResultSet rs = pStmt.executeQuery();