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

RE: Postgresql 7.0 JDBC exceptions - broken connections ?

From: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>
To: "'Gunnar R|nning'" <gunnar(at)candleweb(dot)no>, pgsql-interfaces(at)postgresql(dot)org
Cc: "PostgreSQL Developers List (E-mail)" <hackers(at)postgresql(dot)org>
Subject: RE: Postgresql 7.0 JDBC exceptions - broken connections ?
Date: 2000-05-26 08:08:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-interfaces
As usual when replying from here, replies prefixed with PM:

Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Gunnar R|nning [mailto:gunnar(at)candleweb(dot)no]
Sent: Thursday, May 25, 2000 12:38 PM
To: pgsql-interfaces(at)postgresql(dot)org
Subject: [INTERFACES] Postgresql 7.0 JDBC exceptions - broken
connections ?


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
- I
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 UrlichsDate: 2000-05-26 08:16:31
Subject: Re: Berkeley DB...
Previous:From: Mikheev, VadimDate: 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 PageDate: 2000-05-26 08:32:12
Subject: RE: importing from other dbases
Previous:From: Peter MountDate: 2000-05-26 06:29:47
Subject: RE: JDBC for 7.0 - Tuple received before MetaData exception

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