RE: Troubles with parses

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

Other related posts: