JBoss Connection Pool is holding large PreparedStatements -

[alchemista]

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]

[alchemista]

Sorry, the URL got messed up. Let's try this again:

http://www.dealraider.com/heapDump.jpg

[alchemista]

I switched back to my own implementation of connection pooling, and the same error is happening, so this doesn't seem to be a JBoss problem.

I'm now trying to diagnose whether this is a bug with the Oracle driver.