Received: from thor.candleweb.no (thor.candleweb.no [195.139.160.194])
	by hub.org (8.9.3/8.9.3) with ESMTP id HAA20657
	for <pgsql-interfaces@postgresql.org>;
	Thu, 25 May 2000 07:54:20 -0400 (EDT)
	(envelope-from gunnar@candleweb.no)
Received: (from gunnar@localhost) by thor.candleweb.no (8.10.0/8.10.0/on4)
	id <e4PBbcX17219>; Thu, 25 May 2000 13:37:39 +0200 (MET DST)
To: pgsql-interfaces@postgresql.org
Subject: Postgresql 7.0 JDBC exceptions - broken connections ?
Mime-Version: 1.0 (generated by tm-edit 7.106)
Content-Type: text/plain; charset=ISO-8859-1
From: Gunnar R|nning <gunnar@candleweb.no>
Date: 25 May 2000 13:37:38 +0200
Message-ID: <x6em6qx3lp.fsf@thor.candleweb.no>
Lines: 49
X-Mailer: Gnus v5.4.65/Emacs 19.34
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id HAA21259
X-Archive-Number: 200005/46

Hello, 

As I told you in an former mail I'm trying to migrate an application to use
PostgreSQL 7.0. The application now seems to be working pretty well and I
have 5 users that have been testing our web application with the PostgreSQL
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. Could
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 the
exception I get :

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
	at java.lang.Throwable.fillInStackTrace(Native Method)
	at java.lang.Throwable.fillInStackTrace(Compiled Code)
	at java.lang.Throwable.<init>(Compiled Code)
	at java.lang.Exception.<init>(Compiled Code)
	at java.sql.SQLException.<init>(SQLException.java:98)
	at org.postgresql.util.PSQLException.<init>(PSQLException.java:42)
	at org.postgresql.Connection.ExecSQL(Compiled Code)
	at org.postgresql.jdbc2.Statement.execute(Compiled Code)
	at org.postgresql.jdbc2.Statement.executeQuery(Compiled Code)
	at EntityActions.searchIndexImpl(Compiled Code)
	at SearchFasterServerEvents.serverRequest(Compiled Code)
	at progress.apptivity.server.abServer.serverRequest(Compiled Code)
	at progress.apptivity.server.abQuerySetImpl.serverRequest(Compiled Code)
	at progress.apptivity.client.iiop._abQuerySetImplBase.invoke(Compiled Code)
	at IE.Iona.OrbixWeb.CORBA.ServerDispatcher.dispatch(Compiled Code)
	at IE.Iona.OrbixWeb.CORBA.ServerDispatcher.system_dispatch(Compiled Code)
	at IE.Iona.OrbixWeb.CORBA.BOAImpl.continueThreadDispatch(Compiled Code)
	at IE.Iona.OrbixWeb.CORBA.ORB.continueThreadDispatch(Compiled Code)	
	at progress.apptivity.server.iiop.ow.a25.run(Compiled Code)
	at java.lang.Thread.run(Compiled Code)


Regards, 

	Gunnar