Thread: connection pooling and open statement objects

connection pooling and open statement objects

From
"G.Nagarajan"
Date:
hi,

 In an earlier discussion, someone had remarked that if the statment
objects are not explicitly closed, the resources allocated to it are not
released. ie,  I have code like this:

 - get Connection object from connection pool
 - create statement object
 - create resultset using the statement
 - process the resultset
 - return the connection object to the connection pool

 This cycle is repeated for all the sql statements in the application. If
the
memory will not be released till the statement object is explicitly closed,
then it
might lead to a memory leak later.

any suggestion or remarks are welcome

regards,
Nagarajan.


Re: connection pooling and open statement objects

From
Dave Cramer
Date:
You should make sure the statements are closed after processing the
result set.

One more thing, you should make sure that you clear the warnings off of
the connection when you return it to the pool, this can be problematic.

Dave
On Mon, 2002-09-09 at 10:09, G.Nagarajan wrote:
> hi,
>
>  In an earlier discussion, someone had remarked that if the statment
> objects are not explicitly closed, the resources allocated to it are not
> released. ie,  I have code like this:
>
>  - get Connection object from connection pool
>  - create statement object
>  - create resultset using the statement
>  - process the resultset
>  - return the connection object to the connection pool
>
>  This cycle is repeated for all the sql statements in the application. If
> the
> memory will not be released till the statement object is explicitly closed,
> then it
> might lead to a memory leak later.
>
> any suggestion or remarks are welcome
>
> regards,
> Nagarajan.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>