From: | Tony Grant <tony(at)tgds(dot)net> |
---|---|
To: | John Kunchandy <johnk(at)stylusinc(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Postgres Issue with JDBC |
Date: | 2003-05-05 10:07:38 |
Message-ID: | 1052129258.1583.26.camel@vaio |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeroen Habets | 2003-05-05 10:32:47 | Re: Postgres Issue with JDBC |
Previous Message | John Kunchandy | 2003-05-05 09:53:40 | Re: Postgres Issue with JDBC |