Setting int[], String[] in PreparedStatements

Hi,

        I would like to ask if someone here maybe knows a ways how to set an array of integers (or Strings, floats, etc.) with JDBC's PreparedStatement.

Example:

(Oracle)PreparedStatement ps = conn.prepareStatement ("select * from TableX where y IN (?)");
ps.setInts (1, int [] {1,2,3});

Something like that...

Thanks a lot :-)

Chao:

        Laci

-- 
Laszlo Papp

Epigenomics AG       www.epigenomics.com      Kleine Präsidentenstr. 1.
+49-30-24345-0                                      10178 Berlin