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
