Hi,

We are setting up a new library for access to the database where we want to replace the old, still oci 7
interface by occi
When we create a connectionpool with min 3 session max 5, we see 3 sessions in the database
and then we issue a connectionPool->createConnection. Expected behaviour would be that 1 of 3 sesions
will be used. Suprise we got a fourth session in the database according to v$session.

I found some posts that explain that this might be the case because session pooling is used instead of
connection pooling. I don't understand this completely because why would the connectionPool->createConnection
get a new connection and not use the pool? Can this behaviour be influenced somehow to get the expected behaviour?

In the occi manuals there is no reference to sessionPooling but in the oci manuals there is.
Details: Oracle 9.2.0.6, OCCI, HPUX 11.11,

Regards,

Jeroen