Yea, and if you are using WebLogic you may get by with setting
refreshTestMinutes which will use all of the connections every n minutes.
Here is the WL doc for this app server specific feature:
refreshTestMinutes
(Optional) This property, together with the testTable property, enables
autorefresh of connections in the pools. At a specified interval, each
unused connection in the connection pool is tested by executing a simple SQL
query on the connection. If the test fails, the connection's resources are
dropped and a new connection is created to replace the failed connection.
The default value is 1.
To enable autorefresh, set refreshTestMinutes to the number of minutes
between connection test cycles - a value greater than or equal to 1. If you
set an invalid refreshTestMinutes value, the value defaults to 5 minutes.
Set testTable to the name of an existing database table to use for the test
(required).
>From: "Cogley, Jonathan" <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Session timeout
>Date: Tue, 27 Jun 2000 10:12:35 -0400
>
>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
________________________________________________________________________
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
