Skip site navigation (1) Skip section navigation (2)

Re: Connections dropped randomly

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Mike Bridge <mike(at)bridgecanada(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Connections dropped randomly
Date: 2004-09-02 23:27:15
Message-ID: 1094167635.1543.28.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-jdbc
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


In response to

Responses

pgsql-jdbc by date

Next:From: Shanmugasundaram DoraisamyDate: 2004-09-03 01:05:18
Subject: Out of topic - Need help with connecting Java programs on Linux to Access DB - reg.
Previous:From: Mike BridgeDate: 2004-09-02 23:09:53
Subject: Connections dropped randomly

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group