As usual when replying from here, replies prefixed with PM:
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
From: Gunnar R|nning [mailto:gunnar(at)candleweb(dot)no]
Sent: Thursday, May 25, 2000 12:38 PM
Subject: [INTERFACES] Postgresql 7.0 JDBC exceptions - broken
As I told you in an former mail I'm trying to migrate an application to
PostgreSQL 7.0. The application now seems to be working pretty well and
have 5 users that have been testing our web application with the
database for the past 24 hours.
The application runs with a connection pool, but after some time some of
these connections seems to be broken. Ie. only some of the queries work
will change the connection pool code to handle this, but I would like to
know if anybody know why the connections gets into an unusable state.
it be back crashes or similar things ? I'm turning on debugging for the
database server to see if can find anything there, but anyway here is
exception I get :
PM: How long is it before the problem starts? I'm wondering if the
problem is because the backend is sitting there for a long period.
select distinct entity.*,location.loc_id,location.loc_name
from entity,locationmap,location,entityindex2 as e0
where locationmap.ent_id=entity.ent_id and
locationmap.loc_id=location.loc_id and e0.ei_word='kjøttbørsen' and
e0.ent_id=entity.ent_id and ENT_STATUS=4
order by ent_title,location.loc_name,location.loc_id
Unknown Response Type u
PM: Does anyone [on Hackers] know what the u code is for? The fact it's
in lower case tells me that the protocol/connection got broken somehow.
pgsql-hackers by date
|Next:||From: Matthias Urlichs||Date: 2000-05-26 08:16:31|
|Subject: Re: Berkeley DB...|
|Previous:||From: Mikheev, Vadim||Date: 2000-05-26 07:00:26|
|Subject: RE: smgrwrite() without LockBuffer(was RE: Shouldn't flush dirty buffers at shutdown ?) |
pgsql-interfaces by date
|Next:||From: Dave Page||Date: 2000-05-26 08:32:12|
|Subject: RE: importing from other dbases|
|Previous:||From: Peter Mount||Date: 2000-05-26 06:29:47|
|Subject: RE: JDBC for 7.0 - Tuple received before MetaData exception|