Though you have limited number of users, generally, not all of them will be
using the dbConnection at the same time. So you need to use connection
pooling to conserve memory resources, as each connection abounts to gobbling
up certain sapce in memory. Since you do not want to jam your JVM with
unclosed connections, you should promptly close it after use.
hope this answers your question
thanks
-VA
-----Original Message-----
From: chintha ratnasiri [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 2:45 PM
To: [EMAIL PROTECTED]
Subject: Connection Issue
Hi,
I am not sure whether I should use Connection Pooling or Not. In an intranet
application where the connections for the number of concurrent users at
anytime (lets say 20) is supported by the database, is there an advantage to
using Connection Pooling? Could there be problems if we get a connection at
login, save it in a Bean with session scope and use it through out the
client session and disconnect at logout?
Hope someone can shred some light.
Thanks.
Chintha
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
===========================================================================
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
===========================================================================
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
