2 Replies Latest reply on Mar 15, 2005 6:13 PM by Steven Ostrowski

    JBoss Connection Pool is holding large PreparedStatements -

    Steven Ostrowski Newbie

      Hello, I was getting OutOfMemoryError in my application, so I started some profiling.

      I found out that after an Oracle query, the JBoss ConnectionPool is still holding 180MB in Oracle PreparedStatements.

      I initially had prepared statement cache turned to 10 statements. However, I removed that line from my Oracle DS config and this problem is still occurring.

      btw - yes, I am closing my result sets and prepared statements, i've checked the obvious

      It seems like JBoss' pool or cache should be able to release these objects, especially if memory is low.

      I've posted a screenshot of the heapdump here:
      http://www.dealraider.com/heapDump.jpg[/url]