Hi,
How can I do a connection pool ? I'm using a simple oracle connection when the
session starts.
thanks
anderson
"Aggarwal, Pawan" wrote:
> There is a problem faced while using the connection pool class in Oracle..
> I dont know how to tacke it..
>
> What i have is a pool of 50 connection...
> The moment the server is started and the first user logins then the 50
> connections are acquired..
>
> Now the time out for oracle session is 15 minutes and web server session
> time out is 30 min..
>
> If a user connects and then leave the screen for more than 15 mins then the
> oracle kills session
> and the number of connection from pool decrease from 50 to 49....
> Even if i open a new browser window and try to login then i get exceptions
> that connection time out
> which means i am not getting any of the 49 connections??
> I restart the web server problem is solved....
>
> What i am confused about is whether if there is no other user for at least
> lets say 2 hours
> then will all the connections (49) also die out as time out for session for
> oracle is 15 mins
> Then what is the use of connection pool...
> is there any difference between session and connection ....??
> There must be some way out?
> Does increasing the web server session time out > oracle session time out
> will help??
>
> Please advice\
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> 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".
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
