Can't create recordset within recordset

[webmasterbeta]

Hi,I have a typical requirement where i am creating one recordset using JavaSQL package. While iterating through recordset, i am creating other recordsetusing the same connection. JVM at run time gives an error "Connection isbusy in handling other statement". i.e. multiple statements can not be createdusing single connection, so, how to solve this?????ThanX,Pranav