Hi Wolfgang
>Forgive my ignorance, but my impression was (is) that the entire =
purpose of
>a connection pool is to reuse and not close the connections.
When you work with connection pools there are two "type" of =
connections... let's take an example:
- The connection pool is defined, for example, at application server =
level. You give it a name, let's say MYPOOL.
- When the connection pool is initialized some "real" connections are =
opened.
- An application that needs a connection does a lookup with the name =
MYPOOL and gets a connection from the connection pool. Let's call it =
MYCONN.
- Based on this connection MYCONN some SQL statements are executed.
- When the application has completed its job the connection MYCONN is =
closed. This doesn't mean that the connection with the database is =
close. In fact when a connection which comes from a connection pool is =
closed, the connection is simply given back to the connection pool. But =
from the point of view of the application using MYCONN, it's really =
closed.
HTH
Chris
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 01 2005 - 17:36:45 CST
