>The Progress Knowledge base this to say about this error. Maybe Gavin
>can advise why so many cursors may be open?
> [snip]
>The Progress Version 9.x SQL-92 engine has a limit of 50 open cursors
>for a given connection. This limitation has been logged as Progress
>bug 20000331-019.
Much thanks Phil.
Well, I spotted _something_. ClassPersister.insert() was opening a
ResultSet
and then not closing it. I fixed that in CVS. However, until now I havn't
really been extra careful about closing resultsets (its not usually done in
a try/finally), working on the assumption that the Session always closes
all PreparedStatements at the end of the session. Is there aomething wrong
with this approach, I wonder?
Anyways. Don't know if adding that rs.close() will fix the bug but could
someone running Progress please check it out for me? TIA.
Gavin
|
