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