|
I am migrating from another database to PostgreSQL
and have run into a serious problem. The Java program runs fine on the other DB
but under PostgreSQL it gives the error, "ResultSet is closed."
This result set is created in a method that
processes each row sequentially. Within the processing, it passes the
result set to another method that retrieves columns from it and creates
additional result sets to retrieve related information. This second method can
also call itself recursively. This works fine with HSQLDB but fails when
returning back to the original method and attempting another loop on the
original result set, claiming it is closed.
I have removed all occurrences of closing any
result sets and there are no instances of closing underlying statements within
those methods. Finally, I have stepped through the entire operation with a
debugger and found no unexpected events. Each time a new result set was created,
the debugger indicated it to be a new entity. When finally returning to the
original, it appeared to be the correct instance.
Is there a known problem along these lines? Any
help or suggestions will be most appreciated.
Thanks,
Bayless
|
