Re: Connection and Statement

Erwin Ambrosch wrote:

> Hi All!
>
> I wonder 2 issues:
>
> 1. Are there limitations creating statements from a connection.


I don't understand what you are asking here.  Can you explain a little
bit more?

>
> 2. When I use a connection pool which keeps all initialized connection
> open, when is the earliest time I can put  an already retrieved
> connection back. Can I put the connection back, before I have closed all
> created statements, or is this not good practice.


This would not be a good idea.  If you return the connection to the pool
before you are done with all of the statements then the connection is
available for other processes to use.  If someother process uses the
connection while you are still using your statements then that other
process calls commit, it will commit your statements as well since they
all belong to the same connection.

thanks,
--Barry