Re: [Hibernate-devel] progress problem (attn: phillip baird)

[Gavin_King/Cirrus%<CI...@ci...>]

>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