Re: Postgres Java Connection not closing.. Too many Clients Problem

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