Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org Received: (qmail 37388 invoked by uid 500); 4 Oct 2001 14:17:29 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk Reply-To: tomcat-user@jakarta.apache.org list-help: list-unsubscribe: list-post: Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 37356 invoked from network); 4 Oct 2001 14:17:29 -0000 Message-ID: <06d001c14cdf$3bab13d0$04012a0a@duke> From: "Alex Sanderson" To: References: <5.1.0.14.2.20011004141509.00a7dec0@correo> <5.1.0.14.2.20011004160656.00a80180@correo> Subject: Re: Problem in solaris Date: Thu, 4 Oct 2001 16:17:00 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS perl-11 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Oracle probably has a connection time limit. Maybe you should shut the db connection when you are finished with it and reopen it when you need it again. If you are worried about performance then you should be using a database pool. Tomcat 4 comes with tyrex which can do that for you. ----- Original Message ----- From: "H�ctor Garcia Peris" To: Sent: Thursday, October 04, 2001 4:09 PM Subject: Re: Problem in solaris At 14:26 04/10/01 +0200, you wrote: >Hello Hector > >Is the database running on the same machine as the tomcat engine? >If they are not on the same machine are the two machines on the same network? >Many routers/gateways etc.. will cut a tcp connection that has been inactive >for a period of time. Oracle may also have a timeout for a connection but I am >not sure about that. Maybe you should try opening/closing the connection each >time you use it or at least checking to see if it is still there before using >it. The database is running in a third database and there are in the same network. Is there any way to say oracle that the connexion is still active? --------------------------------------------------------------------- H�ctor Garcia Peris Dpto. Inform�tica Instituto Valenciano de Investigaciones Econ�micas S.A. (IVIE) C/ Guardia Civil, 22 esc-2 primero 46020 - Valencia ( Spain ) Tfno.: +34 - 963930816 Fax.: +34 - 963930856 e-mail: hector.garcia@ivie.es ----------------------------------------------------------------------