tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Sanderson" <a...@duke-interactive.com>
Subject Re: Problem in solaris
Date Thu, 04 Oct 2001 14:17:00 GMT
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" <hector.garcia@ivie.es>
To: <tomcat-user@jakarta.apache.org>
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
----------------------------------------------------------------------






Mime
View raw message