Re: Postgres Issue with JDBC

On Mon, 2003-05-05 at 11:53, John Kunchandy wrote:
> Hi Tony
>
> Thanks for your prompt Reply.Could you pease guide me in closing the
> connection without affecting the functioning of my application elsewhere.
> what should I do??I am giving the step by step procedure followed.please
> mark against the step where I shoudl close the connection and how I shoudl
> close the correct connection .
> 1)The JSP Page sends a request
> 2)The Control Servlet understands the Request retrives a Connection from the
> Connection class and calls teh Particular Java Class and passes the
> Connection Object as a parameter.
> 3)The Java Class executes the Queries and sends back the Result or ResultSet
> to the Control Servlet
> 4) The Control Servlet now makes a call to the ConnectionManager to Free the
> Connection .(but since the Result Set still has values Connection is not
> freed).
> 5)The JSp Page retrieves the values from the Request Object and Displays the
> values .

Just close it at the end of the page. If you don't each time you open
your page it will create a new occurrence of the connection.

Cheers

Tony Grant
--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL