Martin Gainty wrote: >are you running as a Transaction?
In some cases, but a lot of these lingering cursors are on very simple queries, with no insert/update/delete involved. As I said before, I'm finding lingering cursors on things as simple as "SELECT * FROM some_table WHERE id = ?". That does make me wonder though if there are Connection's getting sent back to the pool that had a pending transaction without a commit/rollback and if that could be making any cursors on that connection after that linger? It might explain the randomness of the queries showing up in the list. It also gives me a question I can send to my Java-challenged Oracle DBA. Thanks for the idea. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
