Problem with populating ROWSET

[Tariq Khan]

Hi ,
I have a problem with ROWSET.
I have a table with 6 columns and approximately more than 200 records.
I reterive them in a ResultSet and resultset gets populated.
But I populate Rowset with that ResultSet then it hangs for more than 1 min and then it comes back to its original state.

Can anyone have thge idea why it happens....?
Is therer any issue with the Rowset ?
Why it takes too much time to populate the rowset..?

Here is my code

CachedRowSetImpl crs = new CachedRowSetImpl();
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet result = stmt.executeQuery(sql); // Here we have 250 records in ResultSet
crs.populate(result); // This is the problem. This line takes atleast 1min to execute

Any solution you gurus have ....
Its urgent please

Thanks
Tariq
[ July 26, 2007: Message edited by: Tariq Khan ]