Re: should i leave a connection open?
Use a connection pool and have the pool decide whether to leave it open. Opening and closing a connection takes a lot of overhead, so in your case leaving it open is usually better.
Having said that, you will need to have a system (connection pool) in place which makes sure your connections are not left open for too long and will reap idle connections. Cause if you don't monitor your open connections there is a increased danger of memory leaks and inefficient connection usage.
search google (msn, yahoo) on "JDBC connection pooling", and you'll find out more.
Regards,
Joost
Joost Schouten
CEO - JS Portal
http://www.jsportal.com
Subject
Written By
Posted
Re: should i leave a connection open?
June 30, 2005 09:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.