differences connection pooling versus session pooling occi/oci

> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l