Thread: application handing on send
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
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
Yahoo! India Matrimony: Find your partner online.
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 >