FYI
I have heard of connection managers using something like
"SELECT '1'" to keep the connections open and prevent them
from timing out.
-----Original Message-----
From: Thomas Preston [mailto:[EMAIL PROTECTED]]
Sent: 27 June, 2000 10:09 AM
To: [EMAIL PROTECTED]
Subject: Re: Session timeout
You probably need to have your Oracle timeout taken out. When you bring up
the server, the server grabs 50 connections. When the connections go unused
in the pool they will be timing out on you. There is probably some work
around for this with your app server. Probably you should review doc for
your app server with regard to Oracle and connection pooling.
>From: "Aggarwal, Pawan" <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Session timeout
>Date: Tue, 27 Jun 2000 18:30:41 +0530
>
>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
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
===========================================================================
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
