Re: application handing on send - Mailing list pgsql-jdbc

From shadowd@connection.com
Subject Re: application handing on send
Date
Msg-id 1085945185.40ba3561e442e@webmail.eol.ca
Whole thread Raw
In response to Re: application handing on send  (Warren Little <wlittle@securitylending.com>)
List pgsql-jdbc
Socket.setSoTimeout(int timeout) will do this on most platforms. Once set, any
blocking read will throw a java.net.SocketTimeoutException (subclass of
java.io.IOException) when the read times out. Like I said, this doesn't work on
*ALL* platforms, but I think Windoze and Linux are supported.

> Question to my own question:
>  Is there even such a mechanism in the Socket class to do a timeout on a
> write?
>
> On Fri, 2004-05-28 at 09:30, Warren Little wrote:
> > My tomcat application occasionally hangs trying push data to the
> > postgres backend.  When I view the connection to postgres with netstat I
> > see data sitting in the sendQ on the socket.
> > There is a firewall (cisco pix) between the tomcat server and the
> > database server.
> > I was wondering if there is some way to set the timeout on the driver as
> > to force a IO exception and terminate the jdbc request.
> >
> --
> Warren Little
> Senior Vice President
> Secondary Marketing
> Security Lending Wholesale, LC
> www.securitylending.com
> Tel: 866-369-7763
> Fax: 866-849-8079
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>





pgsql-jdbc by date:

Previous
From: "Michael Nonemacher"
Date:
Subject: Re: getGeneratedKeys method
Next
From: Sudarshan Marthala
Date:
Subject: unsubscibe