Re: application handing on send

From: shadowd(at)connection(dot)com
To: Warren Little <wlittle(at)securitylending(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: application handing on send
Date: 2004-05-30 19:26:25
Message-ID: 1085945185.40ba3561e442e@webmail.eol.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message edwin karundeng 2004-05-31 18:48:32 Re: unsubscribe
Previous Message Atul Arora 2004-05-29 03:28:10 UNSUBSCRIBE