Re: Postgres Java Connection not closing.. Too many Clients Problem - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Postgres Java Connection not closing.. Too many Clients Problem
Date
Msg-id 20030505093003.GA10382@svana.org
Whole thread Raw
In response to Postgres Java Connection not closing.. Too many Clients Problem  ("John Kunchandy" <johnk@stylusinc.com>)
List pgsql-general
On Mon, May 05, 2003 at 02:13:06PM +0530, John Kunchandy wrote:
> SO in Short I am not able to close the connection in the class Files(MODEL)
> because the Result set is to be sent back after the select .
> I am not able to close the connection in the Control Servlet( CONTROL)
> because I have to send the Result Set to the jSP page to be shown.So even if
> I write connection.close() it will nto since the Result Se is not empty.

Are you sure about this? Most of the time you can keep using ResultSets even
after you've closed the connection. So you can do it just after you execute
the query.

I don't have any experience with connection pool or JSP so I can't comment
on the rest.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington

Attachment

pgsql-general by date:

Previous
From: Ralph Graulich
Date:
Subject: Re: problems restoring 7.2.1 dump to 7.3.2
Next
From: Martijn van Oosterhout
Date:
Subject: Re: problems restoring 7.2.1 dump to 7.3.2