| Lists: | pgsql-jdbc |
|---|
| From: | Warren Little <wlittle(at)securitylending(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | application handing on send |
| Date: | 2004-05-28 15:30:07 |
| Message-ID: | 1085758206.5841.21.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
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
| From: | Warren Little <wlittle(at)securitylending(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: application handing on send |
| Date: | 2004-05-28 17:16:40 |
| Message-ID: | 1085764600.5841.35.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
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
| From: | Atul Arora <vartul_arora(at)yahoo(dot)co(dot)in> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | UNSUBSCRIBE |
| Date: | 2004-05-29 03:28:10 |
| Message-ID: | 20040529032810.18700.qmail@web8207.mail.in.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
Yahoo! India Matrimony: Find your partner online.
| 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 |
| 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
>