Hi,

I am firing a hql in a method say A and iterating throught the result in a loop.
Within the loop I am calling a method say B which inturn fires another hql or uses criteria.

When the control moves back to the loop in the calling method A, I get an exception "SQL Error: 17010 SQLState: null" and the cause is Resultset getting closed.

I am not able to trace the reason behind this exception. I am passing the same session object in both the methods and not closing it in anyof the two methods.

Looking forward for help on this topic.

Regards,
Ojas Velamkar