I think I may have finally figured out the source of this problem. I'm
getting a connection from a JDO connection manager (but not using
JDO here), and it reaps these connections with no activity after
10 seconds by default. Under load, some of the updates can take this
long, so I've upped the timeout, and this seems to have taken care
of the problem so far.
Thanks,
-Mike
----- Original Message -----
From: "Dave Cramer" <pg@fastcrypt.com>
To: "Mike Bridge" <mike@bridgecanada.com>
Cc: <pgsql-jdbc@postgresql.org>
Sent: Thursday, September 02, 2004 5:27 PM
Subject: Re: [JDBC] Connections dropped randomly
> Without seeing your code, or your setup, it's hard to say.
>
> But given that exactly the same thing is done by lots of other people
> without the problem, I'd be hard pressed to say it's a bug in the
> driver, or postgresql.
>
> Dave
> On Thu, 2004-09-02 at 19:09, Mike Bridge wrote:
> > I find that if I reuse a jdbc connection to perform a number of
> > update queries (e.g. 1000), the connection keeps getting dropped
> > after a random number of iterations.
> >
> > This occurs in all sorts of queries throughout my application. Any
> > idea what might be causing this? I'm not doing anything
> > out-of-the-ordinary, and it happens on both prepared statements
> > and regular statements.
> >
> > I had this problem in postgres 7.3, and it's still there after
> > upgrading to 7.4.4 & pg74.215.jdbc2.jar.
> >
> > Thanks,
> >
> > -Mike
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 8: explain analyze is your friend
> --
> Dave Cramer
> 519 939 0336
> ICQ # 14675561
> www.postgresintl.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>