All, One of the most annoying things about working in Java is finding open
cursors and cursor leaks as a user. Since I do not have production access,
nor can I run a query in tandem with the supplied compiled code, the best
choice is to query the jdbc drive in the appserver for the cursors.
The postgresql JDBC driver should report the number of open current cursors
on the connect. I can set holdability on a JDBC cursor, but I cannot get
the open cursor count.
In general, a parent object (e.g. connection as a factory) should
either retain a countable (or iterative) reference list of all objects that
are created, or allocate the object references to the observer/manager.
Thanks
Joe