Many Thanks Shailesh.
However none of the above apply to the scenario. We did a lot of Research and
testing at our end. Following are the scenarios and the conclusions.
We tested the application by connecting to DataSource of Oracle 9i. It worked perfectly fine. No resultsets were closed.
The same piece of code connecting to Oracle 10g datasource fails.
Next we tried connecting to Oracle 10g through DriverManager instead of Datasource. It worked perfectly fine.
Our conclusion is that Oracle 10g datasource has some issues which we are not clear about. Is it because we are updating the same table as that of the resultset in the same connection that the resultset is getting closed? We are not too sure of this. Would be glad if anyone can shed some light on this.
Thanks a lot
Jayashree Nair