Hi, I am using an Oracle backed JDBCContentStore with slide 1.0.16.
Everytime we download a document - eg through the webapp. A new cursor is being opened - but this never seems to be being released. We found this out because we hit the "ORA-01000 maximum open cursors exceeded" error from oracle. I am guessing that the above class/method is the likely candidate - as it seems to be the method that gets the content. It also does not seem to release the prepared statement it creates. Looking at it, I presume we cannot just close it in the method - as the input stream for the binary object won't have been read at that point. So - should it read the whole object in and then close the connection here? Or should some finaliser code in the NodeRevisionContent object close the connection? Although this option does not sound right... Comments - I will probably go for the first option in my code - let me know if you want the patch? Regards, Chris ===== Need somewhere to Live in London? - Then go to http://freeflats.com __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
