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.
Alex ----- Original Message ----- From: "Héctor Garcia Peris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 04, 2001 2:15 PM Subject: Problem in solaris Hello list, I'm using tomcat 3.2.3 with apache in a solaris 2.7. I have downloaded the source code of tomcat 3.2.3 and compile it in the solaris 2.7. I have other computer with tomcat in a debian linux. The version of tomcat is the binary file of the 3.2.2. The problem is that I have a servlet that gets information from an oracle database and returns a table with the results. When I run this servlet in the linux machine there isn't any problem, but when I run it in the solaris the conexion to the oracle database downs after aproximately one hour (I don't know exactly the time). Why happens this? Is possible that the dispose of the servlet in the solaris doesn't work fine? Any help? Thanks. --------------------------------------------------------------------- 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: [EMAIL PROTECTED] ----------------------------------------------------------------------
