Roman,

> To solve this issue at work I have created a dynamic proxy for
> Connection and PreparedStatement that track statement creation and
> closing and print list of not closed statements with their allocation
> point on connection.commit(), connection.rollback() and
> connection.close(). This works perfectly.

This sounds really useful. Any chance of committing it to the project?

Thanks

Dave
--
David Warnock, Sundayta Ltd. http://www.sundayta.com
iDocSys for Document Management. VisibleResults for Fundraising.
Development and Hosting of Web Applications and Sites.