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