> the same is done for the child in the function copyMba, which calls
> the function for its "child table" for a maximum depth of 5 starting
> from the top. I commit in the main function (call rollback if I get an
> exception). I get the exception at depth 4 . In the resultset there
> should be 3 rows. The exception is thrown on rs.next() on the last
> row.

Do you use the same statement? I suspect that your result set is
closed automatically. This happens if:

- another statement is executed using the same object;
- transaction is committed;
- statement is closed.

Can you check if this is not the case and if not, prepare a test case?

Best regards,
Roman Rokytskyy