Hi All,
I'm using JDBC against and Oracle DB to retrieve BFILE documents. These are
files stored on the Unix filesystem but referenced in the DB so that it can
access them. I do something like
SELECT bfile_data INTO o_bFile FROM Documents WHERE .....
in a stored procedure and return the Bfile to my web application.
The issue I'm getting is that Oracle has started to throw out of Shared
Memory errors when accessing pages which do this. I can increase the memory
available to Oracle, but I'm guessing this will simply make it happen later.
Is there any way I can get the information from Oracle into a Java Object
and release the reference -- so Oracle can reclaim the shared memory
space -- quickly? Is this as simple as closing the callable statement?
Thanks,
Clayton
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
