>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 _______________________________________________ Hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
