How to closeCursor object in Jasper report

[AnnMary.Thomas]

I have a query which returns 8 fields to generate the report. In this the first 7 fields are of various data types String, Big Decimal etc. But the last field returns Resultset object. (java.sql.Resultset). Within this cursor object I have 10 values which I am displaying in the report. Now the problem is I m calling next() method in one of the fields on this cursor object and displaying the data. Now the issue is as I am retreiving almost 200 records and each record has cursor object, Im running into problems like Opn Cursor Exceed error, as Im not closing these cursors. How can we close these cursor object? Or is ther an alternate approach for this?

 

ireport 4.0

jasper 4.6