And I have also the same trouble, but it's a JDBC Exception which is thrown
by a JSP page connecting to oracle thru a RMI server.. basically, I'v setup
an RMI Interface which offers SQL access to a SGBD, and in the
implementation of this Interface I use JDBC stuff to execute the SQL
statement...
A broken pipe exception is then thrown if the user stays inactif a long
time... To my mind, its either the socket in the thin oracle drive which is
duty...
But I'm still searching for a solution...
_______________________________________________________
Laurent LAUBIN S2M
Ingénieur système 2, rue des champs - BP 2282
Tél : +33 232 64 33 76 27950 St-Marcel - France
Fax : +33 232 21 25 99 http://www.s2m.fr/
_______________________________________________________
-----Message d'origine-----
De : Cato, Christopher [mailto:[EMAIL PROTECTED]]
Envoyé : jeudi 22 février 2001 14:37
À : '[EMAIL PROTECTED]'
Objet : RE: Broken pipe error
> Hi:
> I get "broken pipe error" when trying to re-execute a servlet after
> several hours of innactivity. Then I must re-start Tomcat to get all
> running again.
> The servlet is connected to a database using oracle thin driver, these
> connection is still active.
> So my question is:
> It is possible that the socket between Tomcat and database is being
> closed by Tomcat?
> If the answer is yes, how can I configure these timeout.
>
> Regards.
> Xavier Escandell.
I used to have the exact same problem with my TomCat / MySQL application
until i added autoreconnect=true to the db connection initiator method in my
general db tool class. Since then, the problem ceased.
/Christopher Cato
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]