Skip to Main Content

Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

help with Connection close

411930Apr 3 2007 — edited Apr 6 2007
Hello.

I have been asked to find a way to solve this situation (I have not developed the java code and I have no work experience at coding with java):

- A PL/SQL stored function is called using JDBC from a web application.
- When the execution of the stored function ends, the java class closes the connection (at least, I can see in a log that con.close() is called, con being a Connection) but the usage of memory in the db does not decrease, so that the usage of memory becomes huge sooner than later.
- When I call the stored function from sqlplus the memory usage in the db decreases when I end my session.

Is there an easy way of ending the session from java in order to avoid this situation?

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2007
Added on Apr 3 2007
5 comments
2,080 views